EGL: ADB Calculation Abended at Step GL_ADB_CALCX.CALCAVG.iBegBal Wih Error 'SQL Object Not Defined (108,520)'. (Doc ID 1061016.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
****Checked for Currency on AUG-12-2011****
****Checked for Currency on Oct-29-2013****
****Checked for Currency on 13-Oct-2015****

Symptoms


ISSUE STATEMENT
----------------------
ADB calculation process abended at Step GL_ADB_CALCX.CALCAVG.iBegBal with below error.

ERROR
-----------------------
SQL object ADBXXXXXXXXX_INSRTWTA not defined (108,520)
Meta-SQL error at or near position 760 in statement (108,512)
Process 8207 ABENDED at Step GL_ADB_CALCX.CALCAVG.iBegBal (SQL) -- RC = ? (108,524)

IMPACT
---------------
Due to this issue, ADB calculation process cannot be completed.

STEPS
---------------
By following these steps the issue can be reproduced On-Site or DEMO:
1. Navigate to General Ledger > Average Daily Balance > ADB process.
2. Run ADB process.
3. Process abended with the error.

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