Querying Allocations

Allocation Manager enables you to output allocation results to target batches or journals, or merge data directly to a ledger target table. Additionally, Allocation Manager sometimes uses PeopleSoft Global Consolidations or Activity Based Management outputs as sources. Given these complex processes, it can be difficult to determine if the allocation output was calculated correctly based solely on viewing the results. As such, PeopleSoft EPM provides the new 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.

The Allocation Manager Inquiry tool can also integrate with Global Consolidation and Activity Based Management allocation rules.

See Allocation Manager Inquiry Results - Drill to Source Page, Auditing Consolidation Data, and Using Object Navigator and Model Analyzer.

Allocation Manager Audit Tables

The Allocation Manager Inquiry tool pulls data from the following EPM audit tables:

Audit Target table (PF_AL_AUD_TGT)
Audit Target Map table (PF_AL_AUD_TGMAP)
Audit Basis table (PF_AL_AUD_BAS)
Audit Basis Map table (PF_AL_AUD_BSMAP)
Audit Source table (PF_AL_AUD_SRC)
Audit Source Map table (PF_AL_AUD_SRMAP)
Audit Common Dimension table (PF_AL_AUD_CDIM)
Audit Map table (PF_AL_AUD_MAP)
Audit Run log table (PF_AL_AUD_RUNLG)

Pages Used to Query Target Allocations

Page Name	Definition Name	Navigation	Usage
Allocation Manager Inquiry - Audit Parameters	PF_AL_INQUIRY1	select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Allocation Manager Inquiry	Specify audit criteria for a specific allocation rule.
Allocation Manager Inquiry Results	PF_AL_INQUIRY2	Click Go on the Allocation Manager Inquiry - Audit Parameters page	View allocation rule data that matched your criteria. This data is the starting point for the audit trail.
Allocation Manager Inquiry Results - Drill to Basis	PF_AL_INQUIRY3	Click the Drill to Basis link on the Drill Details tab of the Allocation Manager Inquiry Results page	View basis rule details for an allocation.
Allocation Manager Inquiry Results - Drill to Source	PF_AL_INQUIRY4	Click the Drill to Source link on the Drill Details tab of the Allocation Manager Inquiry Results page	View source rule details for an allocation.

Allocation Manager Inquiry - Audit Parameters Page

Use the Allocation Manager Inquiry - Audit Parameters page (PF_AL_INQUIRY1) to specify audit criteria for a specific allocation rule.

Navigation

select EPM Foundation, then select Data Enrichment Tools, then select Allocation Manager, then select Allocation Manager Inquiry

Image: Allocation Manager Inquiry - Audit Parameters page

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

Use the Allocation Manager Inquiry - Audit Parameters page to specify audit criteria for a specific allocation rule.

Select the business unit, scenario ID, and jobstream ID associated with allocation you want to audit. You must also enter the fiscal year and period for the allocation. You may select a batch ID associated with the allocation to audit, but this field is optional since you may want to inquire on multiple batches at one time or the target merged directly to the datamap and did not create a batch.

Suppress Blank Dimensions

Select this check box to prevent dimension columns without values from displaying in the results grid.

Max Rows to Scroll

Enter the maximum number of rows you want displayed in the results grid.

Click to process the query parameters you provided and view the results grid.

Save Preference

Click to access the Save Inquiry Preference page and save the query parameters you input for future use.

You can input a name and description for your preference. With the Default Preference check box you can set your parameters as the default values for the page, meaning the parameters automatically populate the parameters page when a user accesses it.

Get Preference

Click to access the Select Inquiry Preference page where you can select a preference that will automatically populate the parameters page with its values.

With the Default Preference check box you can set the preference as the default for the page, meaning the parameters automatically populate the parameters page when a user accesses it.

Allocation Manager Inquiry Results Page

Use the Allocation Manager Inquiry Results page (PF_AL_INQUIRY2) to view allocation rule data that matched your criteria. This data is the starting point for the audit trail.

Navigation

Click Go on the Allocation Manager Inquiry - Audit Parameters page

Image: Allocation Manager Inquiry Results page

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

This page displays the target details associated with the allocation you selected for audit. Some of the columns displayed on this page are Monetary Amount, Row Description, and Ledger Business Unit. Values for the row description field include Allocation, Offset, and Residual.

If you did not specify a specific batch on the Allocation Manager Inquiry - Audit Parameters page, this page also displays the PF Batch ID.

If you did not select the Suppress Blank Dimensions check box on the Allocation Manager Inquiry - Audit Parameters page, this page will display columns without values.

Click the Selection Page link to return to the Allocation Manager Inquiry - Audit Parameters page.

Note: The Audit Target (PF_AL_AUD_TGT) table is the source for all the column values on this page.

Drill Details Tab

Click the Drill Details tab to drill down to the basis or source information for an allocation.

Image: Drill Details tab

This example illustrates the fields and controls on the Drill Details tab. You can find definitions for the fields and controls later on this page.

Click the Drill to Basis link to access the Allocation Manager Inquiry Results - Drill to Basis page and view basis details associated with the allocation.

Click the Drill to Source link to access the Allocation Manager Inquiry Results - Drill to Source page and view source details associated with the allocation.

Click the Selection Page link to return to the Allocation Manager Inquiry - Audit Parameters page.

Note: Only rows labeled with Allocation for the Row Description column have the option to drill to the source and basis.

Rule Detail Tab

Click the Rule Detail tab to drill down to the rule information for an allocation.

Image: Rule Detail tab on the Allocation Manager Inquiry Results page

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

Click the allocation rule link in the Allocation Rule ID column to access the Method page and view allocation method details, such as allocation method type and period based allocations.

Click the Selection Page link to return to the Allocation Manager Inquiry - Audit Parameters page.

Allocation Manager Inquiry Results - Drill to Basis Page

Use the Allocation Manager Inquiry Results - Drill to Basis page (PF_AL_INQUIRY3) to view basis rule details for an allocation.

Navigation

Click the Drill to Basis link on the Drill Details tab of the Allocation Manager Inquiry Results page

Image: Allocation Manager Inquiry Results - Drill to Basis page

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

This page displays the basis details associated with the allocation you selected for audit. Some of the columns displayed on this page are Basis Factor, Basis Amount, and Basis Total. The basis total is the sum of the basis amounts taken from the Audit Basis (PF_AL_AUD_BAS) table. The basis factor is calculated as the ratio between the basis amount and basis total. If an adjustment was applied to the basis (and basis adjustment is not equal 1) an additional column called Adjustment Applied will appear in the grid and display the adjustment factor that was applied.

Click the Selection Page link to return to the Allocation Manager Inquiry - Audit Parameters page.

Click the Target Details link to return to the Allocation Manager Inquiry Results page.

Rule Detail Tab

Click the Rule Detail tab to view the basis rule summary for an allocation.

Image: Rule Detail tab on the Drill to Basis page

This example illustrates the fields and controls on the Rule Detail tab on the Drill to Basis page. You can find definitions for the fields and controls later on this page.

Click the allocation rule link displayed in the Allocation Rule ID column to access the Basis page and view basis rule details, such as adjustments, constraints. or if it is a fixed basis.

Allocation Manager Inquiry Results - Drill to Source Page

Use the Allocation Manager Inquiry Results - Drill to Source page (PF_AL_INQUIRY4) to view source rule details for an allocation.

Navigation

Click the Drill to Source link on the Drill Details tab of the Allocation Manager Inquiry Results page

Image: Allocation Manager Inquiry Results - Drill to Source page

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

This page displays the source details associated with the allocation you selected for audit. Some of the columns displayed on this page are Posted Total Amount and Posted Transaction Amount. If an adjustment was applied to the source (and source adjustment is not equal 1) an additional column called Adjustment Applied will appear in the grid and display the adjustment factor that was applied.

Click the Selection Page link to return to the Allocation Manager Inquiry - Audit Parameters page.

Click the Target Details link to return to the Allocation Manager Inquiry Results page.

Rule Detail Tab

Click the Rule Detail tab to view the source rule summary for an allocation.

Image: Rule Detail tab on the Drill to Source page

This example illustrates the fields and controls on the Rule Detail tab on the Drill to Source page. You can find definitions for the fields and controls later on this page.

Click the link displayed in the Allocation Rule ID column to access the Source page and view source rule details, such as adjustments, constraints, or if it is a fixed source.

Drill to Source Page for an Activity Based Management Allocation

The Allocation Manager Inquiry Results - Drill to Source page changes slightly in appearance and functionality when you are working with an ABM allocation.

Image: Allocation Manager Inquiry Results - Drill to Source page for an ABM allocation

This example illustrates the fields and controls on the Allocation Manager Inquiry Results - Drill to Source page for an ABM allocation. You can find definitions for the fields and controls later on this page.

This page displays the source details associated with the ABM allocation you selected for audit. Some of the ABM-specific columns displayed on this page are Object ID, Object Type and Budgeted Amount.

Clicking the link displayed in the Drill to ABM column transfers you to the Object Navigator Inquiry tool found in ABM. Using the ABM tool you can further drill down to the model with its resources, activities, and cost objects, as well as view their sources and targets.

See Using Object Navigator and Model Analyzer.