GLPURGE - GL Archive and Purge Bad Performance (Doc ID 822615.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 to 12.0.6 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.
***Checked for relevance on 12-Mar-2012***
EXECUTABLE:GLPURGE - GL Archive and Purge


Symptoms

GL Purge shows poor performance.

The Trace file shows the following statement causing the performance issue :

select 'Erroneous Balances Present' into :b0
from
DUAL where exists (select GB.period_name from GL_BALANCES GB where
(((((GB.set_of_books_id=:b1 and GB.currency_code=:b2) and GB.actual_flag=
:b3) and GB.translated_flag in ('Y','N')) and DECODE(:b3,'B',
GB.budget_version_id,(-1))=DECODE(:b3,'B',:b6,(-1))) and
:b7<((GB.period_year* 10000)+GB.period_num)))

 

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