Executing a Balance Load and Viewing Results

Use the Balance Loads tab under the Balance Loads card to run a balance load job to import balances and then view the balance load results. You can also execute a balance load from the Periods card.

Service Administrators can access all existing balance load templates. Power Users can only run balance loads that were created by them. For example, if both Jane and John are Power Users, John can only run balance load templates created by him.

When you select Translate balances to higher currency buckets, the currency translation fails if the required currency rates are not defined in the system. Click the Missing Currency Rates link in the Result column to view details about the missing rates. After you load or create the required currency rates, click Resume to complete the balance load.

For information on creating a balance load, see Steps to Create and Save a Balance Load Template.

Running a Balance Load from the Periods Card

  1. From the Home page, select Application, then Periods.
  2. Next to the period that you want to load balances into, click Actions and select Import Balances.

    The Balance Loads dialog contains a history of balance loads, reporting the start date, end date, the user who executed it, the status, the result and the mode selected in the balance load template. The status report shows subprocesses and the status of each.

  3. Select an existing balance load to execute and click Run.

Running a Balance Load from the Balance Loads Tab

  1. From the Home page, select Balance Loads.
  2. The Balance Loads tab displays the list of balance loads for the selected period.
  3. Select an existing balance load to execute and click Rerun.

If a balance load job is stuck because one or more balance load processes are not running, you can manually set the status of this job to Error. Select the job and then select Force Close from the toolbar. During the staging phase of the balance load execution, if any integrations are running within Data Integration, an error message is displayed asking you to reset the process within Data Integration. If the staging phase is complete, either the Balance Load phase or post-processing phase, depending on which phase is running, is set to Error status.

Note:

When using Data Integration to load balances, you can test the integration in Data Exchange. However, once testing is complete, the balances can only be loaded through to Account Reconciliation by using Import Balances from the Periods card.

Balance Load Result Errors

The Results column of the Balance Load Results dialog is blank unless a system error occurs or a completeness error exists for the load. These are the potential errors:

  • Error—If a systemic balance load process failure occurs. Clicking the link opens a dialog box that displays the error message and links to a detailed error log.

    You will receive an error message if you try to perform a balance load at the same time as another balance load is processing to the same period. Balance loads cannot be processed in parallel. This also applies to loading data from Importing Pre-mapped Balances or from EPM Automate.

  • Completeness Error—Describes how to verify that you are reconciling 100% of your accounts. Completeness errors:

    • Unmapped Accounts—Balances exist in the source system, but Data Management or Data Integration does not map these balances to a profile in Account Reconciliation. These accounts are visible in the Data Load Workbench by viewing "Invalid" records.

      These warnings in the Results column means balances in the source system did not make their way into a reconciliation in Account Reconciliation because a mapping rule is missing. Click the Unmapped Accounts link to see the list, or view it from the Data Management Data Load Workbench. You can create new mappings for balances with unmapped accounts as described in Creating Mappings for Unmapped Accounts When Loading Balances.

    • Missing Profiles—Balances exist in the source system, and a mapping rule exists in Data Integration, but the mapping rule is mapping the balance to a profile that doesn't exist in Account Reconciliation and the reconciliation for the current period is missing. These accounts will not show up in the Data Integration Workbench under the Invalid filter because, from a Data Integration perspective, these accounts are properly mapped. However, they are mapped to a profile in Account Reconciliation that does not exist and the reconciliation for the period is missing. Therefore, search for these errors in Account Reconciliation.

      Click the link to see the accounts affected by the error. To correct these errors, create the missing profiles as described in Creating Profiles for Balances with Missing Profiles When Loading Balances. If you have configured automatic creation of missing profiles, as described in Configuring Profile Creation Rules to Automatically Create Missing Profiles.

    • Missing Currency Rates — If the currency rates required for currency translation are not available, the translation fails and the Missing Currency Rates link is displayed. Click the Missing Currency Rates link to view details about the missing currency rates. After you define or import the required currency rates, you can resume the balance load operation.