Using Balancing and Reconciliation Features

This topic provides overviews of PF Reconciliation, job total metadata, and balance rules metadata and discusses how to:

Review and define job totals metadata.
Review and define balance rules metadata.
Run PF Reconciliation.
Review reconciliation results.

Pages Used to Set Up Balancing and Reconciliation

Page Name	Definition Name	Navigation	Usage
Job Total Metadata	PF_META_TOT_TBL1	select EPM Foundation, then select Foundation Metadata, then select Metadata Creation and Editing, then select Job Total Metadata	Review and define job totals for various data that is used as input or output to the different source or target tables in the system.
Balance Rules Metadata	PF_META_BAL_TBL1	select EPM Foundation, then select Foundation Metadata, then select Metadata Creation and Editing, then select Balance Rules Metadata	Review and define balance rules.
PF Reconciliation	RUN_PF_JOB	select EPM Foundation, then select Data Enrichment Tools, then select Profit Manager, then select Performance Journals, then select Reconcile Balances, then select PF Reconciliation	Run the PF Reconciliation engine to compare to and from amounts between tables.
Job Totals	PF_RECON_TOT_DATA	select EPM Foundation, then select Data Enrichment Tools, then select Profit Manager, then select Performance Journals, then select Review Bal/Recon (Balance/Reconcile) Results, then select Job Totals	A display-only page that shows the results of a job totals reconciliation.
Balance Rule Data	PF_RECON_RULE_DATA	select EPM Foundation, then select Data Enrichment Tools, then select Profit Manager, then select Performance Journals, then select Review Bal/Recon (Balance/Reconcile) Results, then select Balance Rule Data	A display-only page that shows the results of a balance reconciliation.

Understanding PF Reconciliation

Several features are available for you to use to check data integrity and to verify that input equals output between tables.

Run the PF Reconciliation engine after populating the performance ledger table (PF_LEDGER_F00) to verify that the data that you processed through the system is accurately reflected. The job totals and balance rules metadata pages enable you to specify the fields in the tables that you want to track. You define and use job totals metadata to compare totals between sources such as the GL ledger table or the revenue table versus the target table and the performance ledger table, and find any differences for an accounting period of a business unit and scenario ID.

The PF Reconciliation engine first resolves the sources and destinations into temporary tables using the constraints that are given for the job totals. The engine verifies all the job totals and balancing rules that are defined under the reconciliation job that is being run and calculates the totals and the differences for the balancing rules.

Typically, you run the PF Reconciliation engine after a period to compare to and from amounts between tables, such as the REVENUE_F00 and the PF_LEDGER_F00 or the GL_LEDGER and the PF_LEDGER_F00. The system delivers job totals and balance rules metadata for these types of tables. However, if you want to compare any other source and target tables, you can create your own job totals and balance rule metadata. After running your reconciliation, use the inquiry pages to track your reconciliation job.

Understanding Job Total Metadata

Job total metadata has two purposes:

To define totals for the PF Record Summary.

For PF Record Summary, define job totals using the Record Name field.
To define totals for balancing rules.

For balancing rules, you define job totals using constraints. Constraints are used to define the scope of the data that is being totaled. The data could come from a single table, but the scope of the data to be considered could depend on data in other tables.

Note: You can toggle the record and constraint fields on the Job Totals page, depending on the job ID that you select. Predefined job total metadata is delivered with EPM .

Understanding Balance Rules Metadata

Balance rules enable you to verify the data throughout the system. For example, you can verify that a monetary amount that you entered into the system reached the performance ledger table (PF_LEDGER_F00). The three balancing rules include:

Informational

Use this balancing rule to review how many rows or how many monetary amounts are in the specified table, or to see information that is not critical but can be used to validate or identify a model. For example, for PeopleSoft Activity-Based Management, you can check that data reaches cost objects directly from resources instead of going through activities. Informational balance rule differences enable you to post to the ledger.

Control

Use this balancing rule to determine whether an out-of-balance amount exists. The batch is set to balance error status and can be analyzed in a report. Control balance rule differences will not allow you to post to the ledger.

Force Balancing

An out-of-balance amount will not stop the post process and can be added to the performance ledger table to force balance. Force balancing can be defined on a rule that compares totals between a source and a destination. You can define only one balance rule for a source and a destination. The SetID MODEL has a predefined force balance account (FBAL). If you need to define a force balance account, do so on the Ledger Event Codes page.

Predefined balance rules metadata is delivered with EPM.

Job Total Metadata Page

Use the Job Total Metadata page (PF_META_TOT_TBL1) to review and define job totals for various data that is used as input or output to the different source or target tables in the system.

Navigation

select EPM Foundation, then select Foundation Metadata, then select Metadata Creation and Editing, then select Job Total Metadata

Image: Job Total Metadata page

This example illustrates the fields and controls on the Job Total Metadata page. You can find definitions for the fields and controls later on this page.

Description

The description that you enter here is used by the Metadata Search engine to find your metadata.

Constraint Code

Select a constraint code. Constraints are used in this case to define the scope of the data that is being totaled. This data could come from a single table, but the scope of the data to be considered could depend on data in other tables.

This field is not available if you are setting up job totals for the SUMM Job ID (PF Record Summary engine). For PF Record Summary, job totals are defined using the Record field.

Field Name

Select a field name. This field displays the primary record for the field name that you select. For record summary totals, select the record name. The field name identifies the field that you want to total. If the list box does not list the field that you expected, check your datamap definition.

Aggregate Function

For aggregate functions, you usually select Summation to ensure that all the amounts in the specified field are summed.

Select Count to count total records in the data (for example, to count the number of employee IDs).

Select Average to average the specified field name totals.

Balance Rules Metadata Page

Use the Balance Rules Metadata page (PF_META_BAL_TBL1) to review and define balance rules.

Navigation

select EPM Foundation, then select Foundation Metadata, then select Metadata Creation and Editing, then select Balance Rules Metadata

Image: Balance Rules Metadata page

This example illustrates the fields and controls on the Balance Rules Metadata page. You can find definitions for the fields and controls later on this page.

Description

The description that you enter is used by the Metadata Search engine to find your metadata.

Report ID

Select the ID of the report that you want to generate to help analyze any problems that caused the balance differences.

Rule Sequence

Enables you to group similar rules as subrules. To compare more than one balance field amount, click the add button in the Rule Sequence field to add a rule for a different balance amount field. For example, to compare posted total amounts, create rule sequence 1 and then click the Add button to add rule sequence 2 to compare base amounts.

Description

Enter a description that accurately defines the balance rule.

Threshold Percentage

Specify a percentage that reflects the highest percentage that you want to use for analysis. For instance, entering 5.00 in this field would indicate that if the difference between resources and activities in Activity-Based management is over five percent, the system should display the amounts. If the difference is not over five percent, post to the performance ledger table.

Rule Use

Select from the following rule uses:

Rule Use	Description
`Control`	Select `Control` if you are comparing tables for engine output amounts. For example, you would select `Control` and enter a threshold percentage if you were tracking whether the amount for resources equaled the amount that was driven to activities in Activity-Based Management. Any balance error is assigned a batch error status. Generate reports to analyze the balance error before posting.
`Force Balance`	Use `Force Balance` to post balance rule differences that should be posted to the PF Journal table. Then select the ledger event code that identifies the account to which the differences will be posted in the PF Ledger table.
`Info Only` (information only)	Select `Info Only` if you are comparing totals that are not critical (for example, the number of records). `Info Only` does not create a balance error batch. The batch will be valid.

Ledger Code

For a rule use of Force Balance,select the account to which the differences that are generated by force balancing should be posted in the performance ledger table.

Job ID

Select the job ID that is defined on the Job Metadata page.

Section

This is not a required field. Use this field to help you identify the problem area when an-out-of balance error occurs. The system uses the prompt table PS_PF_META_SEC_VW3. Before a section can be considered valid, it must first be defined in the engine metadata. Valid section codes that you enter on the engine metadata page are the actual application engine sections within the application engine program.

Total ID

Select the total ID that is defined in the Job Totals Metadata page.

Arithmetic Operation

Select an arithmetic operation (for example, + or −) to add or subtract multiple job totals. These operations are used with the Side field

Side

Select Left for the input total IDs, and Right for the output total IDs.

PF Reconciliation Page

Use the PF Reconciliation page (RUN_PF_JOB) to run the PF Reconciliation engine to compare to and from amounts between tables.

Navigation

select EPM Foundation, then select Data Enrichment Tools, then select Profit Manager, then select Performance Journals, then select Reconcile Balances, then select PF Reconciliation

Image: PF Reconciliation page

This example illustrates the fields and controls on the PF Reconciliation page.

The parameters on this page are described in the Streamlining Processing with Jobstreams topic earlier in this documentation.

After running PF Reconciliation, you can view your balance and reconciliation results using the Review Bal/Recon Results (review balance reconciliation results) component.

Note: You must include the PF Merge engine in a jobstream with the PF Reconciliation engine.

Job Totals Page

Use the Job Totals page (PF_RECON_TOT_DATA) to a display-only page that shows the results of a job totals reconciliation.

Navigation

select EPM Foundation, then select Data Enrichment Tools, then select Profit Manager, then select Performance Journals, then select Review Bal/Recon (Balance/Reconcile) Results, then select Job Totals

Use the Job Totals page to review the job total information from your job. For example, you could use the total value on this page to verify that for Activity-Based Management, the total amount that was allocated to resources was transferred to the CALC_OBJ_F00 table.

Image: Job Totals page

This example illustrates the fields and controls on the Job Totals page.

This is a display-only page that shows the results of a balance reconciliation. If the Release Record Suite check box is selected, then this job has been released from a record suite.