EGL 9.2 : ADB Calculation Process (GL_ADB_CALCX) Not Populating Data In LEDGER_ADB_MTD Due To DATE_CODE Field Not Having Correct Value (Doc ID 1608287.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
****Checked for Currency on 05-AUG-2015****

Symptoms

ACTUAL BEHAVIOR
---------------
The ADB calculation process is not populating the ADB table LEDGER_ADB_MTD, even though the data is populated in LEDGER_ADB.

EXPECTED BEHAVIOR
-----------------------
GL_ADB_CALCX program should insert data in LEDGER_ADB_MTD / LEDGER_ADB_YTD / LEDGER_ADB_QTD as per the setup.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup a Ledger Group on Ledger for a unit page which has ADB turned on. Do not setup date code functionality.
2. Setup ADB Definition.
3. Create data which needs to be processed.
4. Edit and post it.
5. Run ADB Process Program i.e. GL_ADB_CALCX

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