Subledger And General Ledger Analysis Report Error: ORA-01722: invalid number
Last updated on DECEMBER 04, 2016
Applies to:Oracle Fusion Assets Cloud Service - Version 220.127.116.11.0 and later
Oracle Fusion Assets - Version 18.104.22.168.0 and later
Oracle Fusion General Ledger - Version 22.214.171.124.0 and later
Oracle Fusion General Ledger Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
When running the Subledger and General Ledger Analysis Report, the process ends in error with the log message below:
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.
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
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