Inventory Transactions Manager

Overview

Inventory Transaction Manager用于处理库存接口表(MTL_TRANSACTION_INTERFACE或者MTL_MATERIAL_TRANSACTIONS_TEMP)中的记录，处理之后最终产生库存事务(MTL_MATERIAL_TRANSACTIONS)。

(补：MTL_MATERIAL_TRANSACTIONS里记录了所有库存事务的历史，是Inventory的最核心的表)

Oracle R12 Inventory有两套接口表：

1.MTL_TRANSACTIONS_INTERFACE (MTI) :主要用于第三方模块（产品）数据的导入，如Order Management, WIP。对应的Form为Transaction Open Interface。

2.MTL_MATERIAL_TRANSACTIONS_TEMP(MMTT)：Inventory,Purchasing,WIP,Move Order等相关模块的数据可以绕过MTI,直接写到MMTT中，最终Inventory Transaction Mannager会把这个临时表数据导入到库存事务表(MTL_MATERIAL_TRANSACTIONS)中。

对应的Form为，Pending Transactions Form。

What's Inventory Transaction Manager?

Transaction Manager processes all the material and financial movements into, within and out of an organization

Example: PO receipt into an organization or, subinventory transfer from one physical location to another or, sales order issue to a customer

The main function of the inventory module is to track, manage and control the flow of material within, coming from and going out of an organization.

Transaction manager is the core component of the inventory module and is used to process all the transactions for material handling.

Table Flow

Basic Flow: MTI -> MMTT -> MMT

Table Values

Refer: TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG,TRANSACTION_STATUS in MTI or MMTT,
http://blog.csdn.net/pan_tian/article/details/7899178

Inv Manager Code Flow

Refer: INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS：http://blog.csdn.net/pan_tian/article/details/8289958

INV Transaction Manager Related Files

INV Transaction Manager is the set of procedures(JAVA files and PLS files), which process the variable Inventory transactions like Misc Issue/Receipt, Inter-Org Transfer, and so on.