Managing Ledger Preparation Processing

This section provides an overview of the Ledger Preparation Manager and discusses how to use the Ledger Preparation Manager to manage the ledger preparation phase of consolidations.

Pages Used to Manage Ledger Preparation Processes

Page Name	Definition Name	Navigation	Usage
Ledger Preparation Manager	GC_PREP_MGR	select Global Consolidations, then select Prepare Data for Consolidation, then select Ledger Preparation Manager	Monitor and review the status of the processes used to prepare ledger data for consolidations.
Ledger Preparation Manager Search	GC_PREP_SRCH	Click the Change View Parameters link on the Ledger Preparation Manager page.	Specify which data to view in the Ledger Preparation Manager.

Understanding the Ledger Preparation Manager

The Ledger Preparation Manager page conveys the status of each phase of ledger preparation processing for the selected consolidation node, including:

Loading data into the warehouse.
Verification of the source data.
Calendar mapping.
Account mapping.
Currency translation.
Creating the consolidation ledger.

Note: For business units where the no preparation option is used, the status for calendar mapping, account mapping, and currency translation will be None because these processes are not run.

See Using the No Preparation Option.

The Ledger Preparation Manager has two views:

The Preparation View includes ledger preparation steps up and including loading the consolidation ledger.
The Enrichment View displays the activities on the consolidation ledger after the ledger preparation phase, but before the consolidation phase. This view is generally used to track harmonization, translation adjustments, and source flow activity.

When managing the ledger preparation phase, use the Preparation View.

Ledger Preparation Manager Page

Use the Ledger Preparation Manager page (GC_PREP_MGR) to monitor and review the status of the processes used to prepare ledger data for consolidations.

Navigation

select Global Consolidations, then select Prepare Data for Consolidation, then select Ledger Preparation Manager

Image: Ledger Preparation Manager

This example illustrates the fields and controls on the Ledger Preparation Manager. You can find definitions for the fields and controls later on this page.

On the Ledger Preparation Manager page, you can review which stages of ledger preparation are complete for the selected consolidation tree node.

See Understanding Global Consolidations Monitoring Tools

The status of each phase of ledger preparation processing appears for each ledger business unit and source ledger within the selected tree node. You can sort the results by clicking on a column heading. You can click on a status to access the Status Details page.

The phases are:

Data Received

Indicates the status of the source ledger loading process. Click on a status to display the Status Details - Data Received page.

Source Verification

Indicates the status of the source ledger verification process. Click on a status to display the Status Details - Source Verification.

The status for the ledger verification and the subsequent ledger preparation processes is updated based on the error handling choice you make on the Ledger Preparation Run Group page.

For example, if you select Prevent all BU(s) to continue and errors occur during the ledger verification phase for some of the business units, the ledger verification process continues to update the valid business units with the status text message 06-Review. For the subsequent ledger preparation processes, the ledger preparation process checks if the business units were previously run. If so, the status text messages is set to 03-Rerun, otherwise, the status is set to 00-None. Similarly, the ledger preparation process updates the consolidated business unit status for the subsequent consolidation processes.

If you select Allow valid BU(s) to continue and errors occur during the ledger verification phase for some of the business units, the ledger verification process updates the status for the subsequent ledger preparation processes to 00-None, or 03-Rerun for the problem business units. The ledger preparation process continues to prepare the valid business units and set the status per the results from each preparation step.

See Ledger Preparation Group Page.

Calendar Mapping

Indicates the status of the calendar mapping rules process. Click on a status to display the Status Details - Calendar Mapping page. When the no preparation option is used for a business unit, the status will be None because this process is not run.

Account Mapping

Indicates the status of the Data Mapper rules process. Click on a status to display the Status Details - Account Mapping page. When the no preparation option is used for a business unit, the status will be None because this process is not run.

Currency Translation

Indicates the status of the currency mapping rules process. Click on a status to display the Status Details - Currency Translation page. When the no preparation option is used for a business unit, the status will be None because this process is not run.

Ledger Loaded

Indicates the status of the mapped data for the consolidation ledger. Click on a status to display the Status Details - Ledger Loaded page.

Click the text message for more information, or click a link to access the corresponding page.

You can also access the following links on this page:

Model ID

Click to review or modify the consolidation model for the selected consolidation business unit.

Consolidation Audit

Click to access the Consolidation Audit Trail page, where you can interactively view the audit trail of the consolidation model.

See Auditing Consolidation Data.

View Batch Messages

Click to access the Engine Messages component, where you can review messages for a specific process instance.

Update Manual Process

Click to access the Update Manual Process page, where you can update the process status for manual processes previously defined on the Consolidations Processes page—for example, when you want to update the status for harmonization entries.

See Update Manual Status Page.

Consolidation Manager

Click to access the Consolidation Manager page, where you can view the status of each phase of consolidation processing.

See Understanding the Consolidation Manager.

Run Ledger Preparation

Click to access the Ledger Preparation run control page, where you can run process ledger preparation.

See Understanding the Ledger Preparation Manager.

Change View Parameters

Click to access the search page, where you can specify which data to view in the Ledger Preparation Manager or Consolidation Manager pages.

Global Consolidation Center

Click to access the Global Consolidation Center page.