My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.