Technical overview of the interface managers


Demand Reservation Manager
INCDCM module: Process demand interface

The Demand Reservation Manager periodically updates Inventory with the demands from sales orders shipments.
INCDCM is linked into INVLIBR, the program processes records from mtl_demand_interface to mtl_demand table. Records held in mtl_demand_interface need to have process_flag=1 (ready), transaction_mode=3 and error_code = null.


Resolving Errors:
Regardless of pass or failure, all records failing validation in the interface table will be marked with an error code.  Columns error_code and err_explanation can be selected for explanation of the cause. A succesful demand operation is denoted by error_code=0.
Full errors listings can be determined by selecting, lookup_code and meaning from the table mfg_lookups where lookup_type ='MTL_DEMAND_INTERFACE_ERRORS'

Material & Resource Cost transaction processor (Cost Manager)
The Cost Manager controls both the Material & Resource Cost Transaction Processors. This manager starts the processors at the specified process interval in the launch manager form, The Cost manager itself does not  kick off a concurrent request for each of the intervals, the manager only runs (goes from pending to running then back to pending) once every 24 hours.

Material Cost Processor
CMCMCW module: Material Cost Transaction Processor
This program is used to process material transactions for costing in inventory and WIP products.  This module scans table  mtl_material_transactions for uncosted transactions, ie: where costed_flag='N'& transaction_group_id=NULL. For each transaction found program; INLTCP is called to process the records.

Note:
If this program is not running then there will be no available Transaction Distribution details in the Material Distributions inquiry  form.
Records are inserted into mtl_transaction_accounts, for the account and the value of the transactions.

Resource Cost Processor
CMCCTM module: Resource cost transaction manager
The Resource cost transaction manager processes transactions from Oracle's WIP in addition to those resource transactions imported from  other sorces such as barcode readers.
The program polls pending transactions in wip_cost_txn_interface and periodically updates/inserts into the following WIP tables: wip_transactions, wip_transaction_accounts and wip_period_balances
The program can be run from the command line: CMCCTM bom/bom passwd 0 Y

WIP Move Transaction Manager
WICTMS module:
The WIP Move Transaction Manager processes move transactions in Oracle WIP and move transactions from devices such as bar code readers. The table wip_move_txn_interface is polled by the program WICTMS to determine if any transactions are pending validation and or processing.