8.1 Runchart Prerequisites

Prepare the input data, mappings, metrics, and currency settings required before executing the Management Ledger and Instrument reporting runcharts.

Before executing PACS_TOPDOWN_RUNCHART or PACS_BOTTOMUP_RUNCHART, complete the data preparation and configuration steps in this section. Upload the input files, load dimensions, configure mappings and metrics, create data file specifications, load and promote staging data, configure currencies and validate exchange rates, and configure the Account Summary Loader. Complete the prerequisite batches for the required MIS date before executing either run chart.

Create Data File Specifications for Staging Loads:

Before executing the staging loader, configure the required data file specifications.

1. On the Data File Specification screen, click Add.
2. Enter the file details and select DD-MON-YYYY as the date format.
3. Import the required asset column template and save the specification for the staging load.

   For information about creating data file specifications, see the Data File Specification User Guide.

Configuring and Executing the Staging Loader

Use the STG_LOADER batch to load the asset, liability, and management ledger input data into the staging tables.

1. Open STG_LOADER, or create the batch if it is not configured.
2. Confirm that the batch includes STG_ASSET, STG_LIABILITY, and STG_MANAGEMENT_LEDGER, each using Stage Data Loader.
3. Review the input-file and MIS-date parameters. Confirm that the status is Ready and the message Parameters are valid is displayed.
4. Execute the batch and confirm that all three tasks complete successfully before promoting the data.

   For information about executing and monitoring batches, see Execute Batch/Batch Group and Monitor Batch/Batch Group.

Promoting Staged Data

After STG_LOADER completes successfully, promote the asset, liability, and management ledger data for the required processing date.

1. On the Data File History screen, select the asset data for the required processing date and click Promote.
2. Repeat the promotion for the liability and management ledger data.
3. Confirm that the promoted data is available in the corresponding processing tables listed in the following table before executing the runcharts.

   Table 8-1 Staging and Processing Tables for Data Promotion

   Staging table	Processing table
   STG_ASSET	FSI_D_ASSET
   STG_LIABILITY	FSI_D_LIABILITY
   STG_MANAGEMENT_LEDGER	FSI_D_MANAGEMENT_LEDGER

Confirm the functional currency required for reporting. For information about configuring this setting, see Global Preferences.

Confirming Management Ledger Configuration

Confirm the Management Ledger functional currency and fiscal start month in Profitability Management Cloud Service.

1. In Profitability Management Cloud Service, from the left navigation pane, select Maintenance, and then select Management Ledger Configuration.
2. Set or confirm Functional Currency and Start Month.
3. Confirm that the functional currency matches the required reporting configuration and that the start month matches the fiscal calendar.

Activate the required input and reporting currencies before loading exchange rates. See Functional Currency for Reporting

Configuring the Account Summary Loader

Configure the account summary columns before executing the runcharts.

1. In Profitability Management Cloud Service, from the left navigation pane, select Maintenance, and then select Account Summary Load Configuration.
2. Retain the following locked columns under Selected Columns:
   • Account Number
   • As of Date
   • Identity Code
   • ID Number
   • Currency Code
3. Click Move All to Selected Columns to include all available columns.
4. Confirm that Available Columns displays No data to display and that Selected Columns includes the locked and moved columns.
5. Click Save and confirm that Configuration Saved Successfully is displayed.

Before Runchart Execution

After completing the configuration and data-loading steps, execute the following prerequisite batches for the required MIS date:

• Customer Master
• Customer Hierarchy
• PA Joint Accounts
• PA Dim Time
• PA FSI Dim Time
• PA Dim Scenario

Confirm that the prerequisite batches complete successfully before executing PACS_TOPDOWN_RUNCHART or PACS_BOTTOMUP_RUNCHART.

• Uploading Run Chart Input Files
  Upload the dimension, customer, customer hierarchy, joint-account, asset, liability, and management ledger input files required before executing the runcharts.
• Executing the Dimension Loader
  Load the dimension data required for runchart execution and verify that all dimension-loader tasks complete successfully.