BAD PERFORMANCE XLAABACR (Validate Application Accounting Definitions) (Doc ID 1410004.1)

Last updated on SEPTEMBER 30, 2015

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

A degradation in performance for the concurrent program XLAABACR (Validate Application Accounting Definitions). This process calls the function XLA_EXTRACT_INTEGRITY_PKG.VALIDATE_SOURCES_WITH_EXTRACT.

Within this there are 4 cursors that have the performance regression:
c_always_pop cursor
c_ref_always_pop cursor
c_same_datatype cursor
c_ref_same_datatype cursor

The program could also error out with 

ERROR
-----------------------
95617 The validation process has encountered an internal error.
Please enable the FND: Log Enabled profile option,revalidate
the application accounting definition, and review the log
for more information.

The FND Debug for the program shows the following error for xla_extract_integrity_pkg.validate_sources_with_extract:

XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program xla_extract_integrity_pkg.validate_sources_with_extract. ORA-1652: unable to extend temp segment by 16 in tablespace TEMP

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