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 |
|
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 |
|
Review and define balance rules. |
PF Reconciliation |
RUN_PF_JOB |
|
Run the PF Reconciliation engine to compare to and from amounts between tables. |
Job Totals |
PF_RECON_TOT_DATA |
|
A display-only page that shows the results of a job totals reconciliation. |
Balance Rule Data |
PF_RECON_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:
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.
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.
Balance Rules Metadata Page
Use the Balance Rules Metadata page (PF_META_BAL_TBL1) to review and define balance rules.
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.
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. |
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.
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.
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.