Aug 26, 2009

Cost Accounting Data Flow in SLA - Inventory Transactions

Sub Ledger Accounting (SLA) is an enhanced accounting process and uses a rules-based accounting engine that posts entries into GL. Instead of different sub-ledgers posting data to GL, the transfer to GL is now centralized through SLA. I would like to highlight the data flow for cost accounting in SLA for inventory transactions as seen in the image below:



I would start with the inventory transactions. Different modules like WIP, OM and other external applications populate the MTI tables. The inventory interface manager (transaction manager - INCTCM) runs and validates the data and inserts the records into MTL_MATERIAL_TRANSACTIONS_TEMP table. When the transaction worker processes the temp data, the records are inserted into the transactions history table (MMT).

When the Cost Manager runs, it costs the transactions, and creates SLA events. Pl note in 11i, the cost manager used to create accounting as well.

When the Create Accounting (Cost Management) process runs, it creates the accounting. When the transfer to GL is run from SLA, it transfers all the accounting data to GL.