R12: XLA: Rebuilding Trial Balance Data Ends in Error XLA-95103 or ORA-06502: PL/SQL: numeric or value error
(Doc ID 1902533.1)
Last updated on FEBRUARY 26, 2019
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 and get some errors.
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.
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.
It is expected that 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.
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