Interface Trip Stop Error: "NO SERIAL RECORDS FOUND FOR TRANSACTION_TEMP_ID" - For Non Serial Control Item
(Doc ID 1495054.1)
Last updated on SEPTEMBER 22, 2018
Applies to:Oracle Shipping Execution - Version 12.1 and later
Information in this document applies to any platform.
When running the Interface trip stop it completes with a warning.
The log shows the following error
ERROR: NO SERIAL RECORDS FOUND FOR TRANSACTION_TEMP_ID xxxxxxxx
The item that is stuck is NOT serial controlled.
The delivery detail is interfaced to Order Managment but is showing as Pending interface to Inventory.
This record also shows as pending transaction in the "Unprocessed Shipping Transactions" part of period close form.
User is also not able to find "Sales Order Issue" transaction in the mtl_material transactions table for this Sales Order as it has not interfaced to Inventory.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!