Financial Consolidation and Close (FCC): Implementation

Introduction to Financial Consolidation and Close

• Objectives
• Course Agenda: Day 1
• Course Agenda: Day 2
• Course Agenda: Day 3
• Lesson Objectives
• Introduction to Financial Consolidation and Close
• Key Features
• Key Business Benefits
• FCC Business Process
• Create and Enable the Application and Its Features
• Load Metadata and Data
• Set Up Folders and Forms
• Enter and Adjust Data
• Translate and Consolidate Data
• Review and Approve Data
• Publish Financial Reports
• Task Manager Overview
• Working with Supplemental Data: Overview
• Working with Supplemental Data: Supplemental Data Manager
• Implementation Best Practices and Considerations
• Using Quick-Start Checklist
• Summary

Configuring the Financial Consolidation and Close Business Process

• Objectives
• FCC Business Process: Overview
• Creating an FCC Application
• Create Application: General
• Create Application: Details
• Create Application: Details – 13 Months Option
• Create Application: Features
• Balance Sheet Hierarchy
• Multi-GAAP
• Cumulative Translation Adjustment (CTA), Local GAAP
• Consolidation Journal Adjustments
• Intercompany Data
• Include Ratio Calculations
• Ownership Management
• Custom Dimensions
• Other Options
• Additional Consolidation Members
• Control To-Date View Storage, and Combine Year and Period as a Single Dimension
• Supplemental Data Collection
• Enterprise Journals
• Create Application: Review and Create
• Enabling Features
• Summary

Navigating Financial Consolidation and Close

• Objectives
• Accessing the FCC Environment
• Exploring Home Page
• Exploring Home Page: Global Header, Announcement Panel
• Exploring Home Page: Cards
• Exploring Home Page: Clusters
• Exploring Home Page: Dashboards Cluster
• Exploring Home Page: Application Cluster
• Exploring Home Page: Tools Cluster
• Exploring the Navigator Menu
• Navigation Flows
• Modifying the Default Navigation Flow
• Creating and Duplicating Navigation Flows
• Editing a Navigation Flow
• Customizing Labels and Icons for Cards, Tabs, and Clusters
• Activating and Deactivating Navigation Flows
• Using Validate to Find Missing Artifacts in Navigation Flows
• Exploring Predefined Forms
• Exploring Prebuilt Business Rules
• Viewing Application Recommendations
• Summary

Setting Up Financial Consolidation and Close Dimensions

• Objectives
• Dimensions: Overview
• Dimensions Overview: Cubes
• Dimensions Overview: Dimensions in FCC
• Viewing and Editing Dimensions: Dimension Editors
• Viewing and Editing Dimensions: Simplified Dimension Editor
• Viewing and Editing Dimensions: Classic Dimension Editor
• Exploring Seeded Dimension Members
• Exploring Seeded Dimension Members: Properties
• Exploring Data Storage
• Data Types and Exchange Rate Types
• Setting Up Accounts
• Balance Sheet and Income Statement Accounts
• Historical Accounts
• Ratio and Driver Accounts
• Account Types
• Account Type and Time Balance
• Account Type and Variance Reporting
• Defining Entity Members
• Creating Alternate Hierarchies
• Creating Alternate Hierarchies: Example
• Defining the Currency Dimension
• Setting Up Scenarios
• Defining the Year Dimension
• Defining the Period Dimension
• Defining the Data Source Dimension
• Movement Dimension
• Defining the Consolidation Dimension
• Converting Period and Movement Dimensions to Dense Dimensions
• Summary

Managing Metadata

• Objectives
• Importing Metadata: Overview
• Creating Metadata Import Files
• Metadata File: Example
• Loading Metadata
• Refreshing the Database
• Refreshing the Database: Steps
• Viewing Pending Jobs or Recent Activity
• Exporting Metadata
• Exporting Metadata: Steps
• Summary

Managing Security

• Objectives
• Security: Overview
• Creating Users
• Creating Users: Methods
• Assigning Roles
• Assigning Roles: Role Inheritance
• Managing Artifact Security
• Assigning Security Access to Forms and Folders
• Assigning Security Access to Forms
• Assigning Security Access to Folders
• Data Security: Overview
• Enabling or Disabling Dimension Security
• Enabling or Disabling Dimension Security: Steps
• Assigning Security Access to Dimension Members
• Access Control: Overview
• Managing Groups
• FCC Application Roles
• FCC Application Roles: Cloud EPM Platform Roles
• FCC Application Roles: Data Integration Roles
• FCC Application Roles: Task Manager Roles
• FCC Application Roles: Consolidation Journal–Related Roles
• FCC Application Roles: Assigning Roles
• Summary

