EGL9.2: ADB Process (GL_ADB_CALCX) Calculates Incorrect Amounts And Period in Records PS_LEDGER_ADB,PS_LEDGER_ADB_YTD After Running Year End Closing Process GL_YC (Doc ID 2877991.1)

Last updated on MARCH 01, 2024

Applies to:

Symptoms

After closing the fiscal year using the application engine GL_YC and running the application  engine GL_ADB_CALCX, the system is updating the records PS_LEDGER_ADB and PS_LEDGER_ADB_YTD with closing entries and booking these to period 365 incorrectly - they should be

booked on period 999 . Also, this is causing the Ending Balance (field POSTED_TOTAL_EBAL) to be updated to zero in the table PS_LEDGER_ADB_YTD,which is not correct.

When the  Cobol process GLPCLOSE was used to close the fiscal year, the issue was not happening .It happens only with  GL_YC.

Steps to reproduce the issue:

1.Go to Ledger for a Unit for BU=US001 and for the ledger group RECORDING, check the checkboxes : Report Average Balances and Maintain Balances by Date code. (Navigation:Setup Financial>Business Unit related>General Ledger>Ledgers for a Unit)

2.Enter 2 journal ids with journal dated of 30 Dec 2021 and 31 Dec 2021 , with the accounts 500000 and 500300 and department 10000 and amounts 1000 and 2000 USD.(Navigation: General Ledger> Journals> Enter/Update Journals )

3.Run ADB Process with as of date 31 Dec 2021. Record PS_LEDGER_ADB_YTD  will be updated with the data of the 2 journals : for the 2 accounts  the ending balance will be 3000 (Navigation: General Ledger> Average Daily Balance>ADB Process)

4.Run Year end closing choosing GL_YC application engine with closing date of 31 Dec 2021.The 2 closing journals have been created  and accounting entries for the accounts 500000 and 500300 have been created for periods 999  for the amount 3000 USD. (Navigation: General Ledger> Close Ledgers> Request Ledger Close )

5.The record PS_LEDGER_ADB has also been updated, but the closing entries have been booked to period 365, which is wrong. Closing entries should be booked to period 999.

6.Run again the ADB Process ( application engine GL_ADB_CALCX) with As of Date 12/31/2021

7.The record PS_LEDGER_ADB_YTD has also been updated and also here you can see that the closing entries have been booked to period 365, which is wrong.Closing entries should be booked to period 999. The Ending Balance (field POSTED_TOTAL_EBAL) has been updated to zero, but it should have the amount of 3000.

More information can be found in the attached document.

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.