Interface Trip Stop (ITS) Completed in Warning INV_TXN_MANAGER_PUB: *** SQL Error ORA-01403: No Data Found for Lot Item
(Doc ID 1957082.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Inventory Management - Version 12.0.6 and later
Information in this document applies to any platform.
On : 12.0.6 version, Inventory Transactions
When attempting to run Interface Trip Stop (ITS), the following error occurs.
ERROR ----------------------- [18-DEC-14 14:12:56] INVTXNB: Error from INV worker : error_code : Transaction processor error, err_expl :Negative balances not allowed Current Time is ==> 12/18/2014 02:12:56 PM l_outcome ==> FALSE MTL_ONLINE_TRANSACTION_PUB.process_online returns false Error Code:Transaction processor error Error Explanation:Negative balances not allowed Retrieving messages from the stack Error Code: ==> Transaction processor error Error Explanation:: ==> Negative balances not allowed x_return_status ==> E
Steps to Reproduce
1. Create lot-controlled item and assign to an organization
2. Perform miscellaneous receipt so there is material on-hand
3. Create Sales order and book it
4. Pick release the sales order
5. Ship confirm the sales order
6. See the error
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