Reports Error: AR to GL Reconciliation Report (ARGLRECR) Fails With ORA-1652: unable to extend temp segment...
(Doc ID 1361572.1)
Last updated on FEBRUARY 11, 2019
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:
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 )
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!