EGL9.2: Build Summary Ledger Process(GL_SUML) Doesn't Update Balances Correctly If Multiple Summary Ledgers Are Built In Same Request
(Doc ID 2390407.1)
Last updated on APRIL 02, 2019
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
If multiple summary ledgers are built in same request in a run control then summary ledger build process couldn't update balances in all summary ledgers
Steps to Replicate:
1. Create a new ledger group
Go to General Ledger>Ledgers>Detail Ledgers and Add a new value
Go to General Ledger>Ledgers>Ledger Groups and add a new value and attach the newly created detail ledger
2. Attach the new ledger group to business unit.
Go to Setup Financials/Supply Chain > Business Unit Related>General Ledger>ledgers for a unit and choose Business Unit
Add the new Ledger Group created in step 1 and check the Balanced ledger and Separate DR/CR Amount fields
On Journal Post Options tab, choose Enable Incremental Ledger data
3. Create a new Summary Ledger S_ACCTS1 with ledger template S_ACCTS
4. Go to General Ledger>Summary ledgers >Ledger Set for Summary Ledger and For Ledger set S_ACCTS1 , add Ledger S_ACCTS1 and tie with the Business Unit +detail Ledger
5. Check the amounts for summary ledger for the accounts '100000','318000'
6. Create a journal for BU+ new Ledger group with lines that have accounts in previous step and post it
7. Check if the amounts in summary ledger have been updated
8. Create a new journal following the steps from 7 for the same accounts but with a different amount and edit the journal online
9. Create a new journal following the steps from 7 for the Business Unit + detail Ledger from any other attached ledger group for the same accounts but with any amount and and edit the journal online
10. Run Mark journals for posting and post the 2 newly validated journals
11. Navigate General Ledger>Summary Ledgers>Build Summary ledger & run build summary ledger
12. Check the accounts in summary ledger to see if they are updated
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