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 →

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 →

Powered by WordPress.com. Tema: Baskerville 2 por Anders Noren

Acima ↑