有没有API可以插入一条数据进入MTL_MATERIAL_TRANSACTIONS

whefw

现在我们想往MTL_MATERIAL_TRANSACTIONS插入一条数据，但是客户不让直接insert数据到表里，

我想请问一下有没有相应的API的insert_row来实现这个功能，找了半天没找到

tianpan

永远不要直接插记录到MMT，可以通过接口表来插库存数据。
http://blog.csdn.net/pan_tian/article/details/8740567

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 FlowBasic 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 FlowRefer: INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS：http://blog.csdn.net/pan_tian/article/details/8289958

INV Transaction Manager Related FilesINV 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.



How to launch Inventory Interface Manager ManuallyMaterial Transaction一般为定时运行，比如每隔五分钟运行一次。如果需要手工运行，可以参照下面的路径

路径: Inventory > Setup > Transactions > Interface Managers



How to schedule Inventory Interface ManagerRefer:http://blog.csdn.net/pan_tian/article/details/8637819


How to restart Inventory Manager
1.) Login as System Administrator
2.) Concurrent > Manager > Administer
3.) Check/Re-start Inventory Manager,Inventory Remote Procedure Manager


Number of Processes(Workers) for Concurrent Manager Refer:http://blog.csdn.net/pan_tian/article/details/8287861


Inventory Transaction Scripts
Refer: Using script to submit INV Manager to process MTI/MMTT:http://blog.csdn.net/pan_tian/article/details/7711155

albert.lgr

透過接口表來操作：MTL_TRANSACTIONS_INTERFACE