Administering Financial Consolidation and Close - Oracle

[Pages:38]Oracle? Cloud

Administering Financial Consolidation and Close

E93973-46

Oracle Cloud Administering Financial Consolidation and Close,

E93973-46

Copyright ? 2016, 2022, Oracle and/or its affiliates.

Primary Author: EPM Information Development Team

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Documentation Accessibility

Documentation Feedback

1 Financial Consolidation and Close Overview

Overview of the Home Page

1-1

Integrating with Other Services

1-6

2 Creating a Financial Consolidation and Close Application

Application Prerequisites Workflow for Creating an Application Creating an Application Enabling Application Features

Application Feature Descriptions Consolidation and Supplemental Data Features Enabling Ownership Management in Applications Copying Local Rate Account Data Migrating to Extended Dimensionality Migrating to Extended Dimensionality and Enterprise Cloud Service

2-1 2-1 2-1 2-3 2-4 2-9 2-10 2-16 2-17 2-18

3 Managing Security

Security Overview

3-1

Managing Artifact and Data Access

3-1

Assigning User Access to Artifacts

3-3

Assigning User Access to Data

3-3

Enabling or Disabling Security for Dimensions

3-4

Assigning Security to Dimension Members

3-4

Data Source Dimension Security

3-6

Managing Forms Security

3-6

iii

Assigning Access to Forms and Folders Default Form Security

4 Managing Applications

Application Overview Restrictions for Dimensions, Members, Aliases, and Forms Managing Dimensions Importing Metadata

Creating the Metadata Import File Example: Entity Dimension Import File Other Supported Delimiter Characters Loading the Metadata Import File Exporting Metadata Validating Metadata Metadata Validation Messages Importing Data Creating the Data Import File Data Import File Format Data Load Methods Load Method Examples Loading the Data Import File Example: Data Import File - Periodic View Example: Data Import File - YTD View Example: Data Import File - YTD Input and Replace Mode Example: Data Import File - Closing Balance Input and Replace Mode Example: Data Import File - Overrides Example: Data Import File - Exchange Rates Exporting Data Viewing Data Import and Export Status Importing Data Using Data Management Exporting Data Using Data Management Data Integrations Copying Data Using Copy Data Profiles Clearing Data Using Clear Data Profiles Refreshing the Database Restructuring Cubes Removing an Application Scheduling Maintenance

3-7 3-8

4-1 4-2 4-5 4-6 4-6 4-7 4-7 4-9 4-10 4-11 4-12 4-21 4-21 4-21 4-22 4-23 4-24 4-26 4-26 4-27 4-28 4-29 4-29 4-30 4-31 4-31 4-32 4-33 4-34 4-36 4-37 4-38 4-39 4-41 4-42 4-43

iv

Using the Inbox/Outbox Working with Activity Reports and Access Logs

4-43 4-43

5 Managing Application and System Settings

Specifying Application Settings Uploading Fonts in Enterprise Performance Management Cloud Deployments Specifying a Default Alias Table, and Setting Member and Alias Display Options Specifying Number Formatting Preferences Defining User Variables Customizing Your Application Appearance Making Announcements Specifying Artifact Labels Working With the Artifact Labels Grid Adding Languages and Defining Localized Artifact Labels Exporting and Importing Artifact Labels for Editing Reviewing Artifacts Working with Substitution Variables

About Substitution Variables Creating and Assigning Values to Substitution Variables Substitution Variables for Financial Consolidation and Close Deleting Substitution Variables

5-1 5-9 5-10 5-10 5-11 5-12 5-13 5-13 5-13 5-14 5-15 5-16 5-16 5-16 5-16 5-17 5-22

6 Connecting Environments in EPM Cloud

About Connecting EPM Cloud Environments Considerations for Migrating EPM Cloud Connections Creating, Editing, and Deleting Connections to Other EPM Cloud Environments Connecting to External Web Services Specifying Advanced Options for External Connections Navigating Across EPM Cloud Environments Customizing Navigation Flows to Access Other EPM Cloud Environments

Grouping Cards from Other EPM Cloud Environments into Clusters Configuring Cards with Tabs from Multiple EPM Cloud Environments Using Direct URLs to Integrate Connected Environments

6-1 6-3 6-4 6-5 6-6 6-7 6-8 6-8 6-12 6-15

7 Designing Custom Navigation Flows

Understanding Navigation Flows

