My Oracle Support Banner

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.

Symptoms

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.


Error Page  

Exception Details.  
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
at
oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAExcep
tion.java:996)
at
oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at
oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)

etc.....



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.

STEPS
-----------------------
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.


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
References


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