Viewing Data Flows

This section provides an overview of the Flow Inquiry component and discusses how to:

Specify flow inquiry parameters.
View flow inquiry results.
View the flow inquiry details.
View the flow inquiry difference details.
View the flow inquiry audit.

Pages Used to View Data Flows

Page Name	Definition Name	Navigation	Usage
Flow Inquiry Selection	GC_FLINQ_SEL	select Global Consolidations, then select Consolidation Analysis, then select Consolidation Inquiries, then select Flow Inquiry	Enter parameters by which to view flow data.
Flow Inquiry	GC_FLOW_INQUIRY	Click Go on the Flow Inquiry Selection page.	View the results of a flow inquiry.
Flow Inquiry for Selected Amount	GC_FLINQ_AMT	Click an amount in the flow inquiry flow template grid.	View detailed information about a flow amount and its associated account.
Flow Audit	GC_FLINQ_AUD	Click an amount on the Flow Inquiry for Selected Amount page	View the base flow amount and the source flow amount for their respective currencies for a selected amount.
Get Preference	GC_FLINQ_PREF_SEL	Click Get Preference on the Flow Inquiry selection page.	Select a preference to use for the Flow Inquiry page. The field values defined for that preference load into the Flow Inquiry selection page.
Save Preference	GC_FLINQ_PREF_SAV	Click Save Preference on the Flow Inquiry selection page.	Save the current settings to a named preference.

Understanding the Flow Inquiry Component

After updating flow amounts, you can review the flow templates (both manual input and system activity) in the consolidation currency for the source and journal flows. The flow template inquiry enables you to look at the template from a single ledger business unit or by multiple ledger business units using a business unit filter tree.

Flow Inquiry Selection Page

Use the Flow Inquiry Selection page (GC_FLINQ_SEL) to enter parameters by which to view flow data.

Navigation

select Global Consolidations, then select Consolidation Analysis, then select Consolidation Inquiries, then select Flow Inquiry

Image: Flow Inquiry Selection page

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

Preference

Displays the selected preference. If you want to use previously saved selection criteria, select Get Preference and select the preference. If you want to save the selection criteria that you enter on this page, select Save Preference.

See Analyzing Consolidations/Saving and Loading Inquiry Preferences

Business Unit, Scenario ID, Fiscal Year, From Period , and To Period

Specify the common consolidation business unit, scenario ID, fiscal year, and range of accounting periods on which to inquire.

Template

Select the flow template ID. Your choices are dependent on the flow templates you create for the flow group associated with the business unit, scenario, fiscal year, and accounting period.

Translation Type

Select the translation type. You have two options to select from to view the currency translated flows: Cash Flow Rate or Closing Rate.

If you select Closing Tate as the translation type, the 99980 FXAJ1 column appears on this page as the translation flow code. It represents the flow translation adjustment to adjust the opening balance, translated at prior rates to the closing balance at the closing translation rate. This amount derives from the GC_SOURCE 08, for currency translations adjustments.
If you select Cash Flow Rate as the translation type, both the 99980 FXAJ1 and 99985 FXAJ2 columns appear on this page as the translation flow code. It represents the flow translation adjustment to adjust the flow amounts translated at the average rate to the closing rate.

See Understanding Data Flows.

Book Code Group

Select the book code group by which you want to further filter the inquiry report data. This is an optional field and is only available if you turn on book code functionality on the General Options page and you create book code values with the Book Codes and Book Code Group pages.

Filter Tree

Select the business unit tree used to roll up and navigate through the flow data. The flow inquiry allows you to look at the template from a single ledger business unit or by multiple ledger business units by using the filter tree.

See Using Reporting Trees with Inquiries.

Saving and Loading Preferences

You can save a set of defined values to a named preference, which you can use to generate the flow amounts. Click the Save Preference button after defining the field values, and enter a preference ID and description. To load a previously saved preference, click the Get Preference button, and select the preference. If a preference is currently active, its name appears in the Preference field.

Viewing Results

Click Go to view the Flow Inquiry - Results page.

Flow Inquiry Page

Use the Flow Inquiry page (GC_FLOW_INQUIRY) to view the results of a flow inquiry.

Navigation

Click Go on the Flow Inquiry Selection page.

Image: Flow Inquiry page

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

The flow amounts appear in the grid.

Select a tree node to view the data associated with that node. When you reach an end node, you view details for the filter tree objects within that node.

Drilling on Flow Amounts

When viewing the Flow Inquiry page, click an amount to view more details on the Flow Inquiry for Selected Amount page. The flow amounts and difference amounts that are highlighted as links enable you to click the linked amount in the grid and get more detailed information about the flow amounts for the related accounts.

Note: System flows such as the Open, Close, and Change columns do not have active links for viewing details.

Links on the Flow Inquiry Page

The following links are available on the Flow Inquiry page:

Source Flow Input

Click to view the Source Flow Input page where you can enter and validate flow information for source flow data.

Note: This link is not available for system flow templates.

Journal Flow Input

Click to view the journal flow input page where you can enter and validate flow information for journals.

Note: This link is not available for system flow templates.

Source Flow Update

Click to view the source flow update page where you can submit a request to update the source flow activity amounts.

Journal Flow Update

Click to view the journal flow update page where you can submit a request to update the journal flow activity amounts.

Return to Selection Page

Click to return to the Flow Inquiry Selection page.

Flow Inquiry for Selected Amount Page

Use the Flow Inquiry for Selected Amount page (GC_FLINQ_AMT) to view detailed information about a flow amount and its associated account.

Navigation

Click an amount in the flow inquiry flow template grid.

Image: Flow Inquiry for Selected Amount page

This example illustrates the fields and controls on the Flow Inquiry for Selected Amount page. You can find definitions for the fields and controls later on this page.

The Flow Inquiry for Selected Amount page provides details about the flow amounts, the account, and flow code by ledger business unit. The flow amounts are segregated by source flow amount and journal flow amount. This distinguishes where the flow amount originated. Selecting any amount in the Source Flow Amount column or Journal Flow Amount column directs you to the flow audit page.

Flow Inquiry for Selected Amount - Difference Details Page

Use the Flow Inquiry for Selected Amount - Difference Details page to view a difference amount in Flow Inquiry.

Navigation

Click an amount in the flow inquiry flow template grid.

Click a difference amount on the Flow Inquiry for Selected Amount page

Image: Flow Inquiry for Selected Amount - Difference Details page

This example illustrates the fields and controls on the Flow Inquiry for Selected Amount - Difference Details page. You can find definitions for the fields and controls later on this page.

On the Flow Inquiry page, drill on the Difference to be Reconciled amount to access the Flow Inquiry for Selected Amount - Difference Details page. Because flow amounts originate from two different sources, the difference amounts are divided into the Source Difference and the Journal Difference columns.

If there are amounts in either column, you can drill down to the relevant input page and correct the difference:

If there is an amount in the Source Difference column, you can select the Source Flow Input link to drill down to the Source Flow Input page.
If there is an amount in the Journal Difference column, you can select the Journal Flow Input link to drill down to the Journal Flow Input page.

Note: After correcting the flow amount in the respective flow input page, use the Validate button on the flow input page to validate the flow template. After the flow amounts are corrected, rerun the update engine to eliminate the difference to be reconciled amount.

Flow Audit Page

Use the Flow Audit page (GC_FLINQ_AUD) to view the base flow amount and the source flow amount for their respective currencies for a selected amount.

Navigation

Click an amount on the Flow Inquiry for Selected Amount page

Because the flow inquiry amounts are in the consolidation currency and the source input templates are in the source currency, the Flow Audit page enables you to view the base flow amount and the source flow amount in their respective currencies. You can access the Currency Rule setup page by clicking on the currency rule link. You can also drill to the flow input pages when drilling on a flow amount that originated from source flows or journal flows.

You can use the navigation path to navigate back to the Flow Inquiry and Flow Inquiry for Selected Amount pages.

Note: If there are multiple currencies on the input template, then there are multiple rows of data detailing the multiple base amounts with the multiple source amounts and source currency. When drilling on a system flow, the source and journal flow input link will not display as the flow is system generated.