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