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:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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
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]
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document