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 MAY 01, 2018

Applies to:

Oracle Inventory Management - Version 12.0.6 and later
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms