My Oracle Support Banner

Generate COGS Recognition Events failed with ORA-01403: No Data Found (Doc ID 2751556.1)

Last updated on FEBRUARY 11, 2021

Applies to:

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

Symptoms


On Oracle Apps Version: 12.2.6


Execution of CSTRCMCR3: Generate COGS Recognition Events as part of the COGS
Revenue recognition process failed with error:

OTHERS EXCEPTION IN Create_CogsRecognitionEvents:ORA-01403: no data found
PROGRAM_EXCEPTION IN Match_RevenueCOGS at (50):
Unexpected error in CST_RevenueCogsMatch_PVT . Create_CogsRecognitionEvents (
25 )
Error in CST_RevenueCogsMatch_PVT . Match_RevenueCOGS ( 50 )

In review of cogs diagnostics output - cogs_diag,sql :

CST_COGS_EVENTS Data has only Sales order Issue event and no COGS Rev Recognition 
Event.

CST_REVENUE_RECOGNITION_LINES Data contains a record for REVENUE_OM_LINE_ID = &Revenue_om_line_id
 
Currently running CSTRCMVB.pls 120.83.12020000.58 with high mark and issue still  persists.

Changes

 

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
Changes
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.