Billing And Receipt History Ends With Error (Doc ID 2206819.1)

Last updated on AUGUST 07, 2020

Applies to:

Oracle Receivables - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Billing and Receipt History report,
the following error occurs.

ERROR
-----------------------

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.WE8ISO8859P1
'.,'
Enter Password:
MSG-00101: Consolidated Billing Profile: Y
REP-1401: 'd_invoice_amountformula': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00101: Consolidated Billing Profile: Y
REP-1401: 'd_invoice_amountformula': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Billing and Receipt History report and completed with error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get Billing and Receipt History report .