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