My Oracle Support Banner

Aging Report Error: Various Aging Reports fail with ORA-01722: invalid number (Doc ID 1061714.1)

Last updated on FEBRUARY 07, 2018

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
ARXAGSW module: Aging - 7 Buckets Report


Symptoms

When running various Aging reports, such as Aging - 7 Buckets or Aging - 7 Buckets by Account Report fails with the error:
ORA-01722: invalid number

The Log file Shows:

ARXAGSW module: Aging - 7 Buckets Report
+---------------------------------------------------------------------------+
Enter Password:
ORA-01722: invalid number
SELECT param . org_id param_org_id , sob . name Company_Name , sob . chart_of_accounts_id coaid , sob . currency_code Functional_Currency , cur . precision Functional_Currency_Precision , decode ( : p_in_currency , NULL , 'Y' , NULL ) convert_flag ,
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: invalid number
SELECT param . org_id param_org_id , sob . name Company_Name , sob . chart_of_accounts_id coaid , sob . currency_code Functional_Currency , cur . precision Functional_Currency_Precision , decode ( : p_in_currency , NULL , 'Y' , NULL ) convert_flag ,

Changes

 

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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