Performance Issue with AR to GL Reconciliation Report ( ARGLRECR) (Doc ID 2294194.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Symptoms

AR to GL Reconciliation Report program runs for long time and its very slow

Sometimes it consume all temp space, and fails with the following error:

Executing:
BEGIN ARP_RECON_REP.arglrecon_load_xml( P_REPORTING_LEVEL => '1000', P_REPORTING_ENTITY_ID => '2023', P_SOB_ID => '', P_COA_ID => '50308', P_OUT_OF_BALANCE_ONLY => 'N', P_CO_SEG_LOW => '', P_CO_SEG_HIGH => '', P_PERIOD_NAME => 'FEB-17', P_GL_ACCOUNT_LOW => '', P_GL_ACCOUNT_HIGH => '', P_SUMMARY_ACCOUNT => '', p_result => :1); end;
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1
ORA-06512: at "APPS.ARP_RECON_REP", line 5053
ORA-06512: at line

The following SQL statement is the one running slow:

Changes

Cause

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