Olá, nesse post irei demostrar como configurar o AME para entradas de estoque ( miscellaneou receipt ) Primeira configuração que precisa ser feita é procurar o tipo de ordem INV ERES Miscellaneous Receipt, para isso é necessário logar com um usuário com as rules configuradas, no nosso exemplo iremos usar o AME_ADMIN Segunda configuração é... Continuar Lendo →
Create or Update Category Codes
Hi, this post I will show how to create or update category_codes on Inventory Category. Create DECLARE v_return_status VARCHAR2(1) := NULL; v_msg_count NUMBER := 0; v_msg_data VARCHAR2(2000); v_errorcode VARCHAR2(1000); l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type; x_category_id NUMBER; v_context VARCHAR2 (2); l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2(1000); BEGIN fnd_global.apps_initialize (1139, 20634, 401); l_category_rec.structure_id := 50412; l_category_rec.segment1 := 'Milton'; l_category_rec.description :=... Continuar Lendo →
Create miscellaneous receipt and issue with API
Hi, this post I will show how create an miscellaneous transaction with API Receipt INSERT INTO mtl_transactions_interface ( source_code --01 , source_line_id --02 , source_header_id --03 , process_flag --04 , transaction_mode --05 , validation_required --06 , inventory_item_id --07 , organization_id --08 , subinventory_code --09 , transaction_quantity --10 , transaction_uom --11 , primary_quantity --12 , transaction_date... Continuar Lendo →
Working with shrinkage rate MRP / ASCP
There is a setting called a loss rate within the item master record that can be used to determine a loss percentage for the item. Ex without setup the item: Demand de qtde 10 para 10-jan-2019 Supply de qtde 10 para 10-jan-2019 With setup Item to 0.5 = 50% loss. Demand of quantity 10 para... Continuar Lendo →
API Create Reservations
In This Post I want to show how create a reservations using API Oracle Some times it's necessary to use API for work with integrations. The script below can be used for create a reservation. DECLARE l_rsv_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE; l_new_rsv_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE; l_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; l_new_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; x_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2 (2) := FND_API.G_TRUE;... Continuar Lendo →
Restricting Subinventory for Transfers
In this post I will show the functionality that can be useful for controlling the traffic of material from one location to another. Within Oracle you can make item transfers from one sub-inventory to another. After the source subinventory and destination subinventory and the source list will appear all active subinventors that allow transfers. But... Continuar Lendo →
Setup Returnable Item
In this article I will show that to make a return within the Order Management it is necessary to make a setup inside the Master Items. The example below shows the message when you try to record a return in Order Management. In this case it is necessary to make the setup below in the... Continuar Lendo →
Create Exceptions Sets
In this post I will shw how to create an exception set, and assign it to an item and simulate two examples. The Oracle Planning Module there are exceptions for you to control your production plan, but it allows you to make exceptions records as you need them. Shortage Exceptions After did this registration you... Continuar Lendo →
Setup Inventory Master Organization
Today I will show the setup that determines when an inventory organization is actually Master, in which you can have your settings defined at its level a by the hierarchy will serve the other organizations. There is no specific configuration that determines which organization is Master or not, so that it is considered, you must... Continuar Lendo →