EGL9.2 Average Daily Balance Calculation (GL_ADB_CALCX) Running Slow At Step (GL_ADB_CALCX.INSRTWTA.INSRTTAO) (SQL) (Doc ID 2806076.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Symptoms

GL_ADB_CALCX process has been running 3 - 4 times longer than in recent previous months.

Example trace shows that majority of time was spent on below step, where rows were inserted to a temp table, PS_LED_ADBTG_TAO

        (GL_ADB_CALCX.INSRTWTA.INSRTTAO) (SQL) - took up 78% of total run time

Steps:

1. Run ADB Calc process with below parameters with one row for Month-to-Date, another row for Quarter-to-Date, another row for Year-to-Date, as shown below -

GL BU      ADB         Request Type          Period Type       Request Date Option    As Of Date   Tree Date Option       Adhoc
[blank]    ADBMTD   Calc End of Period   Month To Date   As Of Date                  8/24/2021    Use Period End Date   [X]
[blank]    ADBQTD   Calc End of Period   Month To Date   As Of Date                  8/24/2021    Use Period End Date   [X]
[blank]    ADBYTD   Calc End of Period   Month To Date   As Of Date                  8/24/2021    Use Period End Date   [X]

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.