OPM Accounting Pre-processor Does Not Process All Transactions Types Including Intercompany Sales Order Issues (Doc ID 1638298.1)

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.

Symptoms

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'

QUERY:


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
FROM MTL_PARAMETERS
WHERE PROCESS_ENABLED_FLAG='Y'
)
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

RESULTS:
  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

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