Interface Trip Stop Error: "NO SERIAL RECORDS FOUND FOR TRANSACTION_TEMP_ID" - For Non Serial Control Item
Last updated on DECEMBER 14, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms