Table of Contents

• Title and Copyright Information
• Documentation Accessibility
• Follow us on Social Media
• 1 Oracle Financial Consolidation and Close Cloud Overview
  • Overview of the Home Page
  • Integrating with Other Services
• 2 Creating an Oracle Financial Consolidation and Close Cloud Application
  • Application Prerequisites
  • Workflow for Creating an Application
  • Creating a Sample Application
  • Creating an Application
  • Enabling Application Features
    • Application Feature Descriptions
    • Consolidation and Supplemental Data Features
  • Enabling Ownership Management in Applications
  • Migrating Net Income Data
  • Creating Extended Dimension Applications
• 3 Managing Security
  • Security Overview
  • Managing Artifact and Data Access
    • Assigning User Access to Artifacts
    • Assigning User Access to Data
    • Enabling or Disabling Security for Dimensions
    • Assigning Security to Dimension Members
    • Data Source Dimension Security
  • Managing Forms Security
    • Assigning Access to Forms and Folders
    • Default Form Security
• 4 Managing Applications
  • Application Overview
  • 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
    • 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 - Overrides
    • Example: Data Import File - Exchange Rates
    • Load Methods
    • Load Method Examples
    • Loading the Data Import File
  • Exporting Data
  • Viewing Data Import and Export Status
  • Importing Data Using Data Management
  • Exporting Data Using Data Management
  • Copying Data
  • Clearing Data
  • Refreshing the Database
  • Restructuring Cubes
  • Removing an Application
  • Scheduling Maintenance
  • Using the Inbox/Outbox
  • Working with Activity Reports and Access Logs
• 5 Connecting Subscriptions in EPM Cloud
  • About Connecting EPM Cloud Subscriptions
  • Considerations When Migrating Cross-Subscription Connections
  • Creating, Editing, and Deleting Connections to Other EPM Cloud Subscriptions
  • Common Connection Errors and Resolutions
  • Navigating Across EPM Cloud Subscriptions
  • Customizing Navigation Flows to Access Other EPM Cloud Subscriptions
    • Grouping Cards from Other EPM Cloud Subscriptions into Clusters
    • Configuring Cards with Tabs from Multiple EPM Cloud Subscriptions
• 6 Designing Custom Navigation Flows
  • Understanding Navigation Flows
    • What Can Be Customized in the Application Interface?
    • Navigation Flow Customization Categories
    • Navigation Flow Permissions
    • Predefined Navigation Flows
  • Viewing and Working with Navigation Flows
    • Creating and Duplicating Navigation Flows
    • Editing a Navigation Flow
    • Activating and Deactivating Navigation Flows
    • Customizing Labels for Cards, Tabs, and Clusters
    • Customizing Icons for Cards and Vertical Tabs
    • Hiding and Unhiding Cards and Tabs
    • Changing the Display Order of Cards on the Home Page
    • Adding Cards
    • Adding Tabs to a Tabular Page
    • Removing Navigation Flows, Cards, and Tabs
    • Grouping Cards into Clusters
    • Reloading a Navigation Flow
    • Switching Navigation Flows at Runtime
    • Why Is My Referenced Card, Tab, or Cluster Not Visible?
• 7 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 Application Interface to Access Infolets
• 8 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
  • Dashboard POVs and Valid Intersections
• 9 Working with Dimensions
  • Dimensions Overview
    • Account
    • Period
    • Data Source
    • Consolidation
    • Currency
    • Entity
    • Intercompany
    • Movement
    • Scenario
    • Year
    • View
    • Multi-GAAP
  • 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
    • 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
  • Using Extended Dimensionality
  • Defining Accounts
    • Account Types
    • Time Balance Property
    • 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
  • Oracle Financial Consolidation and Close Cloud Data Model Overview
  • Working with Members
    • Seeded Dimension Members
    • Built-in Calculations
    • Dynamic Members
    • Adding or Editing Members
    • Deleting Members
    • Deleting Parent Members
    • Viewing Member Properties from Forms
    • Working with Shared Members
    • Creating Shared Members
  • Setting Up Currencies
    • Working with Multiple Currencies
    • Scaling
    • Number Formatting
    • Viewing Currency Usage
    • 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
    • Understanding Attribute Data Types
    • Deleting Attributes
  • Working with Attribute Values
    • Creating Attribute Values
    • Assigning Attribute Values to Members
    • Modifying Attribute Values
    • Deleting Attribute Values
  • Working with User-Defined Attributes (UDAs)
    • Creating UDAs
    • Changing UDAs
    • Deleting UDAs
  • Working with Member Formulas
    • Viewing Details of Formula Verification
  • Working with Alias Tables
    • About Alias Tables
    • Creating Alias Tables
    • Editing or Renaming Alias Tables
    • Deleting Alias Tables
    • Clearing Alias Tables
    • Copying Alias Tables
• 10 Editing Dimensions in the Simplified Dimension Editor
  • About Editing Dimensions in the Simplified Dimension Editor
  • Accessing the Simplified Dimension Editor
  • Working with the Simplified Dimension Editor Grid
    • Switching to Another Dimension
    • Customizing the Column Layout
    • Viewing Ancestors
    • Showing Member Usage in an Application
    • Focusing Your Editing
    • Finding Members
    • Sorting Members
    • Moving Members to Another Hierarchy
    • Working with Member Formulas
    • Copying Member Names from Microsoft Excel
  • Editing Dimension Properties in the Simplified Dimension Editor
  • Editing Member Properties in the Simplified Dimension Editor
    • Adding Members in the Simplified Dimension Editor
    • Editing Members in the Simplified Dimension Editor
    • Deleting Members in the Simplified Dimension Editor
    • Adding Shared Members in the Simplified Dimension Editor
• 11 Managing Jobs
  • Jobs Overview
  • Viewing Pending Jobs and Recent Activity
  • Scheduling Jobs
  • Editing and Deleting Jobs
• 12 Auditing Tasks and Data
  • Configuring Audit Tasks
  • Auditing Information Overview
  • Viewing Audit Details
• 13 Defining Valid Intersections
  • Understanding Valid Intersections
    • Valid Intersection Groups
    • Valid Intersection Rules
    • Anchor and Nonanchor Dimensions
    • Valid Intersection Examples
      • Example: Anchor and Nonanchor Dimensions
      • Example: Required Dimension
      • Example: Unselected Members are Valid
      • Example: Redundant or Overlapping Valid Intersection Rules Within the Same Valid Intersection Group
      • Example: Redundant or Overlapping Valid Intersection Rules in Different Valid Intersection Groups
    • Redundancy or Overlap in Valid Intersection Rules
    • Shared Members and Valid Intersection Rules
    • Substitution Variables and Valid Intersection Rules
    • Evaluation Order
  • Creating Valid Intersections
  • Managing Valid Intersections
    • Viewing Valid Intersections
    • Changing the Valid Intersection Group Evaluation Order
    • Disabling and Enabling Valid Intersection Groups
    • Editing Details for a Valid Intersection Group
    • Duplicating Valid Intersection Groups
    • Deleting a Valid Intersection Group
  • Suppressing Invalid Data in Forms
  • Working with Valid Intersections in Forms
  • Managing Invalid Intersection Reports
    • Creating an Invalid Intersection Report
    • Editing an Invalid Intersection Report
    • Duplicating an Invalid Intersection Report
    • Running an Invalid Intersection Report
    • Deleting an Invalid Intersection Report
• 14 Managing Forms
  • Predefined Forms
  • Form Components
    • Point of View
    • Page Axis
    • Rows and Columns
  • Form Design Considerations
    • Forms and Access Permissions
    • Forms and Currencies
    • Forms and Versions
    • Forms and Attributes
    • Forms and Shared Members
    • Forms and Calculations
  • Creating Simple Forms
    • Setting Form Layout
    • Setting Form Grid Properties
    • Setting Form Dimension Properties
    • Setting Display Properties
    • Setting Printing Options
      • Including Data Validation Rules in Forms
      • Setting Form Precision and Other Options
      • Creating Asymmetric Rows and Columns
      • Adding Formula Rows and Columns
      • Defining Simple Form Page and Point of View
  • Creating Composite Forms
    • Setting Composite Form Layout
    • Adding Simple Forms to a Composite Form Layout
    • Rearranging Forms in the Layout
    • Editing Simple Forms from within a Composite Form
    • Deleting Simple Forms from a Composite Form
    • Setting Composite Form Section Properties
    • Setting Composite Form Point of View and Page Dimensions
    • Creating Master Composite Forms
    • Embedding Charts in Composite Forms
  • Working with Forms and Form Components
    • Opening Forms
    • Previewing Forms
    • Editing Forms
      • Editing Simple Forms
      • Editing Composite Forms
    • Moving, Deleting, and Renaming Forms
  • Working with Substitution Variables
    • About Substitution Variables
    • Creating and Assigning Values to Substitution Variables
    • Deleting Substitution Variables
  • Working with User Variables
    • About User Variables
    • Managing User Variables
    • Creating User Variables
    • Deleting User Variables
  • Working with Smart Lists
    • Synchronizing Smart Lists in Reporting Applications
    • Adding or Changing Smart List Properties
    • Adding or Changing Smart List Entries
    • Previewing Smart Lists
    • Displaying #MISSING with Smart Lists
• 15 Managing Journals
  • Creating Journal Groups
  • Deleting Journal Groups
  • Managing Journal Periods
  • Setting Journal Options
  • Journal Referential Integrity
• 16 Consolidating Data
  • Consolidation Process
  • Data Flow
  • Intercompany Eliminations
  • Consolidation Dimension
  • Translation Process
  • Translating Data
  • About Exchange Rates
  • Entering Exchange Rates
  • Entering Override Rates
  • Specifying Default Translation Settings
  • Consolidation and Translation Security Access
  • Calculation Status
  • Consolidating Data
  • Viewing Consolidation Progress
  • Running a Consolidation Report
  • Consolidation Examples
    • Example 1: Reconsolidating Data from a Form
    • Example 2: Consolidating Data from the Data Status Grid
    • Example 3: Consolidating Data for Multiple Periods
  • Advanced Consolidation Overview
  • Consolidation Logic
  • Managing Consolidation Methods
  • Modifying Consolidation Methods
  • Adding Consolidation Methods
  • Importing and Exporting Consolidation Methods
  • Recomputing Ownership Data
  • Managing Ownership
  • Changing Manage Ownership Settings
  • Importing and Exporting Ownership Data
  • Ownership Settings Year to Year
  • Ownership Settings in Forms and Configurable Calculation Rules
  • Advanced Consolidation Rules
  • About Configurable Consolidation Rules
  • Managing Consolidation Rule-sets and Rules
  • Creating Consolidation Rule-sets
  • Creating Consolidation Rules
  • Consolidation Strings
  • Viewing Rule-Sets
  • Deploying and Undeploying Rule-Sets
  • Duplicating and Deleting Rule-Sets
  • Seeded Consolidation Rules
    • Investment Rule-Set
    • Investment PP Rule-Set
    • Owner's Equity (Subsidiary/Proportional) Rule-Set
    • Owner's Equity (Subsidiary/Proportional) PP Rule-Set
    • Owner's Equity (Equity) Rule-Set
    • Owner's Equity (Equity) PP Rule-Set
    • Owner's Equity (Holding) Rule-Set
    • Net Income (Subsidiary) Rule-Set
    • Net Income (Equity) Rule-Set
    • Seeded Consolidation Rule Examples
    • Seeded Consolidation Rules - Example (January)
    • Seeded Consolidation Rules - Example (February)
    • Seeded Consolidation Rules - Example (March)
• 17 Working with Rules
  • Consolidation and Translation Rules
  • Selecting Business Rules
  • Assigning Access to Rules
  • Working with Override Translation Rules
    • Creating Override Translation Rules
    • Deploying Override Translation Rules
  • Working with Configurable Calculations
    • Creating Configurable Calculations
    • Enabling Auto Create Blocks for Configurable Calculations
    • Configurable Calculation Rules
    • System Calculations
    • Working within Calculation Manager
    • Working with Essbase Calc Script
    • Supported Essbase Functions
    • Configurable Calculations Best Practices
  • Working with On-Demand Rules
    • Guidelines for On-Demand Rules
    • Creating On-Demand Rules
    • Adding On-Demand Rules to Data Forms
    • Importing and Exporting On Demand Rules
    • Launching On-Demand Rules
    • Calculation Status for On-Demand Rules
    • Renaming On-Demand Rules
    • Deleting On-Demand Rules
• 18 Managing Approval Unit Hierarchies
  • Creating Approval Unit Hierarchies
    • Setting Up the Approval Unit Hierarchy
    • Selecting Approval Unit Hierarchy Members
    • Assigning Approval Unit Owners and Reviewers
    • Assigning Approval Unit Hierarchies to Scenarios
  • Editing Approval Unit Hierarchies
  • Viewing Approval Unit Hierarchy Usage
  • Synchronizing Approval Unit Hierarchies
  • Deleting and Renaming Approval Unit Hierarchies
  • Exporting Approval Unit Hierarchies
  • Importing Approval Unit Hierarchies
• 19 Managing the Approval Process
  • Approval Process Overview
  • Enabling Approvals
  • Starting the Approval Process
  • Approval Unit Promotional Path
  • Creating Approval Unit Annotation Reports
  • Creating Approval Status Reports
  • Data Validation Rules
  • Locking and Unlocking Entities
• 20 Managing Application and System Settings
  • Specifying Application Settings
  • 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
• 21 Setting Up Task Manager
  • Task Manager Terms
  • Task Manager Overview
  • Sample Task Flows
  • Managing Task Manager System Settings
    • Managing Global Integration Tokens
      • Creating a Global Integration Token
      • Deleting a Token
    • Managing Task Manager Organizational Units
      • Adding Organizational Units
      • Importing Organizational Units
      • Selecting an Organizational Unit
    • Managing Holiday Rules for Tasks
      • Creating Holiday Rules
      • Applying a Holiday Rule to an Organizational Unit
      • Applying a Holiday Rule to a Schedule Template
      • Importing Holiday Dates
      • Editing Holiday Rules
      • Duplicating Holiday Rules
      • Deleting Holiday Rules
    • Changing Configuration Settings
      • Allowing Comment Deletions
      • Allowing Task Deletions
      • Displaying Upcoming Tasks
      • Approver Levels
      • Enabling Email Notifications
      • Reopening Tasks
      • Specifying Task Display in Smart View
      • Setting the Task Attachment Size
      • Allowing Reassignment Request Approvals
  • Managing Task Manager Attributes
    • Defining Task Manager Attributes
    • Defining Calculation Attributes
    • Importing List Attributes
    • Editing Attributes
    • Duplicating Attributes
    • Deleting Attributes
    • Viewing Attributes
    • Searching for Attributes
  • Managing Alert Types
    • Creating Alert Types
    • Editing Alert Types
    • Viewing Alert Types
    • Searching for Alert Types
    • Deleting Alert Types
• 22 Managing Teams for Task Manager
  • Adding Teams and Members for Task Manager
  • Editing Teams and Members for Task Manager
  • Deleting Teams and Removing Members
  • Managing Backup Assignments
  • Requesting a Reassignment in Task Manager
• 23 Managing Task Types
  • Task Types
  • Creating Task Types
  • Setting Task Type Properties
  • Setting Task Type Parameters
  • Specifying Task Type Instructions
  • Specifying Task Type Questions
  • Assigning Task Type Attributes
  • Working With Task Type Rules
  • Viewing Task Type History
  • Editing Task Types
  • Viewing Task Types
  • Searching for Task Types
  • Importing Task Types
  • Exporting Task Types
  • Deleting Task Types
• 24 Managing Task Templates
  • Creating Task Templates
    • Setting Template Properties
    • Specifying Template Instructions
    • Assigning Viewers to Templates
    • Applying Template Attributes
    • Specifying Day Labels
    • Embedding Templates
    • Working With Template Rules
    • Viewing Template History
  • Opening Templates
  • Adding Tasks to Templates
  • Editing Templates
  • Importing Tasks into Templates
  • Task Import File Format
  • Exporting Tasks to Microsoft Excel
  • Reassigning Users in Templates
  • Creating Schedules from Templates
  • Manually Validating Templates
  • Viewing Task Manager Templates
  • Searching for Templates
  • Deleting Templates
• 25 Managing Tasks
  • Creating Tasks
  • Setting Task Properties
  • Setting Task Parameters
  • Specifying Task Instructions
  • Selecting the Workflow
  • Adding Task Questions
  • Setting Task Access
  • Setting Task Predecessors
  • Applying Task Attributes
  • Working With Task Rules
  • Viewing Task History
  • Working with the Task Dialog Box
  • Importing and Exporting Tasks
  • Editing Tasks
  • Adding Attachments
  • Sorting Tasks
  • Searching for Tasks
  • Moving Tasks
  • Cutting, Copying, and Pasting Tasks
  • Reopening Tasks
  • Submitting Tasks
  • Approving or Rejecting Tasks
  • Managing Task Reassignments
  • Aborting Tasks
  • Deleting Tasks
• 26 Managing Schedules
  • Manually Creating Schedules
    • Setting Schedule Properties
    • Adding Instructions to Schedules
    • Assigning Schedule Viewers
    • Applying Schedule Attributes
    • Adding Day Labels
    • Working With Schedule Rules
  • Setting Required Task Parameters
  • Opening Schedules
  • Editing Schedules
  • Adding Tasks to Schedules
  • Importing Tasks into Schedules
  • Updating Tasks in Schedules
  • Reassigning Users in Schedules
  • Setting Schedule Status
  • Viewing Schedule History
  • Validating Schedules
  • Locking Schedules
  • Viewing Schedules
  • Searching for Schedules
  • Deleting Schedules
• 27 Managing Task Manager Integrations
  • Creating Integrations
    • Setting Integration Properties
    • Setting Integration Parameters
  • Editing Integrations
  • Validating Integrations
  • Deleting Integrations
  • Managing Connections
    • Adding Connections
    • Editing Connections
    • Deleting Connections
  • Viewing Integrations
  • Searching for Integrations
  • Creating Custom Task Manager Integrations
    • Creating Custom Process Automation Integrations
    • Creating Custom Event Monitoring Integrations
• 28 Using Task Manager and Supplemental Data Manager Reports
  • Generating Custom Reports for Task Manager and Supplemental Data Manager
    • Creating a Task Manager Query
    • Creating a Supplemental Data Query
    • Creating a Template
    • Setting Up a Report Group
    • Creating a Report
    • Generating the Report
  • Using Task Manager Report Binders
    • Generating Report Binders
    • Viewing Report Binders
• 29 Managing Supplemental Data
  • Supplemental Data Process Overview
  • Managing Supplemental Data System Settings
    • Setting Email Notifications in Supplemental Data
    • Setting Preferences for Supplemental Data
    • Setting Supplemental Data Governors
  • Working with the Data Set Dashboard
  • Managing Dimension Attributes in Supplemental Data Manager
    • Adding Dimension Attributes
    • Editing Dimension Attributes
    • Deleting Dimension Attributes
  • Working with Data Sets
  • Creating Data Sets
  • Adding Data Set Attributes
  • Importing Data Set List Attributes
  • Viewing Data Set History
  • Deleting Data Set Attributes
  • Editing Data Sets
  • Deleting Data Sets
  • Creating Supplemental Data Manager Form Templates
    • Specifying Form Template Instructions
    • Working with Supplemental Data Manager Form Sections
      • Form Template Sections: Columns Tab
      • Form Template Sections: Group By Tab
      • Form Template Sections: Mapping Tab
      • Form Template Sections: History Tab
    • Assigning the Workflow
    • Specifying Form Template Questions
    • Setting Form Template Access
    • Viewing Form Template History
  • Deleting Form Templates
  • Duplicating Form Templates
  • Deploying a Form Template to a Data Collection Period
  • Un-Deploying a Form Template to a Data Collection Period
  • Validating Supplemental Data Total Against an Account Balance
  • Managing Data Collection Workflow
  • Working with Supplemental Data in Smart View
  • Using Currency Translation
  • Selecting Default Currency for Entity Members
  • Setting Up Currency Attributes for Translation
• 30 Managing Supplemental Data Manager Teams
  • Adding Teams and Members for Supplemental Data Manager
  • Importing and Exporting Teams and Members for Supplemental Data Manager
  • Exporting Supplemental Data Manager Users
  • Editing Teams and Members for Supplemental Data Manager
  • Deleting Teams and Removing Members for Supplemental Data Manager
• A Task Manager Integrations with EPM Cloud Services
  • Setting Up an Integration
  • Uploading and Downloading Files Within EPM Services
  • Pre-Built EPM Cloud Integrations
  • End User Integrations for EPM Cloud
• B Task Manager Integrations with Cloud and On-Premises Applications
  • End User Integrations for Oracle Fusion Cloud
  • End User Integrations for On-Premises Applications
  • Setting Up an Integration
  • On-Premises Oracle E-Business Suite (EBS) Integration