My Oracle Support Banner

Unapplied Receipts Journal performance error: ORA-01652: unable to extend temp segment by 16 in tablespace TEMP1 (Doc ID 2354312.1)

Last updated on JANUARY 05, 2021

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Unapplied Receipts Journal report completes in error with below message in log:


Java.sql.SQLException: ORA-19202: Error occurred in XML processing
ORA-01652: unable to extend temp segment by 16 in tablespace TEMP1
ORA-06512: at "APPS.ARP_RECON_REP", line 2432
ORA-06512: at line 1

When user increases TEMP tablespace to 500 GB it returns error:

java.sql.SQLException: ORA-19202: Error occurred in XML processing
ORA-01555: snapshot too old: rollback segment number 189 with name
"_SYSSMU189_3311421142$" too small
ORA-06512: at "APPS.ARP_RECON_REP", line 2432
ORA-06512: at line 1

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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