Tuesday, February 15, 2022

"Unapplied Receipt Register" report completing with Error in Oracle Apps R12

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

3 comments:

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)