Adding Item Quantity

I had to test order import process and i needed to create multiple orders for multiple items. In our test system there was not enough item quantity available, so i used following script to add item qunatity as 'Miscellaneous receipt'. This script worked fine for me. All the records added to material transaction interface, will get picked by next execution of concurrent program 'Process transaction interface'. If this program is not scheduled to run then it can be executed using 'Inventory' Responsibility and select Setup -> Transaction Managers. Select 'Material transaction' and then hit Tools -> Launch Manager. It will start 'Process transaction interface'. DECLARE -- l_code_loc VARCHAR2(90); l_org_id MTL_SYSTEM_ITEMS_B.organization_id % TYPE; l_locator_id MTL_ITEM_LOCATIONS.inventory_location_id % TYPE; l_trx_type_id MTL_TRANSACTION_TYPES.transaction_type_id % TYPE; l_gl_acct MTL_SECONDARY_INVENTORIES.material_account % TYPE; l_sub_inventory MTL_SECONDARY_INVENTORIES.secondary_inventory_name % TYPE; l_sub_inv MTL_SECONDARY_INVENTORIES.secondary_inventory_name % TYPE; -- -- This cursor get list of item for qunatity addition. This -- query could be modified to select just a single item too -- CURSOR c_items IS SELECT inventory_item_id, segment1 , segment2 , segment3 FROM mtl_system_items_b a , vvinv_styles b WHERE a.segment1 LIKE &seq1 AND segment2 LIKE &seg2 AND segment3 LIKE &seg3 AND a.default_shipping_org = l_org_id AND a.organization_id = l_org_id AND a.customer_order_enabled_flag = 'Y' AND a.segment1 = b.style_code AND b.advanced_order_flag = 'N' AND ROWNUM = 1 ;BEGIN l_org_id := &org_id ; l_sub_inv := &sub_inv; -- -- l_code_loc := 'Get transaction type id'; SELECT transaction_type_id INTO l_trx_type_id FROM mtl_transaction_types WHERE transaction_type_name = 'Miscellaneous receipt' ; -- -- Get inventory name and account -- l_code_loc := 'Get inventory name'; SELECT secondary_inventory_name, material_account INTO l_sub_inventory , l_gl_acct FROM MTL_SECONDARY_INVENTORIES WHERE secondary_inventory_name = l_sub_inv ; -- -- Get Item location -- l_code_loc := 'Get item location'; SELECT inventory_location_id INTO l_locator_id FROM mtl_item_locations WHERE subinventory_code = l_sub_inventory AND disable_date IS NULL AND enabled_flag = 'Y' AND ROWNUM = 1 ; -- -- Loop through item cursor and add record for each item -- l_code_loc := 'For Loop'; FOR l_rec IN c_items LOOP INSERT INTO mtl_transactions_interface ( source_code , source_line_id , source_header_id , process_flag , transaction_mode , last_update_date , last_updated_by , creation_date , created_by , inventory_item_id , organization_id , transaction_quantity , transaction_uom , transaction_date , subinventory_code , locator_id , transaction_type_id , distribution_account_id ) VALUES ( 'Manual' --SOURCE_CODE, , 11 --SOURCE_LINE_ID, , 11 --SOURCE_HEADER_ID, , 1 --PROCESS_FLAG, , 3 --TRANSACTION_MODE, , SYSDATE --LAST_UPDATE_DATE, , -1 --LAST_UPDATED_BY, , SYSDATE --CREATION_DATE, , -1 --CREATED_BY, , l_rec.inventory_item_id --INVENTORY_ITEM_ID, , l_org_id --ORGANIZATION_ID, , 25 --TRANSACTION_QUANTITY, , 'EA' --TRANSACTION_UOM, , SYSDATE --TRANSACTION_DATE, , l_sub_inventory --SUBINVENTORY_CODE, , l_locator_id --LOCATOR_ID, , l_trx_type_id --TRANSACTION_TYPE_ID , l_gl_acct ) ; END LOOP;EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Error Encountered at ' l_code_loc); dbms_output.put_line('Error :'SQLERRM);END;