Aging - 7 Buckets - By Account Report (ARXAGFW) Fails - REP-1401: 'comp_amt_due_rem_invformula' ORA-06502: PL/SQL: Numeric or Value Error (Doc ID 2019038.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Report: ARXAGFW - Aging - 7 Buckets - By Account Report
Report: ARXAGMW.rdf

Symptoms

You are attempting to run the Aging - 7 Buckets - By Account Report (ARXAGFW) and receive the following error:

REP-1401: 'comp_amt_due_rem_invformula': 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: 'comp_amt_due_rem_invformula': Fatal PL/SQL error occurred.
ORA-06502: PL/SQL: numeric or value error

Program exited with status 1

CT indicates the error only occurs when the following occurs:

This only occurs when you do the following:
1. Update the profile option ICX: Numeric Characters at the User level to 10.000,00
Site Level:  10,000.00
User Level: 10.000,00

2. Run the report and set report parameter Amount Due High to a decimal value like '-.01'

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms