My Oracle Support Banner

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 SEPTEMBER 17, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------

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

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.