Goal
Is there some documentation/white paper that explains the technical details of
how the Cost Collector works? The details are needed to help with custom reports.
Solution
Summary of the process:
----------
The Cost collection Manager processes transaction in the mtl_material_transactions table that are
project related and ready to be transferred to projects. The transactions must have costed_flag =
null to indicate that the cost manager processed the inventory and wip transactions correctly.
Then the pm_costed_flag is set to N which indicates it is ready for processing to projects when
the cost collection manager is launched and the cost collection worker then processes the
transaction to the transaction interface table. At this point, the PA transaction import process
is called from Projects.
The Process Flow:
---------------
Inventory Transactions WIP Transactions
|
Processed by Cost Manager
|
Inventory Distributions WIP Distributions
|
Manufacturing Cost Transfer for Projects -Cost Collector
|
Transaction Import Interface (pa_transaction_interface_all table)
|
PA Transaction Import
|
Project Expenditures
In the mtl_material_transactions table, the transactions to transfer have the following values:
pm_cost_collected = 'N'
pm_cost_collector_group_id=null
error_code = null
error_explanation = null
This group of values is what the cost collection manager sees and spawns the cost collection
worker to process the transactions.
The transactions pass with the project, task, expenditure type, expenditure org and expenditure
date from mtl_material_transactions to the interface table.
CMCCCM - Cost collection manager cmcccm.opp - Project Manufacturing Cost Collector Manager
The Cost Collector Manager invokes the Material and WIP workers
CMCCCI - Material cost collection worker
CMCCCW - WIP Cost Collection Worker
CSTPPCCB.pls CST_PRJMFG_COST_COLLECTOR
This package has every possible detail needed to cost collect
a manufacturing Transaction ( Material as well as Resource )
that relates to project world. The transactions are cost
Collected to create Project Accounting transactions in the
PA_Transaction_interface Table.