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

Symptoms

Actual Behaviour

============

 

Cannot rebuild trial balance data but get errors like:

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.

 

 

EXPECTED BEHAVIOR
-----------------------
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.

BUSINESS IMPACT
-----------------------
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.

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