"Organization ID Is Either Blank Or Invalid" while using the INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS API to Upload Move Orders to the MTL_TRANSACTIONS_INTERFACE (MTI) Table
Last updated on MARCH 27, 2018
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
This document applies to all of 11i and R12
While trying to automate transactions by loading move orders using the INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS API, while the Organization ID is correctly filled, the following error occurs in the MTL_TRANSACTIONS_INTERFACE (MTI) table :
Organization ID is either blank or invalid. Please re-enter
Note: The Org_ID used is a child organization and the item is correctly setup for the specific transaction.
Another similar example reported:
Can't complete Move Order when using inserting into MTL_TRANSACTIONS_INTERFACE.
Trying to use the MTI interface to move quantities from A subinventory to B subinventory.
Load move order data into mtl_transactions_interface and
mtl_transaction_lots_interface, then run "Launch Interface Managers".
The move order process is not successful, we get error message:
"Subinventory code is either not entered or not valid for the given organization" in table mtl_transactions_interface.
Customer reports that he checked item on-hand quantity, lot number expiration date, etc, but is unable to resolve the issue
Error Message:|Error: The material pick release and pick confirm process completed with errors.|ORA-01403: no data found in Package INV_Trolin_Util Procedure
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