Reports Error: AR to GL Reconciliation Report (ARGLRECR) Fails With ORA-1652: unable to extend temp segment...
Last updated on FEBRUARY 06, 2018
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
When attempting to run ARGLRECR module: AR to GL Reconciliation Report, it is taking a lot of time, and failing with the following 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
Tkprof shows the following as the top sql statement:
insert into ar_gl_recon_gt(code_combination_id,
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 )
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