Expense Item Costs Are Not Showing In The MTL_TRANSACTION_ACCOUNTS Table (Doc ID 472703.1)

Last updated on JULY 16, 2017

Applies to:

Oracle Cost Management - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

 Many costed records in MTL_MATERIAL_TRANSACTIONS but they do not have related distributions in the MTL_TRANSACTION_ACCOUNTS table.  Expect these items to have values in the table for correct reporting and processing.

Steps To Reproduce:
----------------------
1- Run the following query to check the transactions
SELECT * FROM
MTL_MATERIAL_TRANSACTIONS
WHERE TRANSACTION_ID NOT IN (SELECT TRANSACTION_ID FROM
MTL_TRANSACTION_ACCOUNTS)

The records do exist in mtl_cst_actual_cost_details and mtl_cst_txn_cost_details
but have not been transferred to the mtl_transaction_accounts table.  The Cost
Manager did not pick these up and transfer to the table to be used in reports and
in transfer to general ledger.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms