Auditing Consolidation Data

The Consolidation Audit enables you to review account balances within the consolidation ledger or journal entries, and track those amounts back to their source. Using the consolidation audit, you can:

• Navigate through the consolidation results back to the source data level.

  If you use PeopleSoft General Ledger, you can drill back to the general ledger and supporting sub-systems to get back to the actual transactions that produced the data.

  You can also drill back to source amounts that originate from allocations. When you click on an amount, you are transferred to the Allocation Manager Inquiry tool that enables you to review allocation audit data, from the target to source—specifically, you can review allocation targets, drill down to basis and source elements of an allocation, and view calculation rules.

• Identify all the rules used to transform the source data to the results.

• View the intermediate results at various stages of consolidations.

You can audit either a consolidation ledger or journal details.

• For the consolidation ledger, the levels through which you navigate begin with the consolidation ledger and end with the amount's source—down to the source ledger level, if applicable.

  If you use PeopleSoft General Ledger data, you can drill back to the general ledger, it's supporting sub-systems, and the actual transactions.

  See Drilling Down to PeopleSoft General Ledger.

• For the journal details, the levels begin with the journal entry and end with the journal's source, which could be the output log or a manual journal entry.

The actual levels that you view for an amount depend on where the amount originated from, and what processing phases it went through.

Navigating Through the Consolidation Audit

To navigate through the audit levels, click the amount that you want to audit. The previous level from which that amount originated appears. Continue to click the amount to view all the phases through which the data flowed. The system displays the navigation path that you've traveled through as you click through the levels. The path is interactive; click any path segment to return to that level. As you navigate, the information that appears at the bottom of the page changes, showing details of the current level. For example, if you have navigated to the source ledger, the bottom section displays source ledger data details. The page title also changes accordingly.

Image: Consolidation Audit example

In this example, there are labels that show the navigation path and level detail regions. Also, notice how the page title corresponds to the detail level:

In this example of a consolidation audit, the source is an allocation entry:

Image: Consolidation audit example with allocation entry as source

This example illustrates the fields and controls on the Consolidation audit example with allocation entry as source. You can find definitions for the fields and controls later on this page.

When you click on an amount, you are automatically transferred to the Allocation Manager Inquiry page, which enables you to review allocation audit data. Specifically, you can review allocation targets, drill down to basis and source elements of an allocation, and view calculation rules.

Image: Allocation Manager Inquiry page

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

More information about the Allocation Manager Inquiry page is available in the PeopleSoft Enterprise Performance Management Fundamentals 9.1 Documentaion.

See Querying Allocations.

If your source data comes from PeopleSoft General Ledger, when you follow the consolidation audit back to the source ledger, a GL Drilldown link displays on the Consolidation Audit page which you can select to access the Ledger Inquiry component in the PeopleSoft General Ledger application. The General Ledger ledger inquiry component uses a predefined inquiry ID, named *DEFAULT. From the ledger inquiry you can access ledger activity (journals), and from the journals, you can access sub-systems (for example Accounts Receivable, Accounts Payable, Asset Management, and so on) accounting entries, and from there to the actual transactions.

Image: Consolidation Audit - Source Ledger Data page showing Drill to GL link

This example illustrates the GL Drilldown link on the Consolidation Audit page

You cannot change the parameters on the General Ledger - Ledger Inquiry search page to blank values for any dimension. You can specify a non-blank values, or you can check the Value Required check box.

Image: Ledger Inquiry page in PeopleSoft General Ledger after selecting the Drill to GL link

This example illustrates the parameter values on the General Ledger - Ledger Inquiry search page

This drilldown is supported only for PeopleSoft General Ledger sources. The source may be loaded into the EPM staging area using ETL Maps or may be accessed using a remote view.

Use the Consolidation Audit - Selection page (GC_CONS_AUDIT1) to specify which consolidation data to audit.

Image: Consolidation Audit - Criteria page

This example illustrates the fields and controls on the Consolidation Audit - Criteria page. You can find definitions for the fields and controls later on this page.

Use the Consolidation Audit - Results page (GC_CONS_AUD_RESULT) to view the ledger balances or journals for the consolidation data that matched your criteria.

This data is the starting point for the audit trail.

Image: Consolidation Audit - Results page

This example illustrates the fields and controls on the Consolidation Audit - Results page. You can find definitions for the fields and controls later on this page.

Click an amount to view its audit trail. The Consolidation Audit - Details page appears.

Use the Consolidation Audit - Details (page title changes depending on the level) page (GC_CONS_AUDIT3) to view the details that comprise an amount.

Navigate through the levels for additional details.

Image: Consolidation Audit - Details page

This example illustrates the fields and controls on the Consolidation Audit - Details page. You can find definitions for the fields and controls later on this page.

Click an amount to view the previous level from which that amount originated.

This page includes these regions:

Use the Consolidation Audit - Select Dimensions page (GC_CONS_AUDIT_INFO) to enter criteria to limit the dimension values or journal information included in the audit trail, or view the established dimension settings.

Image: Consolidation Audit - Select Dimensions page

This example illustrates the fields and controls on the Consolidation Audit - Select Dimensions page. You can find definitions for the fields and controls later on this page.

To limit the audit to a specific dimension value or journal batch, complete the criteria on this page.