Reports Error: AR to GL Reconciliation Report (ARGLRECR) Fails With ORA-1652: unable to extend temp segment... (Doc ID 1361572.1)

Last updated on APRIL 04, 2017

Applies to:

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

Symptoms

When attempting to run ARGLRECR module: AR to GL Reconciliation Report, it is taking a lot of time, and failing with the following error:

ERROR
-----------------------
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
ORA-06512: at "APPS.ARP_RECON_REP", line 2788
ORA-06512: at line 1
java.util.logging.ErrorManager: 1:

Tkprof shows the following as the top sql statement:

insert into ar_gl_recon_gt(code_combination_id,
receivables_dr,receivables_cr,
account_type, account_type_code,account,company)
(select dat.code_combination_id,
sum(nvl(acctd_amount_dr,0)) receivables_debit,
sum(nvl(acctd_amount_cr,0)) receivables_credit,
...
...
group by dat.code_combination_id,lookup.description, gc.code_combination_id,gc.account_type,
gc.SEGMENT1||'-'||gc.SEGMENT2||'-'||gc.SEGMENT3||'-'||gc.SEGMENT4||'-'||gc.SEGMENT5||'-'||gc.SEGMENT6||'-'||gc.SEGMENT7 , gc.SEGMENT1 )



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