My Oracle Support Banner

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 JULY 13, 2022

Applies to:

Oracle Inventory Management - Version 12.0.6 and later
Oracle Shipping Execution - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

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

 

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.