"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

(Doc ID 1488847.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS
This document applies to all of 11i and R12

Symptoms

Issue 1:
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 :

ERROR
-----------------------
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.

Issue 2:
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.

Input:
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

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