Oracle Inventory Transaction Interface

MTL_TRANSACTIONS_INTERFACE Table

This is the Interface between non-Inventory applications and the Inventory Transactions module. For example, if non-Inventory modules such as WIP (Work In Progress) and OE (Order Entry) want to update Inventory, has to first pass their records to the MTL_TRANSACTIONS_INTERFACE (MTI) for validation.

This form queries the MTL_TRANSACTIONS_INTERFACE table from front-end:
         Navigate Inventory Responsibility -> Transactions -> Transaction Open Interface

Make sure that status for material transaction manager is “Active”. If the status says “Inactive” Launch "Material Transaction Manager" from Inventory setup module.

‘Inventory Super User’ responsibility -> Oracle Inventory -> Setup -> Transactions -> Interface Manager -> Select Organizations/Sub-Inventory  -> Material Transaction ->

Menu Bar -> Tools -> Launch Manager

This will schedule a concurrent program called 'Process transactions interface' (Short Name: INCTCM) every 5 minutes. INCTCM reads records from the MTI table, validates them and moves the successful transactions into the MTL_MATERIAL_TRANSACTIONS_TEMP table, and submits Transaction workers (sub-processes: 'Inventory transaction worker', Short Name: INCTCW) which then process these records through inventory. Only records will be picked up by the Transaction Manager and assigned to a Transaction Worker.

It is important to note that Only records of MTI table will be picked up by the Transaction Manager and assigned to a Transaction Worker for those the following fields are set as follows:

TRANSACTION_MODE = 3,
LOCK_FLAG = 2,
PROCESS_FLAG = 1

 If a record fails to process completely, then PROCESS_FLAG will be set to '3' and ERROR_CODE and ERROR_EXPLANATION columns of MTI table will be populated with the cause for the error.

PROCESS_FLAG
1 = Pending
2 = Running
3 = Error

How to Resubmit Unprocessed Transactions Stuck in the MTL_TRANSACTIONS_INTERFACE Table:
For example, if record fails to process due to error 'No open period found for date entered'. Now, we open Inventory Period and then update this PROCESS_FLAG by below steps:
1.  Navigate to Inventory Responsibility -> Transactions -> Transaction Open Interface
2.  Select the stuck line by click on check box and click on 'Save' icon.
3.  Now, PROCESS_FLAG will set to 1 and records is available to be pick by INCTCM.

MTL_MATERIAL_TRANSACTIONS_TEMP table

The transactions are passed to the MTL_MATERIAL_TRANSACTONS_TEMP table after initial validation by the Transactions Manager (INCTCM) from the MTL_TRANSACTIONS_INTERFACE. A job id is attached and a Transactions Worker (INCTCW) is submitted by the INCTCM process to get the records processed and moved to the MTL_MATERIAL_TRANSACTONS table.

This table is also used by Inventory Module and Purchasing module which writes directly onto this table for any transactions entered within itself and each transaction in turn through a process of strict validation.

This form queries the MTL_MATERIAL_TRANSACTIONS_TEMP table from front-end:

       Navigate Inventory Responsibility -> Transactions -> Pending Transactions

How to Resubmit Unprocessed Transactions Stuck in the MTL_MATERIAL_TRANSACTION_TEMP Table:
To resubmit all Pending Transactions from the Applications:
Navigation Inventory>Transactions>Pending Transactions>Tools>Submit All
This will choose all records for resubmission.
Click the Save icon.