Return Status Variable (x_return_status) From API INV_TXN_MANAGER_PUB.Process_Transactions is 'S' (successful) Even Though The Record Is Stuck in MTL_TRANSACTIONS_INTERFACE With Error
(Doc ID 3050925.1)
Last updated on OCTOBER 01, 2024
Applies to:
Oracle Inventory Management - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
The API INV_TXN_MANAGER_PUB.process_Transactions returns 'S' (success) in the output variable x_return_status even though the record is stuck in interface table mtl_transactions_interface with an error message.
Note: The above procedure inserts the data into mtl_transactions_interface and call inv_txn_manager_pub.process_transactions
STEPS
1. Run API Inv_txn_manager_pub.Process_Transactions (with above sample code)
2. See API errors out and record is stuck in Mtl_Transactions_Interface, but x_return_status is 'S'
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 |
Cause |
Solution |
References |