Enabling Ownership Management in Applications

When you create an application, you can enable the Ownership Management feature, which allows you to assign ownership percentages and consolidation methods. You can also enable the feature for an existing application.

For details on this feature, see Managing Ownership.

This section lists the requirements to enable Ownership Management, and the metadata changes that the system implements when it is enabled.

Note:

If you do not enable Ownership Management, there is no impact to your existing application.

Before you enable Ownership Management, review these sections:

Ownership Management Requirements for New Applications

To select the Ownership Management option for a new application:

  • You must enable the Intercompany Data and the Track Intercompany Elimination options.

    If both are enabled, the Ownership Management option is available for selection.

  • If you do not select Ownership Management during application creation, you can enable the feature later if both of these options are enabled.

Ownership Management Requirements for Existing Applications

To enable the Ownership Management option for an existing application:

  • The Intercompany Data option must be enabled.

    If you do not have the Intercompany dimension enabled, you must re-create the application in order to use the Ownership Management feature.

  • The Track Intercompany Elimination option must be enabled.

    You can enable this option in an existing application if the Intercompany dimension is enabled. See Enabling Application Features.

    After you enable a new feature in an existing application, you must reload the navigation flow.

    • On the Home page, click the down arrow next to the user name.

    • On the Setting and Actions menu, click Reload Navigation Flow.

Intercompany Dimension Members for Ownership Management

When you enable the Intercompany Data and Track Intercompany Elimination options, the system creates these dimension members:

  • Intercompany Dimension

  • FCCS_Elimination member of Consolidation Dimension

  • FCCS_Intercompany Elimination member of Data Source Dimension

Member and Alias Considerations for Ownership Management

When you enable Ownership Management, the system adds new seeded Accounts and Movement members with aliases, to support the seeded consolidation rules. This may result in a "Duplicate Alias" error with the existing members in the application.

The following tables list the new Member Names and Aliases for the Account and Movement dimensions. For details all of the metadata changes, including the Consolidation and Data Source dimensions, see Ownership Management Metadata Changes.

Before you enable the Ownership Management feature, you must do the following steps:

  • Review the lists of new seeded members. If you have already defined some members that serve the same purpose, you must delete them to avoid a conflict with the new seeded members.

  • Review your existing Accounts and Movement members to ensure that there is no conflict with the Alias for the new members.

    Note that there will not be a conflict with names for the new members, as the new seeded members have a prefix of FCCS_xxx.

  • If there is a conflict, you should modify your Alias prior to enabling the feature. Otherwise, you will encounter errors during migration or when refreshing the database.

  • If you modify an Alias, you should also modify any existing artifacts in which it is referenced.

  • You should either remove duplicate members from the referenced artifacts, or update the artifacts to reference the proper member.

After enabling Ownership Management, if you encounter errors with members and Aliases, check the Jobs console to see the details on which member Alias is in conflict.

Table 3-2 Account Dimension - New Members

Member Name Alias
FCCS_Dividends Receivable Dividends Receivable
FCCS_Investment in Equity Companies Investment in Equity Companies
FCCS Investment in Equity Companies Investment Investment in Equity Companies - Investment
FCCS_Investment in Equity Companies Equity Pickup Investment in Equity Companies - Equity Pickup
FCCS_Investment Link Investment Link
FCCS_Intangible Assets Intangible Assets and Goodwill
FCCS_Goodwill Goodwill
FCCS_Goodwill Input Goodwill - Input
FCCS_Goodwill Offset Goodwill - Offset
FCCS_Minority Interest Minority Interest
FCCS_Owners Equity Owner's Equity
FCCS_Other Equity Other Equity
FCCS_Revaluation Reserves Revaluation Reserves
FCCS_Dividends Declared Dividends Declared
FCCS_Retained Earnings Current - Pre Ownership Change Retained Earnings Current - Pre Ownership Change
FCCS_Owners Income Owner's Income
FCCS_Minority Interest Income Minority Interest Income
FCCS_Net Discontinued Operations Income Net Discontinued Operations Income
FCCS_Discontinued Operations Income Discontinued Operations Income
FCCS_Discontinued Operations Tax Discontinued Operations Tax
FCCS_Continuing Operations Income Continuing Operations Income
FCCS_Equity Company Income Equity Company Income

Table 3-3 Movement Dimension - New Members

Member Name Alias
FCCS_Mvmts_Acquisitions Acquisition of companies and businesses
FCCS_Mvmts_Disposals Disposal of companies and businesses

Ownership Management Metadata Changes

When the Ownership Management option is enabled, the system implements these changes to metadata.

Account Hierarchy Changes

When Ownership Management is enabled, seeded system Accounts will be created to support consolidation rules.

In addition, the Data Storage property of the existing "FCCS_Percent Consol" member is changed from "Store" to "Dynamic Calc". This account will be dynamically calculated based on the entered Ownership information.

The updated FCCS_Total Assets hierarchy is shown below with these additional accounts:

  • FCCS_Dividends Receivable

  • FCCS_Investment in Equity Companies

  • FCCS_Investment in Equity Companies Investment

  • FCCS_Investment in Equity Companies Equity Pickup

  • FCCS_Investment Link

  • FCCS_Intangible Assets

  • FCCS_Goodwill

  • FCCS_Goodwill Input

  • FCCS_Goodwill Offset