7-1

What Can Be Customized in the Business Process Interface?

7-1

Navigation Flow Customization Categories

7-2

Navigation Flow Permissions

7-2

v

Predefined Navigation Flows Viewing and Working with Navigation Flows

Navigation Flow Design Best Practices and Naming Considerations Creating and Duplicating Navigation Flows Editing a Navigation Flow Activating and Deactivating Navigation Flows Resolving Navigation Flows that Display a Warning Icon Customizing Labels for Cards, Tabs, and Clusters Customizing Icons for Cards and Vertical Tabs Hiding and Unhiding Clusters, Cards, and Tabs Changing the Display Order of Cards on the Home Page Adding Cards Adding Tabs to a Tabular Page About Using URLs to Embed Third-Party Pages in EPM Cloud Applications Removing Navigation Flows, Cards, and Tabs Grouping Cards into Clusters Reloading a Navigation Flow Switching Navigation Flows at Runtime

8 Designing Infolets

About Infolets Anatomy of an Infolet Determining Infolet Content

Designing Forms for Infolets Designing Charts for Infolets Using the Infolets Designer Creating Infolets Working with Infolets Customizing the Interface to Access Infolets

9 Designing Financial Dashboards

Designing Dashboards About Your Dashboard's Layout About the Gauge Chart Type About the Tile Chart Type Customizing Dashboard Colors Setting Line Width in Line and Combination Charts About Global and Local POVs

7-2 7-3 7-3 7-4 7-5 7-6 7-6 7-7 7-7 7-8 7-8 7-9 7-11 7-13 7-14 7-15 7-17 7-17

8-1 8-3 8-6 8-7 8-7 8-8 8-10 8-11 8-12

9-1 9-2 9-3 9-5 9-7 9-7 9-8

vi

Dashboard POVs and Valid Intersections

10

Working with Dimensions

Dimensions Overview Account Period Data Source Consolidation Currency Entity Intercompany Movement Scenario Year View Multi-GAAP

Converting Period and Movement Dimensions to Dense Dimensions Viewing and Editing Dimensions Working with Dimension Hierarchies

Expanding and Collapsing Dimension Hierarchies Navigating Dimension Hierarchies Finding Dimensions or Members Sorting Members Moving Members Within the Dimension Hierarchy Viewing a Member's Ancestors Showing Member Usage Adding Custom Dimensions Aggregation Options Aggregation Options for Intercompany Entities Data Storage Options

About Dynamic Calc Store Data Storage Shared Data Storage Never Share Data Storage Label Only Data Storage Setting Dimension Properties Setting Dimension Evaluation Order Defining Accounts Account Types Time Balance Property

9-10

10-1 10-2 10-2 10-3 10-5 10-7 10-7 10-8 10-8 10-10 10-10 10-11 10-11 10-12 10-16 10-16 10-16 10-17 10-17 10-18 10-18 10-19 10-19 10-19 10-20 10-21 10-26 10-27 10-27 10-27 10-27 10-27 10-28 10-28 10-29 10-32 10-33

vii

Summary of Account Types and Time Balance Aggregation (Consolidation Operator) Account Types and Variance Reporting Saved Assumptions Data Types and Exchange Rate Types Defining Account Properties Setting Account Attribute Values Defining Entity Members Intercompany Property for Entities Base Currency Creating Alternate Hierarchies Financial Consolidation and Close Data Model Overview Working with Members Seeded Dimension Members Built-in Calculations Adding or Editing Members Deleting Members Making Selections Member Relationships Deleting Parent Members Viewing Member Properties from Forms Working with Shared Members Creating Shared Members Setting Up Currencies Working with Multiple Currencies Number Formatting Creating Currencies Editing Currencies Deleting Currencies Setting Up Scenarios About Scenarios

Time Periods Access Permissions Creating Scenarios Editing Scenarios Deleting Scenarios Copying Scenarios Customizing Application Years Adding Years to the Calendar Editing Year Information Working with Attributes

10-34 10-34 10-36 10-36 10-36 10-37 10-39 10-41 10-41 10-41 10-42 10-43 10-45 10-45 10-57 10-60 10-63 10-63 10-65 10-66 10-66 10-67 10-67 10-68 10-69 10-70 10-71 10-72 10-73 10-73 10-73 10-73 10-74 10-74 10-74 10-75 10-75 10-76 10-76 10-76 10-76

viii

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download