“Inventory transaction worker” Program

Open Transaction Interface supports following type of transactions:

·         Inventory issues and receipts (including user-defined transaction types)

·         Subinventory transfers

·         Direct inter-organization transfers

·         In transit Shipments

·         WIP component issues and returns

·         WIP assembly completions and returns

·         Sales Order shipments

·         Inventory Average Cost Updates

·         With a miscellaneous transaction users can issue material to or receive material from general ledger accounts in your current organization

What is the difference between "Transaction Open Interface" and "Pending Transactions"

· Navigate Inventory Responsibility -> Transactions -> Transaction Open Interface

This form queries the MTL_TRANSACTIONS_INTERFACE table

· Navigate Inventory Responsibility -> Transactions -> Pending Transactions

This form queries the MTL_MATERIAL_TRANSACTIONS_TEMP table

Q. What is the MTL_TRANSACTIONS_INTERFACE table used for?

A. This is the Interface between non-Inventory applications and the Inventory Transactions module.

In other words any other module other than Inventory that wants to update Inventory has to come through this table. Modules such as WIP (Work In Progress) and OE (Order Entry) first pass their records to the MTL_TRANSACTIONS_INTERFACE (MTI) for validation.

The Transactions Manager (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 - INCTCW) which then process these records through inventory. This process consists of data derivation, validation, and the transfer of records from MTL_TRANSCTIONS_INTERFACE, MTL_TRANSACTIONS_LOTS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE into their associated TEMP (temporary) tables from where the transactions processor processes them.

Q. What is the MTL_MATERIAL_TRANSACTIONS_TEMP table used for?

A. 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 the Inventory and Purchasing modules which write transactions directly into this table after validation.

Inventory Module Forms like the Miscellaneous transactions form write directly into this table. The transactions which are created through this form are via on-line processing. It is from this table that the inventory quantities finally get updated and serial/lot numbers get updated.

Navigation Inventory:Transactions >Transaction Open Interface

Click in the check box under the "Submit" column then Save