Generating Consolidation Reports

Pages Used to Generate Global Consolidations Reports

Page Name	Definition Name	Navigation	Usage
Journal Detail	GC_RUN_GC7000	select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Journal Detail	Run the Journal Detail report (GC7000) Lists journal entry detail information by ledger business unit, including journal ID, date, debit and credit amounts. Optionally displays amounts in both foreign and base currency. The Dimension selection grid provides additional options to enter dimensions for filtering and grouping the report. (SQR)
Ledger Activity	GC_RUN_GC7002	select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Ledger Activity	Lists the beginning and ending ledger balances by dimension combination and account. Optionally lists the detailed journal line activity posted against the ledger for the accounting periods that are specified. The Dimension selection grid provides additional options to enter dimensions for filtering and grouping the report. (SQR)
Out of Balance Report	GC_RUN_GC7005	select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Out of Balance Report	Run the Out of Balance report (GC7005). Lists the elimination entities and ledger amounts processed for an elimination request. The elimination entities are totaled and any out of balance amount is displayed. Summarizes the out of balance amounts at the node and tree levels. (SQR)
Non-Controlling Interest	GC_RUN_GC7007	select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select NonControlling Interest	Run the Non-Controlling Interest report (GC7007). Lists results of the non-controlling interest calculations generated during consolidation based on the combination of business units present in the consolidation tree, by entry type and rule set, with subtotals grouped by tree node and ownership rule set. (SQR)
Equitization Calculation	GC_RUN_GC7009	select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Equitization Calculation	Run the Equitization Calculation report (GC7009). Lists details of the equitization accounting entries generated during equitization processing by entry type and rule set, with subtotals grouped by tree node and ownership set. (SQR)
Match Report	RUN_GC_MATCH	select Global Consolidations, then select Consolidation Analysis, then select Perform Matching, then select Matching Process and Report	Run the Match report (GCS2001). Lists the matching of account eliminations by ledger unit and affiliate for each elimination rule. (SQR)
Close Process Report	GC_RUN_CLS_RPT	select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Close Process Report	Run the Close Process report (GCS2002). Lists the closing and rollforward entries resulting from the close process. (SQR)
Match Results Inquiry	GC_MTCH_INQ_PAGE	select Global Consolidations, then select Consolidation Analysis, then select Perform Matching, then select Match Results Inquiry	Run the Match Results Inquiry report.
Matching Tag Reason Code	GC_MATCH_CD_PG	select Global Consolidations, then select Consolidation Analysis, then select Perform Matching, then select Matching Tag Reason Code	Run the Matching Tag Reason Code report.
Matching Tag Entry	GC_MATCH_TAG_PG	select Global Consolidations, then select Consolidation Analysis, then select Perform Matching, then select Matching Tag Entry	Run the Matching Tag Entry report.
nVision Report Request	NVS_REPORT_RQST	select Reporting Tools, then select PS/nVision, then select Define Report Request	Create or modify PS/nVision reports.

Understanding Global Consolidations Reports

You can view or generate Global Consolidations reports on your data by using a variety of tools:

PeopleSoft Query

Create ad hoc queries, or use or modify delivered queries.

PS/nVision

Create reports in Microsoft Excel.

Global Consolidations Inquiries

Select and view data online.

Global Consolidations Reports

Generate formatted SQR reports that you can print.

Insights reporting from Data Marts

Web-based interactive reports that enable you to slice and dice your warehouse data organized into data marts.

Note: For samples of the Structured Query Reports (SQRs), see the PDF files published on CD-ROM with your documentation.

See the product documentation for PeopleTools: PeopleSoft Query, PeopleTools: PS/nVision,PeopleTools: PeopleSoft Applications User's Guide and On My Oracle Support, see the red paper entitled "Global Consolidations Implementation Guide”

Understanding Delivered PS/nVision Reports

The sample PSn/Vision reports are:

GCV1000

Lists ChartField balances from the Trial Balance consolidation ledger format.

GCV1005

Lists ChartField balances from the Financial Statement consolidation ledger format.

GCV1010

Lists ChartField balances for each ledger business unit from the Trial Balance consolidation ledger format.

GCV1015

