Last updated on NOVEMBER 16, 2016
Applies to:Oracle Process Manufacturing Financials - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Subledger Accounting
Not all inventory transactions (mtl_material_transactions) are processed by the OPM Pre-Processor.
A script similar to the one below reveals that many transactions than have not posted yet i.e. OPM_COSTED_FLAG = 'N' i.e. Create Accounting has not be run in Final Mode for them because the transactions were not previously picked up by the Pre-Processor.
N.B. If the transactions had been picked up by the OPM Pre-Processor but Create Accounting had not yet been run in Final Mode, this column would be set to 'D'
SELECT distinct MT.TRANSACTION_TYPE_NAME,MT.TRANSACTION_TYPE_ID,COUNT(MMT.TRANSACTION_ID)
FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_TRANSACTION_TYPES MT
WHERE MMT.ORGANIZATION_ID IN
(SELECT DISTINCT ORGANIZATION_ID
AND MMT.TRANSACTION_DATE BETWEEN (SYSDATE-720) AND (SYSDATE-60)
AND MMT.OPM_COSTED_FLAG = 'N'
AND MMT.TRANSACTION_TYPE_ID = MT.TRANSACTION_TYPE_ID
GROUP BY MT.TRANSACTION_TYPE_NAME,MT.TRANSACTION_TYPE_ID
TYPE NAME ID COUNT TRANSACTION
Direct Org Transfer 3 338
Residual Qty Issue 98 48
Container Unpack 88 5676
COGS Recognition 10008 2
Cost Group Transfer 86 5398
Residual Qty Receipt 99 24
Container Pack 87 14816
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms