Correcting Profit Manager Fact Table Errors Using PF Modification

This topic provides an overview of fact table error correction and discusses how to:

View PF summary statistics.
View and correct errors.

Understanding Profit Manager Fact Table Error Correction

After you have run the PF Summary process on a Profit Manager fact table, you can view and correct any errors that were found by opening the appropriate Profit Manager Fact Correction page. This process enables you to view and correct fact errors for your Profit Manger fact tables. For instance, you can use the Ledger Correction component to review and correct invalid data in the ledger fact table. Although there is a separate menu item and page for the Profit Manager Fact Correction process, the process is exactly the same for each.

There is an error table for each Profit Manager fact table. The error table contains all rows with errors that were found during data migration and is a mirror image of the target table, plus two extra columns called Error Flag and PF_EDIT_SEQ_NUM.

Note: Journal modifications are run separately using PF Journal Modification.

For each modification that you run, you must verify the delivered record metadata, record summary metadata, and job totals metadata are accurate.

PF Summary Statistics Page

Use the PF Summary Statistics page to view PF statistics.

Business Unit and PF Batch ID

Uniquely identifies a batch of data to be summarized or modified. The PF Batch ID is a combination of model ID, the fiscal year, and the accounting period.

Number of Valid Records and Number of Records with Errors

Review these display fields for an overview of the amount of errors. The field names on the left are defined in job totals metadata and are specified in record summary metadata.

Last Edited Time Stamp

These fields display information about who ran the last PF Record Summary and when the PF Record Summary was run.

Click on the Error Fields tab to continue with the modification process.

Error Fields Page

Use the Error Fields page to view and correct errors.

Field Name

Displays the field name of the error.

Field Value

Displays the value for the field name in error.

Number of Errors

Displays the number of records in error for the specified field.

You can correct fields by selecting the appropriate value to correct the specified column errors and clicking the Apply button. For other fields, you can click on the individual rows and correct those errors using the prompt table.