Lists ChartField balances for each ledger business unit from the Financial Statement consolidation ledger format.

GCV1020

Lists the year to date amounts for all accounts from the Trial Balance consolidation ledger format.

GCV1100

Generates an income statement from the Trial Balance consolidation ledger format.

GCV1105

Generates an income statement from the Financial Statement consolidation ledger format.

GCV1110

Generates an income statement by nature of expense from the Trial Balance consolidation ledger format.

GCV1115

Generates an income statement by nature of expense from the Financial Statement consolidation ledger format.

GCV1120

Generates an income statement as a percentage of revenue from the Trial Balance consolidation ledger format.

GCV1125

Generates an income statement as a percentage of revenue from the Financial Statement consolidation ledger format.

GCV1130

Generates a budget vs actuals report where the actual amount is from the Trial Balance consolidation ledger format.

GCV1135

Generates a budget vs actuals report where the actual amount is from the Financial Statement consolidation ledger format.

GCV1140

Generates a forecast report where the actual amount is from the Trial Balance consolidation ledger format.

GCV1145

Generates a forecast report where the actual amount is from the Financial Statement consolidation ledger format.

GCV1150

Generates a segment report by product from the Trial Balance consolidation ledger format.

GCV1155

Generates a segment report by product from the Financial Statement consolidation ledger format.

GCV1160

Generates a segment report by region from the Trial Balance consolidation ledger format.

GCV1165

Generates a segment report by region from the Financial Statement consolidation ledger format.

GCV1200

Generates a cash flow report from the Trial Balance consolidation ledger format.

GCV1210

Generates a change in equity report from the Trial Balance consolidation ledger format.

GCV1220

Generates a change in goodwill report from the Trial Balance consolidation ledger format.

GCV1230

Generates a change in fixed assets report from the Trial Balance consolidation ledger format.

Note: These are sample reports; you need to modify them to work with your data. PS/nVision reports created for use with PeopleSoft Global Consolidations must be query-based.

Running Global Consolidations Reports

This section discusses how to:

Run the Journal Detail report.
Run the Ledger Activity report.
Run the Out-of-Balance report.
Run the Non-Controlling Interest report.
Run the Equitization Calculation report.
Run the Close Balance report.

Running the Ledger Activity Report

Use the Ledger Activity page (GC_RUN_GC7002) to lists the beginning and ending ledger balances by dimension combination and account.

Optionally lists the detailed journal line activity posted against the ledger for the accounting periods that are specified. The Dimension selection grid provides additional options to enter dimensions for filtering and grouping the report. (SQR)

Navigation

select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Ledger Activity

Image: Ledger Activity report run control page

This example illustrates the fields and controls on the Ledger Activity report run control page. You can find definitions for the fields and controls later on this page.

Select a language for the report, and then enter values in the Report Request Parameters group box for these fields:

Business Unit, Scenario ID, Fiscal Year, and Currency

Enter the common consolidation business unit, consolidation scenario, fiscal year, and currency for the report.

From Period and To Period

Enter the range of periods to include in the report for the specified fiscal year.

Show Discrepancies Only

Select to show only those rows where the sum of the details doesn't equal the difference between the beginning and ending values. Applies to the Ledger Detail report only.

Show Journal Detail

Select to include journal line details. Applies to the Ledger Detail report only.

Display Full Numeric Field

Displays all digits.

Book Code Group

(Only required if book code functionality is enabled.) Enter the book code group by which to filter the report.

The Dimension Selection grid is used to specify which columns appear on the report, how they are grouped, and the order in which they appear. The dimensions are those specified on the consolidation ledger template. You can enter up to 30 dimensions.

Insert rows as needed in the Dimension Selection grid, and enter values in the following fields:

Sequence

Enter a numeric value to specify the order in which columns are displayed on the report.

Dimension

Select a dimension to appear in the report.

Select

Select this check box to indicate that the dimension should be included in the report.

Subtotal

Select this check box to indicate that amounts should be subtotaled for this dimension.

Option

Select one of the following options, and enter values in additional fields as required for that option:

All Values:Select to include all the values for the specified dimension in the report.
Detail: Select to specify one value for the dimension, and then enter the value in the Value column. You can also enter a wildcard value for this option.
Range: Select to specify a range of values for the dimension, and then enter the beginning of the range in the Select Value column, and the value for the end of the range in the To Value column. You can also enter a wildcard value for this option.
Tree: Select to specify values from a tree node for the dimension, and then enter values for the Tree and Tree Node columns.
Book Cd Grp: (Book code group). Only available when the selected dimension is Book Code.

Journal Detail Page

Use the Journal Detail page (GC_RUN_GC7000) to run the Journal Detail report (GC7000) Lists journal entry detail information by ledger business unit, including journal ID, date, debit and credit amounts.

Optionally displays amounts in both foreign and base currency. The Dimension selection grid provides additional options to enter dimensions for filtering and grouping the report. (SQR)

Navigation

select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Journal Detail

Image: Journal Detail report page

This example illustrates the fields and controls on the Journal Detail report page. You can find definitions for the fields and controls later on this page.

Select a language for the report, then enter values in the Report Request Parameters group box for these fields:

Business Unit, Scenario ID, Fiscal Year, and Currency

Enter the common consolidation business unit, consolidation scenario, fiscal year, and currency for the report.

From Period and To Period

Enter the range of periods to include in the report for the specified fiscal year.

Batch Source

Select the source of data to include in the report; applies to the Journal Detail report only. Values are:

All: Include data from all sources.

Engine: Include data generated from consolidation processes only.

Manual: Include manually entered data only.

Ledger Unit

Specify the ledger business unit for the journal detail report.

PF Batch ID

Indicate the processed batch ID to include.

Batch Status

Select the status of data to include in the report; applies to the Journal Detail report only. Values are:

All: Include all data regardless of the batch status.

Error: Include only data with an error status.

Posted: Include only posted data.

Valid: Include only valid, but not posted, data.

Show Statistics Amount

Includes statistical amounts in the report.

Display Full Numeric Field

Displays all digits.

Display Both Parent and Base

Displays amounts in both the parent and base currencies.

Book Code Group

(Only required if book code functionality is enabled.) Enter the book code group by which to filter the report.

The Dimension Selection grid is used to specify which columns appear on the report, how they are grouped, and the order in which they appear. The dimensions are those specified on the consolidation ledger template. You can enter up to 30 dimensions.

Insert rows as needed in the Dimension Selection grid, and enter values in the following fields:

Sequence

Enter a numeric value to specify the order in which columns are displayed on the report.

Dimension

Select a dimension to appear in the report.

Select

Select this check box to indicate that the dimension should be included in the report.

Option

Select one of the following options, and enter values in additional fields as required for that option:

All Values:Select to include all the values for the specified dimension in the report.
Detail: Select to specify one value for the dimension, and then enter the value in the Value column. You can also enter a wildcard value for this option.
Range: Select to specify a range of values for the dimension, and then enter the beginning of the range in the Select Value column, and the value for the end of the range in the To Value column. You can also enter a wildcard value for this option.
Tree: Select to specify values from a tree node for the dimension, and then enter values for the Tree and Tree Node columns.
Book Cd Grp: (Book code group). Only available when the selected dimension is Book Code.

Out of Balance Report Page

Use the Out of Balance Report page (GC_RUN_GC7005) to run the Out of Balance report (GC7005).

Lists the elimination entities and ledger amounts processed for an elimination request. The elimination entities are totaled and any out of balance amount is displayed. Summarizes the out of balance amounts at the node and tree levels. (SQR)

Navigation

select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Out of Balance Report

Image: Out of Balance Report page

This example illustrates the fields and controls on the Out of Balance Report page. You can find definitions for the fields and controls later on this page.

Select a language for the report, and then enter values in the Report Request Parameters group box for these fields:

Business Unit, Scenario ID, Fiscal Year, and Period

Enter the common consolidation business unit, consolidation scenario, fiscal year, and period for the report.

Display Full Numeric Field

Displays all digits.

The Dimension Selection grid is used to specify which columns appear on the report, how they are grouped, and the order in which they appear. The dimensions are those specified on the consolidation ledger template. Insert rows as needed in the Dimension Selection grid, and enter values in the following fields:

Sequence

Enter a numeric value to specify the order in which columns are displayed on the report.

Dimension

Select a dimension to appear in the report.

Select

Select this check box to indicate that the dimension should be included in the report.

Show Description

Select this check box to show descriptions for the selected dimension on the report.

Non-Controlling Interest Page

Use the Non-Controlling Interest page (GC_RUN_GC7007) to run the Non-Controlling Interest report (GC7007).

Lists results of the non-controlling interest calculations generated during consolidation based on the combination of business units present in the consolidation tree, by entry type and rule set, with subtotals grouped by tree node and ownership rule set. (SQR)

Navigation

select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select NonControlling Interest

Image: Non-Controlling Interest report run control page

This example illustrates the fields and controls on the Non-Controlling Interest report run control page. You can find definitions for the fields and controls later on this page.

Select a language for the report, then enter values in the Report Request Parameters group box for these fields:

Business Unit, Scenario ID, Fiscal Year, and Period

Enter the common consolidation business unit, consolidation scenario, fiscal year, and period for the report.

Display Full Numeric Field

Displays all digits.

The Dimension Selection grid is used to specify which columns appear on the report, how they are grouped, and the order in which they appear. The dimensions are those specified on the consolidation ledger template. Insert rows as needed in the Dimension Selection grid, and enter values in the following fields:

Sequence

Enter a numeric value to specify the order in which columns are displayed on the report.

Dimension

Select a dimension to appear in the report.

Select

Select this check box to indicate that the dimension should be included in the report.

Show Description

Select this check box to show descriptions for the selected dimension on the report.

Equitization Calculation Page

Use the Equitization Calculation page (GC_RUN_GC7009) to run the Equitization Calculation report (GC7009).

Lists details of the equitization accounting entries generated during equitization processing by entry type and rule set, with subtotals grouped by tree node and ownership set. (SQR)

Navigation

select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Equitization Calculation

Image: Equitization Calculation report run control page

This example illustrates the fields and controls on the Equitization Calculation report run control page. You can find definitions for the fields and controls later on this page.

Select a language for the report, then enter values in the Report Request Parameters group box for these fields:

Business Unit, Scenario ID, Fiscal Year, and Period

Enter the common consolidation business unit, consolidation scenario, fiscal year, and period for the report.

Display Full Numeric Field

Displays all digits.

The Dimension Selection grid is used to specify which columns appear on the report, how they are grouped, and the order in which they appear. The dimensions are those specified on the consolidation ledger template. Insert rows as needed in the Dimension Selection grid, and enter values in the following fields:

Sequence

Enter a numeric value to specify the order in which columns are displayed on the report.

Dimension

Select a dimension to appear in the report.

Select

Select this check box to indicate that the dimension should be included in the report.

Show Description

Select this check box to show descriptions for the selected dimension on the report.

Close Process Report Page

Use the Close Process Report page (GC_RUN_CLS_RPT) to run the Close Process report (GCS2002).

Lists the closing and rollforward entries resulting from the close process. (SQR)

Navigation

select Global Consolidations, then select Consolidation Analysis, then select Consolidation Reports, then select Close Process Report

Image: Close Process Report run control page

This example illustrates the fields and controls on the Close Process Report run control page. You can find definitions for the fields and controls later on this page.

Select a language for the report, then enter values in the Report Request Parameters group box for these fields:

Business Unit, Scenario ID, Fiscal Year, and Period

Enter the common consolidation business unit, consolidation scenario, fiscal year, and period for the report.

Override Scenario's Tree Node

Select if you do not want to run the report for the tree node specified in the consolidation scenario, and then enter a tree node from the consolidation tree in the Tree Node field.

The Dimension Selection grid is used to specify which columns appear on the report, how they are grouped, and the order in which they appear. The dimensions are those specified on the consolidation ledger template. Insert rows as needed in the Dimension Selection grid, and enter values in the following fields:

Sequence

Enter a numeric value to specify the order in which columns are displayed on the report.

Dimension

Select a dimension to appear in the report.

Select

Select this check box to indicate that the dimension should be included in the report.

Show Description

Select this check box to show descriptions for the selected dimension on the report.