My Oracle Support Banner

OPM Accounting Pre-Processor Is Completing With Error: ORA-01400: cannot insert NULL into ("BOM"."CST_REVENUE_COGS_MATCH_LINES"."COGS_ACCT_ID") (Doc ID 2510565.1)

Last updated on DECEMBER 04, 2019

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, Actual Cost Process

When attempting to run the OPM Pre-processor for all sources for the period
the following error occurs.

ERROR
-----------------------
OTHERS EXCEPTION IN Insert_OneSoIssue:ORA-01400: cannot insert NULL into ("BOM"."CST_REVENUE_COGS_MATCH_LINES"."COGS_ACCT_ID")
PROGRAM_EXCEPTION IN Match_RevenueCOGS at (10):
Unexpected error in CST_RevenueCogsMatch_PVT . Insert_OneSoIssue ( 30 )
Unable to insert the sales order issue transaction into the Revenue / COGS Matching data model.
OM Line ID = &COGS_LINE_ID
MMT Transaction ID = xxxxx (COGS_OM_LINE= xxxx
Error in CST_RevenueCogsMatch_PVT . Match_RevenueCOGS ( 10 )


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: OPM Financials
2. Navigation: OPM Pre-Processor



Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.