Total Assets hierarchy with Ownership Management

The updated FCCS_Total Equity hierarchy is shown below with these additional accounts:

  • FCCS_Minority Interest

  • FCCS_Owners Equity

  • FCCS_Other Equity

  • FCCS_Revaluation Reserves

  • FCCS_Dividends Declared

  • FCCS_Retained Earnings Current - Pre-Ownership Change

  • FCCS_Owners Income

  • FCCS Minority Interest Income

  • FCCS_Net Discontinued Operations Income

  • FCCS_Discontinued Operations Income

  • FCCS_Discontinued Operations Tax

  • FCCS_Continuing Operations Income

  • FCCS_Equity Company Income

Total Equity hierarchy changes for Ownership Management

The updated FCCS_Drivers hierarchy is shown below with these additional accounts:

  • FCCS_Percent Elim

  • FCCS_Consol Method

  • FCCS_Control

  • FCCS_Control Input

  • FCCS_Consol Method Input

  • FCCS_Percent Consol Input

  • FCCS_Percent Ownership Input

  • FCCS_Percent Min Input

  • FCCS_Percent Consol Prior Input

  • FCCS_Percent Consol Change Input

  • FCCS_Percent Consol- Property changed to Dynamic Calc

  • FCCS_Percent Consol Prior

  • FCCS_Percent Consol Change

  • FCCS_Percent Owners

  • FCCS_Percent Min

FCCS Drivers hierarchy

Consolidation Dimension Changes

  • The Data Storage property of the existing "FCCS_Proportion" member is changed from "Dynamic Calc" to "Store".

  • The "FCCS_Proportion" member is no longer the parent member for "FCCS_Entity Total". Instead, this member is now a sibling for "FCCS_Entity Total".

  • The Data Storage property changes require a reconsolidation for all existing data within the application. The Calculation status is changed to Impacted for all entities. You must reconsolidate all existing data in your application so that the Proportion amount will be calculated and stored in the Consolidation dimension.

    Note:

    If any periods are locked, you must unlock them and then reconsolidate the data.

The FCCS_Contribution hierarchy is shown below with these additional members:

  • FCCS_Proportion

  • FCCS_Entity Total Adj

  • FCCS_Entity Elimination Adj

  • FCCS_Entity Proportion Adj

New Ownership Management members for Consolidation dimension

Movement Member Changes

These new seeded Movement members will be added to support consolidation rules for ownership management:

  • FCCS_Mvmts_Acquisitions_Total

  • FCCS_Mvmts_Acquisitions

  • FCCS_Mvmts_Acquisitions_Input

  • FCCS_Mvmts_Disposals_Total

  • FCCS_Mvmts_Disposals

  • FCCS__Mvmts_Disposals_Input

New Movement members for Ownership Management

Data Source Member Changes

These new seeded Data Source members will be added:

  • FCCS_Total Eliminations is added as a subtotal for FCCS_Intercompany Eliminations plus user-created elimination members for use in Configurable Consolidation rules, and FCCS_Partner Eliminations is added if Partner Eliminations is enabled.

    Prior to release 23.04, system calculated Ownership Eliminations and Adjustments (Acquisitions, Disposals, Entity Elimination Adjustments and Entity Proportion Adjustments) were written to FCCS_Intercompany Eliminations.

    Starting from release 23.04, these system entries will continue to be written to FCCS_Intercompany Eliminations when substitution variable EnableNewAcqDisp is set to False or does not exist. The ability to continue to use FCCS_Intercompany Eliminations for system calculated Eliminations and Adjustments will be removed in a later release.

  • FCCS_AcquisitionsDisposals is used to capture system generated Ownership Adjustments and Eliminations (Acquisitions, Disposals, Entity Elimination Adjustments and Entity Proportion Adjustments). This member will be used starting from release 23.04 when substitution variable EnableNewAcqDisp is set to True. Note that this substitution variable will be removed in a later release and this data source member will be the only member that system adjustments and eliminations are written to. This member is for system use only, so data can only be populated by system calculations and not by rules or data entry (load, manually entered or journalized).

    FCCS_AcquisitionsDisposals is under the FCCS_TotalInputandAdjusted subtotal and not under FCCS_Total Eliminations to ensure that all values associated with acquisitions and disposals are eliminated in the system Intercompany Eliminations process. System Intercompany Eliminations are only applied to level zero members that are under FCCS_TotalInputandAdjusted, and do not include values from members under FCCS_Total Eliminations. Without this change, there could arise a situation where acquisitions and disposals could be generated, prior to both translation and then elimination. The FX entry in FCCS_Intercompany Eliminations member might not be eliminated at the same time as the matching data point within FCCS_TotalInputandAdjusted.

  • FCCS_Source Entities hierarchy will be used by the system for Ownership Management.

The FCCS_Total Data Source hierarchy is shown below with these additional members:

  • FCCS_Total Eliminations

  • FCCS_AcquisitionsDisposals

  • FCCS_Source Entities hierarchy

  • S_Parent Source

  • S_Current Source

  • S_Entity

  • S_FCCS_Total Geography

New Data Source Members for Ownership Management