Defining Valid Intersections

• Objectives
• Valid Intersections: Overview
• Valid Intersection Groups
• Creating Valid Intersection: Steps
• Creating Valid Intersection Group: Illustration
• Valid Intersection Rules
• Creating Valid Intersection Rules: Illustration
• Anchor and Non-Anchor Dimensions
• Anchor and Non-Anchor Dimensions: Example
• Required and Non-Required Non-Anchor Dimensions
• Unselected Members Are Valid: Example
• Redundant or Overlapping Valid Intersection Rules
• Managing Valid Intersections
• Managing Valid Intersections: Illustration
• Working with Valid Intersections in Forms
• Creating Invalid Intersection Reports
• Summary

Loading Data Using Data Integration

• Objectives
• Data Integration Overview
• System-Level Settings
• Launching Data Integration
• Configuring Source Connections: ERP Cloud
• Registering Applications: Create Application
• Registering Applications: Category
• Managing Period Mappings
• Managing Period Mappings: Explicit Period Processing
• Managing Category Mappings
• Managing Category Mappings: Global Mapping
• Managing Category Mappings: Application Mapping
• Defining Integrations
• Create File-Based Integration
• Setting a File-Based Source and Cloud EPM Target
• Creating File-Based Integrations: Define General Details: Location Attributes
• Mapping Dimensions
• Mapping Members
• Mapping Members:
• Mapping Dimension Members: Add
• Setting Data Integration Options: General Options
• Setting Data Integration Options: Target Options
• Running an Integration
• Running an Integration: Options
• Workbench
• Viewing Results in the Workbench
• Viewing Results in the Workbench: Data View
• Verifying Loaded Data Using Process Details
• Managing Locations
• Summary

Managing Data

• Objectives
• Data Import Overview
• Setting Up a Load File
• Setting Up a Load File: File Type and File Location
• Data Import File: Periodic View
• Data Import File: YTD View
• Load Methods Overview
• Merge: Overwriting Data: Merge, None
• Merge: Overwriting Data: Replace, None
• Replacing Data with Load File Data: Merge, Within File
• Replacing Data with Load File Data: Replace, Within File
• Accumulating Data with Load File Data: Merge, With Database
• Accumulating Data with Load File Data: Replace, With Database
• Importing Data
• Exporting Data
• Copying Data
• Clearing Data
• Summary

Managing Forms

• Objectives
• Forms Overview
• Form Overview: Sample Form
• Predefined Forms
• Predefined forms
• Form Design Considerations
• Creating Forms
• Creating Forms: Layout
• Setting Up the Form Layout
• Setting Up the Form Layout: Grid Properties
• Setting Up Form Layout: Dimension Properties
• Setting Up Form Layout: Display Properties
• Setting Up Form Layout: Print Options
• Setting Up Form Layout: Smart View Options
• Setting Up Form Layout: Validation Rules
• Setting Up Form Layout: Validation Rule Builder
• Setting Up Other Options
• Selecting Business Rules
• Selecting Business Rules: Illustration
• Navigating Forms
• Forms 2.0: Global Tool Bar
• Forms 2.0: Quick Toolbar
• Entering and Submitting Data in Forms
• Adjusting Data
• Spreading Data Using Grid Spread
• Adding Comment
• Tracking Change History
• Moving, Deleting, and Renaming Forms
• Substitution Variables
• User Variables
• Smart Lists Overview
• Managing Smart Lists: Create and Edit
• Associating Smart Lists with Members
• Working with Data Discovery
• Working with Data Discovery: Settings
• Data Discovery: Adding Data Discovery to a Form
• Data Discovery: Running Data Discovery from Forms
• Summary

Managing Intercompany Eliminations

• Objectives
• Intercompany Eliminations Overview
• Enable Intercompany Data
• Elimination Process
• Intercompany Eliminations Overview: Intercompany Dimension
• Specifying Intercompany Account Attributes
• Specifying Intercompany Account Attributes: Intercompany and Plug
• Specifying Plug Account :Changes to Custom Attributes
• Entering Intercompany Data
• Creating Intercompany Reports: Overview
• Creating Intercompany Reports
• Creating Intercompany Reports: POV Dimensions
• Creating Intercompany Reports: Accounts
• Creating Intercompany Reports: Suppression Dimensions
• Creating Intercompany Reports: Suppression Matches
• Creating Intercompany Reports: Suppression Types of Rows
• Creating Intercompany Reports: Display Options and Report Types
• Creating Intercompany Matching Report: Sample Output
• Summary

Managing Consolidation Journals

• Objectives
• Consolidation Journals Overview
• Security Roles
• Consolidation Journals and the Data Source Dimension
• Viewing Consolidation Journals
• Viewing Consolidation Journals: Illustration
• Managing Journal Periods
• Managing Journal Groups
• Journal Templates: Overview
• Journal Templates: View
• Creating Journal Templates: Overview
• Creating Journal Templates
• Creating Journal Templates: Illustration
• Importing Journal Templates: Overview
• Importing Journal Templates
• Exporting Journal Templates: Overview
• Exporting Journal Templates
• Creating Journals
• Creating Consolidation Journals
• Creating Consolidation Journals: Illustration
• Creating Unbalanced Consolidation Journals
• Creating Additional Data Source Members
• Journal Status: Overview
• Journal Status: Working, Completed
• Journal Status: Submitted
• Journal Status: Approved
• Journal Status: Posted
• Creating Journal Reports
• Summary

Enterprise Journals

• Objectives
• Enterprise Journals: Key Capabilities
• Enabling Enterprise Journals in Applications
• Configuring Journal Periods
• Configuring Journal Periods: Opening, Closing, and Locking Periods
• Creating Connections
• Managing Enterprise Journal Targets
• Creating Targets: Properties
• Creating Targets: Attributes
• Enterprise Journal Templates
• Creating Enterprise Journal Templates: Properties
• Creating Enterprise Journal Templates: Instructions
• Creating Enterprise Journal Templates: Sections
• Creating Enterprise Journal Templates: Sections – Header
• Creating Enterprise Journal Templates: Sections – Line Item Details
• Creating Enterprise Journal Templates: Journals
• Creating Enterprise Journal Templates: Questions
• Creating Enterprise Journal Templates: Access
• Creating Enterprise Journal Templates: History
• Creating Recurring Journals
• Deploying Templates to Open Periods
• Deploying Templates to Open Periods: Redeploy, Undeploy
• Preparing and Submitting Journals for Approval
• Attaching Supporting Documentation
• Answering Mandatory Questions
• Approving or Rejecting Submitted Journals
• Submitting Approved Journals for Posting
• Reviewing Completed Journals
• Monitoring Progress by Using Dashboards
• Summary

Running Consolidations

• Objectives
• Consolidation Process: Overview
• Movement Hierarchy
• Data Flow: Overview
• Data Flow
• Consolidation Data Status
• Translation Process: Overview
• Translation Process: Translation to Reporting Currencies
• Exchange Rates: Overview
• Exchange Rates: Types
• Average and Ending Rates
• Average and Ending Rates: Enter Exchange Rates – Single Period and Multi Period
• Amount and Historical Override Rates
• Specifying Default Translation Settings
• Managing Ownership
• Managing Ownership: Enable Ownership Management
• Managing Ownership: View
• Managing Ownership: Change Ownership Settings
• Consolidation Methods: Holding and Subsidiary
• Consolidation Methods: Proportional and Equity
• Consolidation Methods: Not Consolidated, Inactive, Discontinued
• Recomputing Ownership
• Copying Ownership Between Years
• Running Consolidations
• Consolidation Reports : Overview
• Creating and Running Consolidation Reports
• Summary

Managing Jobs and Configuring Audit

• Objectives
• Jobs: Overview
• Managing by Jobs Using the Job Console
• Running Jobs
• Scheduling jobs
• View Pending Jobs and Recent Activity
• Editing and Deleting Jobs
• Auditing: Overview
• Configuring Audit Tasks
• Running Audit Report: Overview
• Running Audit Reports
• Running Task Manager Audit Reports
• Supplemental Data and Enterprise Journal Audit Report
• Exporting Audit Data to a File
• Deleting Audit Data
• Summary

Migrating Artifacts and Data

• Objectives
• Migration: Overview
• Exporting Artifacts and Data to Snapshot Files: Backup
• Exporting Artifacts and Data to Snapshot Files: Component Export
• Exporting Artifacts and Data to Snapshot Files: Artifact Backup
• Downloading Snapshot Files from an Application
• Uploading Archives to an Application
• Importing Snapshot Files – Setting Import Options
• Importing Artifacts and Applications from Snapshots
• Generating Migration Status Reports
• Summary