1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Working with Financial Consolidation and Close Applications
  4. Registering Financial Consolidation and Close Applications

Registering Financial Consolidation and Close Applications

You register and modify Financial Consolidation and Close applications using a wizard that prompts you for information, such as the external application settings, connection URL, and dimensions.

Videos

Your Goal Watch This Video

Learn about registering Financial Consolidation and Close applications.

video graphic Registering Financial Consolidation and Close Applications

Before you begin:

  • Ensure that you have the Application - Create role to register an application. After the registration, you are automatically granted the Owner permission on the application and the default view.

    Note:

    The Service Administrator assigns roles, see Understanding Application Roles and Permissions.
  • Decide which dimensions you want to register. You can register four dimension types: Account, Entity, Movement, and Custom. Each dimension type is valid for specific cubes. When you register an application, properties for each dimension get created automatically. In addition to the standard properties, some additional properties unique to Financial Consolidation and Close get created depending on your application settings. See Predefined Properties for Financial Consolidation and Close Applications.
    Dimension Type Valid Cubes for the Dimension Additional Properties Created
    Account Consolidation (Consol) and Rates
    • Is CICTA Account
    • CICTA Redirection Account

    If intercompany is enabled:

    • Is Plug Account
    • Plug Account
    • Intercompany Account
    Entity Consol and Rates

    If intercompany is enabled: Intercompany Entity

    Movement Consol  
    Custom Consol  
  • For new applications, the data storage properties for the Consol and Rates cubes (for example, PLN.Data Storage (Consol)) are automatically set to be derived from the application default data storage property (PLN.Data Storage). See Derived Properties.

    Note:

    Modifying an existing application's registration and editing an existing cube will not automatically set the data storage property for the cube to be derived from the application default. If you want the value for the cube data storage property to be derived from the application default, you must set up an application override. See Editing Property Parameters.
  • The number of custom dimensions that you can have in your external Financial Consolidation and Close application depends on your application settings:
    • If you have not enabled Extended Dimensionality, the external application supports a maximum of two custom dimensions (one, if multi-GAAP is enabled).
    • If you have enabled Extended Dimensionality, the external application supports a maximum of four custom dimensions (three, if multi-GAAP is enabled).

    Note:

    Oracle Enterprise Data Management Cloud does not limit the number of custom dimensions that you can create for a Financial Consolidation and Close application.

  • Service Administrators cannot configure cross-subscription connections using corporate SSO (identity provider) credentials. If your subscriptions are configured for SSO, ensure that identity domain credentials are maintained for the Service Administrators who configure cross-subscription connections. See Enabling Sign In With Identity Domain Credentials.

For more information, see Understanding Registering Applications.

To register a Financial Consolidation and Close application:

  1. From Applications, click Register.
  2. Enter an application name and, optionally, a description.

    Note:

    The application type, name and description are displayed in the Application list.
  3. If you are connecting to an external application, click Add, and define the connection settings. You can add multiple application connections.
    Field Valid Values Example: connecting to an external application

    Connection Name

    Enter a required connection name, unique to this application.

    US FCCS Cloud Connection

    Connection Description

    Enter an optional description.

    Use this connection to connect to a Financial Consolidation and Close application.

    Instance Location

    Enter a connection URL to the external application in the format:

    https://ServiceName-IdentityDomain-ServiceType.DataCenter.oraclecloud.com    		 https://finclose-uscompany-fccs.US11.oraclecloud.com

    where

    • ServiceName is finclose
    • IdentityDomain is uscompany
    • ServiceType is fccs
    • DataCenter is US11

    Identity Domain

    Enter the identity domain of the external application.

    Note:

    This is the same Identity Domain used in the Instance Location.
    		uscompany

    Username

    Enter an authorized user name

    Note: The user must be a Service Administrator of the external application.

    tom.smith

    Note:

    You must enter the identity domain in one of these fields: Identity Domain or Username. For example, enter uscompany in Identity Domain or uscompany.tom.smith in Username.

    Password

    Enter a password.

    xxxxxxxx

    Primary Connection

    Select this check box to make this the default for importing from and exporting to the external application.

    		 
  4. Review the application summary information, and then click Create.

    Note:

    The application and default view are created and set to draft mode. The default view name is the same as the application name you specified above.
  5. Continue the registration, see Registering Financial Consolidation and Close Application Settings and Dimensions.