Rebuilding Trial Balance Data Ends in Error XLA-95103 or ORA-06502: PL/SQL: numeric or value error
Last updated on MARCH 08, 2017
Applies to:Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Cannot rebuild trial balance data but get errors like:
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: -:
XLA-95103: An internal error occurred. Please inform your system
administrator or support representative that:
An internal error has occurred in the program
xla_tb_data_manager_pkg.define_segment_ranges. ORA-06502: PL/SQL: numeric or value error:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 110
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 289
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 162
ORA-06512: at "APPS.XLA_TB_DATA_MANAGER_PVT", line 1631
ORA-06512: at line 1
All Recommended TB Patches have been applied.
The same error occurs no matter if the definition is created using segments or flexfields.
User should be able to add in any new account code combinations
and segment values to the report definition and the rebuild process should compile the report definition.
The issue can be reproduced at will with the following steps:
1. Payables Responsibility > Setup > Accounting Setups > Subledger Accounting
Setups > Open Account Balances Listing Definitions
2. Query the Report Definition Code
3. Click on update and add in the new account range and click on apply
4. Rebuild process would be spawned.
The issue has the following business impact:
Due to this issue, users cannot get the correct Data in Trial Balance Report which in turn stops to proceed with reconciliation between AP and GL.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms