Table of Contents
- Title and Copyright Information
- Documentation Accessibility
- Documentation Feedback
- 1 Oracle Financial Consolidation and Close Cloud Overview
- 2 Creating an Oracle Financial Consolidation and Close Cloud Application
- 3 Managing Security
-
4
Managing Applications
- Application Overview
- Managing Dimensions
- Importing Metadata
- Exporting Metadata
- Validating Metadata
-
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
-
6
Designing Custom Navigation Flows
- Understanding 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
- 8 Designing Financial Dashboards
-
9
Working with Dimensions
- Dimensions Overview
- Viewing and Editing Dimensions
- Working with Dimension Hierarchies
- Adding Custom Dimensions
- Using Extended Dimensionality
-
Defining Accounts
- Account Types
- Summary of Account Types
- Aggregation (Consolidation Operator)
- Time Balance Property
- Account Types and Variance Reporting
- Setting Account Calculations for Zeros and Missing Values
- Saved Assumptions
- Data Types and Exchange Rate Types
- Defining Account Properties
- Setting Account Attribute Values
- Defining Entity Members
- Creating Alternate Hierarchies
- Oracle Financial Consolidation and Close Cloud Data Model Overview
- Working with Members
- Setting Up Currencies
- Setting Up Scenarios
- Customizing Application Years
- Working with Attributes
- Working with Attribute Values
- Working with User-Defined Attributes (UDAs)
- Working with Member Formulas
- Working with Alias Tables
- 10 Editing Dimensions in the Simplified Dimension Editor
- 11 Managing Jobs
- 12 Auditing Tasks and Data
-
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
- Suppressing Invalid Data in Forms
- Working with Valid Intersections in Forms
- Managing Invalid Intersection Reports
-
Understanding Valid Intersections
-
14
Managing Forms
- Predefined Forms
- Form Components
- Form Design Considerations
- Creating Simple Forms
-
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
- Working with Substitution Variables
- Working with User Variables
- Working with Smart Lists
- 15 Managing Journals
-
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
- 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
- About Override Translation Rules
- Creating Override Translation Rules
- Deploying Override Translation Rules
- About 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
- 18 Managing Approval Unit Hierarchies
-
19
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
-
20
Setting Up the Close Process
- Close Manager Terms
- Close Process Overview
- Sample Task Flows
- Managing Close Manager System Settings
- Managing Close Process Attributes
- Managing Alert Types
- 21 Managing Teams for Close Manager
-
22
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
-
23
Managing Task Templates
- Creating Task Templates
- 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 Templates
- Searching for Templates
- Deleting Templates
-
24
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
-
25
Managing Close Schedules
- Manually Creating Schedules
- 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
- 26 Managing Close Manager Integrations
- 27 Using Close and Supplemental Data Manager Reports
-
28
Managing Supplemental Data
- Supplemental Data Process Overview
- Managing Supplemental Data System Settings
- Working with the Data Set Dashboard
- Managing Dimension Attributes in Supplemental Data Manager
- 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
- 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
- 29 Managing Supplemental Data Manager Teams
- A Close Manager Integrations with EPM Cloud Services
- B Close Manager Integrations with Cloud and On-Premises Applications