CSTPACIN.COST_INV_TXN:Unexpected error in CST_RevenueCogsMatch_PVT . Insert_OneSoIssue ( 30 ): ORA-01400: cannot insert NULL into ("BOM"."CST_REVENUE_COGS_MATCH_LINES"."DEFERRED_COGS_ACCT_ID") (Doc ID 1508111.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked on Relevance on 13-MAR-2018 ***

Symptoms

On : 12.1.3 version, Costing Transaction Errors

Sales Order issue transaction fails with:


ERROR
-----------------------
CSTPACIN.COST_INV_TXN:Unexpected error in CST_RevenueCogsMatch_PVT . Insert_OneSoIssue ( 30 ): ORA-01400: cannot insert NULL into ("BOM"."CST_REVENUE_COGS_MATCH_LINES"."DEFERRED_COGS_ACCT_ID")


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Review material transactions

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