GLPURGE - GL Archive and Purge Bad Performance
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle General Ledger - Version 22.214.171.124 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
GL Purge shows poor performance.
The Trace file shows the following statement causing the performance issue :
select 'Erroneous Balances Present' into :b0
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',
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