Interface Trip Stop (ITS) Fails For Return To Vendor (RTV) When LPN Is Moved To A Different Location
(Doc ID 2846932.1)
Last updated on MAY 31, 2022
Applies to:
Oracle Inventory Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.9 version, Inventory Transactions
ITS fails for RTV order(Return to Vendor)
ERROR
-----------------------
Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (12/14/2020 04:19:21 AM, 0 seconds)
Interface_Detail_To_Inv l_inv_inter_status ==> S
Entering WSH_SHIP_CONFIRM_ACTIONS.PROCESS_INV_ONLINE (WSHDDSHB.pls 120.35.12020000.18) (12/14/2020 04:19:21 AM)
p_batch_id ==> 4015854
P_TRANSACTION_HEADER_ID ==> 828298416
Number of rows updated ==> 0
Current Time is ==> 12/14/2020 04:19:21 AM
RIGHT BEFORE CALLING MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
TIMEOUT VALUE: 1200
Calling program unit MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
[14-DEC-20 04:19:21] INV_TXN_MANAGER_PUB: -----Inside process_Transactions-------.trxhdr=828298416
[14-DEC-20 04:19:21] INV_TXN_MANAGER_PUB: Inv Batch size:0
[14-DEC-20 04:19:21] INV_TXN_MANAGER_PUB: MTI Rows cnt before Validation=0
[14-DEC-20 04:19:21] INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |