Purge Temporary Journal Import Interface Tables Program (XLADRPGLT) Fails with ORA-01652: Unable to Extend Temp Segment (Doc ID 1475006.1)

Last updated on MAY 28, 2015

Applies to:

Oracle Cost Management - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Oracle General Ledger - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Oracle Subledger Accounting - Version 12.0.6 to 12.1.2 [Release 12.0 to 12.1]
Oracle Purchasing - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Oracle Payables - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
XLADRPGLT module: Purge Temporary Journal Import Interface Tables Created By Subledger Accounting

Symptoms

Attempting to run the Purge Temporary Journal Import Interface Tables Created By Subledger Accounting (XLADRPGLT) and receive the following error:

Temp space was increased but no matter what the size is, the program fails just the same.

ERROR
-----------------------
11-JUN-2012 15:58:52 - Starting To Purge The XLA_GLT tables
ORA-01652: 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