Subledger And General Ledger Analysis Report Error: ORA-01722: invalid number (Doc ID 2203590.1)

Last updated on DECEMBER 04, 2016

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Assets - Version 11.1.11.1.0 and later
Oracle Fusion General Ledger - Version 11.1.11.1.0 and later
Oracle Fusion General Ledger Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When running the Subledger and General Ledger Analysis Report, the process ends in error with the log message below:

ERROR
-----------------------
 Cause: An internal error has occurred in the program xla_acct_analysis_rpt_pkg.beforeReport , ORA-01722: invalid number.
 Action: Inform your system administrator or support representative.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Schedule Processes > click Schedule New Process button
2. Search for Subledger and General Ledger Analysis report
3. Enter the required parameters
4. Click Submit and the process errors with above



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