Recomputing Ownership Data

A prompt to Recompute Ownership data may be displayed if any of these conditions occur:

  • Metadata change
  • Consolidation Methods configuration change
  • Change in Migration import files

If you make changes to the Entity structure, for example, if an entity is moved under a different parent member (a hierarchy change), the status of all the periods will be System Impacted, and a warning message will be displayed at the top of the Manage Ownership screen that you must Recompute Ownership data.

If you do not recompute data after the Ownership change, when you run the Consolidation process, an error message displays, for example:

Ownership Data changed in the last period of the prior year. Please copy ownership data from the last period of the prior year - Actual FY22, Dec.

To consolidate data in any unlocked period, you must run Recompute Ownership Data from that specific period. The Consolidation process will not force Recompute Ownership data for prior periods.

For example:

FY22 All periods are locked.

FY23 January and February are locked.

In this case, you would need to Recompute Ownership data from FY23 March, and you do not need to unlock the prior period FY23 February.

When Enhanced Organization by Period is enabled for an application, and a member is shared, if you recompute ownership for a year, you are prompted to copy ownership to the next year. A best practice is to only recompute ownership for years and periods that you intend to consolidate.

If you make any changes to Consolidation Methods range settings, you must also recompute the POV-specific Ownership data. A warning message will be displayed at the top of the Manage Ownership screen if the data has not been recomputed.

Recomputing Ownership Automatically in Manage Ownership

From the Manage Ownership page, you can automatically recompute ownership data. If the Recompute Ownership Data process is required, a notification is displayed at the top of the page. When you click the Recompute Now link in the notification, Financial Consolidation and Close automatically recomputes data based on the current POV. This eliminates the need for you to open the Recompute Ownership dialog box, select the Scenario, Year, and Start Period and run the process.

Recomputing Ownership Data During Consolidation

A Consolidation Setting called Auto Recompute Job provides the ability to automatically recompute ownership data during the consolidation process if it is required. If this setting is not enabled, when you run a consolidation/translation process, every time there are changes to the metadata, an error displays that you must manually recompute ownership data, which can be time-consuming. After enabling the Auto Recompute Consolidation Setting, (a one-time activity), the system will automatically perform the Recompute Ownership process as the first step when you invoke a task that is dependent on it, for example, Consolidation/Translation.

To enable the Auto Recompute Job Consolidation Setting, see Managing Consolidation Settings.

Recomputing Ownership Data Manually

To recompute Ownership data:

  1. On the Home page, click Application, then Consolidation, and then click Manage Ownership.

  2. Select Actions, and then select Recompute Ownership Data.

  3. Select the Scenario, Year and Period(s) to recompute.

    Note that recomputation will be applied to the selected period and all subsequent periods.

    Also note that if a recomputation of a POV is necessary, a consolidation of that POV will not complete until the Ownership data is recomputed.

  4. Click Recompute.

    When the ownership data is recomputed, if the process takes longer than 60 seconds, then the remainder of the process will be continued in the background and you can navigate to other screens if required. To view the progress of the process, open the Jobs console.

  5. From the Recomputation success message, click OK.