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 →

4 04America/Sao_Paulo fevereiro 04America/Sao_Paulo 2020 0

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 →

8 08America/Sao_Paulo julho 08America/Sao_Paulo 2019 0

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 →

4 04America/Sao_Paulo novembro 04America/Sao_Paulo 2018 0

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 →

12 12America/Sao_Paulo fevereiro 12America/Sao_Paulo 2018 0

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 →

8 08America/Sao_Paulo janeiro 08America/Sao_Paulo 2018 0

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 →

5 05America/Sao_Paulo janeiro 05America/Sao_Paulo 2018 0

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 →

2 02America/Sao_Paulo janeiro 02America/Sao_Paulo 2018 0

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 →

15 15America/Sao_Paulo agosto 15America/Sao_Paulo 2016 0