I got a requirement to create PO Receipt using PL/SQL code. For that i have created PL/SQL code to insert data in following Interface tables,
After inserting data in Interface table executed Concurrent Program "Receiving Transaction Processor" to process data from Interface table to Base Table. This process is working perfectly fine for "Non-Catalog" requests. But if i try to process any PO having Inventory Item whose Serial Control is set to "At Receipt" then i got following error at Interface table,
"Fail to validate serials".
To resolve this issue i need to create and process serial number for Ordered Item selected to Receive. Can anyone guide me regarding how can I generate Serial Numbers using API for PO Receipts.
Just populate mtl_serial_numbers_temp table correctly (by specifying transaction_temp_id = RTI.interface_transaction_id)
and serial number range in fm_serial_number - to_serial_number respectively.
You may entermultiple MSNT records with same transaction_temp_id.
You may need to populate PRODUCT_TRANSACTION_ID = RTI.interface_transaction_id and PRODUCT_CODE = 'RCV'.
Oracle will create all the serial numbers for you when the records get processed.