Posting to the Summary Ledgers Table and the Summary Ledger Staging Table

You can update your summary ledgers at the same time that you post changes to the detail ledgers as part of the posting process by selecting the Skip Summary Ledger Update check box on the Post Journals Request page. The journal post calls the Summary Ledger Application Engine process (GL_SUML) at the end of processing for each business unit, passing the business unit, and the staging table name. The staging table is a copy of the ledger table. The Journal Post process populates this table.

The summary ledger compares the rows in the staging table with the rows in the status table to determine which ledgers to increment. It then compares those with the ledger set definition to determine whether the increment is allowed. Summary ledgers that have not yet been created when called from the Posting process are not created.

Note: To run an incremental summary ledger request, you must create a particular summary ledger and accounting period before it can be incremented through posting. Once you run the request, the rows in the staging table are compared with those in the status table, so that the system can determine which ledgers to increment.

See Combining Accounts Using Summary Ledgers.