While running "Unapplied Receipts Register" completing with below error in Oracle APPS R12.
REP-0004: Warning: Unable to open user preference file.
MSG-00100: BeforeReport_Procs.Set_Sort_Order
MSG-00200: Total forAGENCY:
REP-1401: 'report_subtitleformula': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.AR_MO_GLOBAL_CACHE", line 55
ORA-06512: at "APPS.ARP_STANDARD", line 3021
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: m
REP-1401: MSG-00100: BeforeReport_Procs.Set_Sort_Order
MSG-00200: Total forAGENCY:
REP-1401: 'report_subtitleformula': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.AR_MO_GLOBAL_CACHE", line 55
ORA-06512: at "APPS.ARP_STANDARD", line 3021
Solution: As mentionbed in Oracle Note Document ID 418261.1 "Unapplied Receipt Register" is Obsoleted in R12.
Below are the comments from Oracle Note.
"In Release 12, the Unapplied Receipt Register has been made Obsoleted.
The Unapplied and Unresolved Receipts Register is a new RXI report which gives you the ability to change the columns on the report as needed with the Report eXchange Designer responsibility."
Keep posting.
ReplyDeleteNice information.
ReplyDeleteThanks for sharing
ReplyDelete