My Oracle Support Banner

Revenue Recognition Error: Program show Phase Complete But Status = Error (Doc ID 1115523.1)

Last updated on APRIL 07, 2023

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
ARBARL Revenue Recognition
ARTERRPM Revenue Recognition Master Program
ARTERRPW Revenue Recognition with parallel workers


Symptoms

Revenue Recognition program fails with the following error

ERROR
-----------------------
MSG-01000: DEBUG: BeforeReport_Procs.Get_Flex_Account.
MSG-01000: DEBUG: BeforeReport_Procs.Setup_Who_Data.
MSG-02000: User-Defined Exception
REP-1401: 'c_pp_auto_ruleformula': Fatal PL/SQL error occurred.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_SYS_PARAMETERS", line 68
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_SYS_PARAMETERS_PVT", line 390
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_PROFILE", line 87
ORA-06512: at "APPS.ARP_AUTO_RULE", line 2658

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: 
REP-1401: MSG-01000: DEBUG: BeforeReport_Procs.Get_Flex_Account.
MSG-01000: DEBUG: BeforeReport_Procs.Setup_Who_Data.
MSG-02000: User-Defined Exception
REP-1401: 'c_pp_auto_ruleformula': Fatal PL/SQL error occurred.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_SYS_PARAMETERS", line 68
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_SYS_PARAMETERS_PVT", line 390

 

Revenue Recognition Master program works fine.

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


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