R12 Journal Entries Report (XLAJELINESRPT) Has Performance Issue Or Fails With Error: "java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1" (Doc ID 1141673.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1 [Release 12.0 to 12.1]
Oracle Cost Management - Version 12.0.0 to 12.1.1 [Release 12 to 12.1]
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Subledger Accounting - Version 12.0.0 and later
Oracle General Ledger - Version 12.0.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
XLAJELINESRPT



Symptoms

On : 12.0.6 version, Standard Reports & Inquiries
XLAJELINESRPT module: Journal Entries Report is either taking a number of hours to complete or fails with the error "java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1"

EXPECTED BEHAVIOR
-----------------------
To complete successfully and in a "reasonable" time


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to publish report and utilize the information for administration.

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