Running Incremental Processes

Summary ledger can be update incrementally in the following ways:

• Using the Increment options from the process run control.

• During posting to the detail edger, thus keeping summary ledger synchronized with its detail ledger.

The objects and fields needed to support this feature are the following:

• The Summary Ledger Stage Tbl (table).

  This table is defined on the Ledger Template page. It is a copy of posted detail ledger transactions.

• The Status table (accessed from the Summary Ledger Status page).

  This table contains a row for each business unit, summary ledger, fiscal year and accounting period (summary). The Status table also includes a date and time stamp with the date and time when the system writes the row into the status table. The status table is common for all processes that use incremental ledger and not all fields are populated for all processes.

• The Ledger Tmp (a summary ledger temporary table).

  This table is defined on the Ledger Template page. It is a copy of the summary ledger table and is used when you specify incremental updating.

• The Enable Incremental Ledger Data option on the Ledgers for a Unit Journal Post Options page.

  This option indicates whether rows for business unit/detail ledger are staged.

  If this option is not selected, the staging process is bypassed. When staging is bypassed, no summary ledger for this business unit/detail ledger can be incrementally updated.

• The Skip Summary Ledger Update option.

  This option is located on both the Journal Post Request page and the User Preferences General Ledger page. It specifies whether to update summary ledgers during a specific run of a posting process.

• The Post to Summary Ledger option on the Ledger Set page.

  This option enables a specific business unit/summary ledger to be incremented from posting.

The incremental summary ledger update process flow is:

1. Summary Ledger process (initial summary ledger creation ):

   • On the Summary Ledger process request page, if the Request Type is Create, the process creates initial summary ledger data for the given business unit/summary ledger/accounting periods.

     Existing summary ledger data is deleted for the combination of business unit, fiscal year, and accounting period.

   • The process inserts a row into the Status table for each business unit/summary ledger/accounting period processed.

2. The Journal Post process:

   • If the Enable Incremental Summary Ledger option is selected on the Ledger for a Unit – Posting Options page, the process inserts rows into the Staging table with data posted to the detail ledger.

   • The process updates the summary ledger incrementally from the staging table (see step 3 for details) if one of these two setup options exist:

     • If the Post to Summary Ledger option on the Ledger Set page is selected and the Skip Summary Ledger Update check box is not selected on the Post Journals Request Page.

     • If the Skip Summary Ledger Update check box is not selected on the User Preferences – General Ledger page,

3. Summary Ledger Process (incremental update ):

   • For a given business unit and detail ledger, the process determines the summary ledgers and accounting periods to process based on the ledger set, the Post to Summary Ledger option, and the Status table.

     Only combinations with status entries and with the Post to Summary Ledger option selected are processed.

   • If the ledger has not yet been created, the process performs the creation directly from the ledger tables. Otherwise, it updates the ledger incrementally from the staging table.

   • For each business unit/summary ledger/accounting period processed, the process inserts a row in the Status table.

   • The process cleans up the Staging table by deleting rows with dttm_stamp earlier than the minute stamp of related status rows.