FCC: Administrator (5 days)


System administrators and implementation consultants.

Learning Objectives

Also available as


self-paced training via our Keyteach partnership.

Click here for details.

Color logo - no background.png

Gain an in-depth understanding of how to create and manage applications with Oracle’s new Financial Consolidation and Close (FCC).

Course Description

Discover how to manage, maintain and update configurations and metadata to meet new requirements on an ongoing basis. Explore the close manager and how to work with the schedules and templates to provide a structured list of tasks.

Navigate and configure various application components and learn about the validation of metadata. Learn more about member attributes and understand the implications of working with dense and sparse dimensions to adopt best practice design.

Find out about balance sheet movements, supplemental data, intercompany processing and working with journals. Discover how to use life cycle management snapshots to migrate system artefacts. Attendees will also gain an in-depth understanding of consolidation, translation and how to manage entity ownerships.

Find out how to build efficient, effective and responsive applications and master the concepts behind writing multidimensional calculations. Discover how data from a variety of different sources can be transformed and loaded to FCC applications using Data Management.

Attendees will also explore how to automate a wide variety of common tasks including the archive, backup and restore of applications, the import of data and running business rules using EPM Automate.

Course Information

Audience: Implementation consultants, developers, system administrators.

Duration: 5 days

Pre-requisites: None

Delivery method: 

Advanced preparation: None

Recommended CPE credits: 35 credits

Day Summary

Day 1: Overview, Navigation, Close Process, Application Creation and Configuration, Dimensionality and Member Properties.


Day 2: Managing Metadata, Customising the Interface, Data Management, Designing Data Forms and Data Entry Techniques. 


Day 3: Intercompany and Journals, Security and Managing Users, Approval Process, Smart View and Financial Reporting.


Day 4: Closing with Task Manager, Supplemental Data, Application Maintenance and Exchange Rates and Translation.

Day 5: Understanding Calculation, Member Formulas, Introducing Business Rules, EPM Automate and Introducing the REST APIs.

Detailed Agenda

Introduction to FCC

  • Key Components

  • EPM Cloud Consolidation Landscape The Close Process

  • Navigating the FCC Interface

  • Point of View and Selecting Members


Application Creation and Configuration

  • Application Configuration Options

  • Creating a new FCC Application

  • Applications from Migration Snapshots

  • Enabling New Features


Introducing FCC Dimensions

  • Dimensionality and Data Storage

  • Extensible Dimensions

  • FC vs HFM Dimensionality

  • Scenario, Year, Period and View

  • Account and Movement

  • Multi GAAP and Data Source

  • Intercompany and Entity

  • Currency and Consolidation


Member Properties

  • Data Storage and Aggregation Options

  • Aliases and User Defined Attributes

  • Enabled for Approvals

  • Dimension Member Properties


Managing Metatdata

  • Monitoring Jobs

  • Metadata Administration in FCCS

  • Metadata Administration in Smart View


Interface and Navigation Flows

  • Creating Custom Navigation Flows

  • Dashboards and Infolets


Data Management (FDMEE)

  • Concepts

  • Import, Validate and Export

  • Data Management Setup

Designing Data Forms

  • Design Considerations

  • Smart Lists and Variables

  • Data Form Validation

  • Creating Formulas


Data Entry Techniques

  • Basic Data Entry

  • Quick Data Entry Commands

  • Keyboard Shortcuts

  • Comments and Attachments

  • Adjusting Values and Grid Spread

  • Supporting Detail

  • Formatting Data and Data Form Controls


Intercompany and Journals

  • Intercompany Metatdata

  • Matching Intercompany

  • Creating Journals


Security and Managing Users

  • The FCCS Security Model

  • Creating Users

  • Assigning Roles

  • Managing Groups Valid Intersections



  • Manage Approvals

  • Approval Unit Hierarchies

  • Locking Data


Smart View

  • Connection Types and Ribbons

  • Ad Hoc Analysis and Cascade

  • Data Forms and Smart Forms

  • Smart View Functions


Financial Reporting

  • Running and Creating Reports


Closing with Task Manager

  • Templates

  • Tasks

  • Schedules

Supplemental Data

  • Understanding Supplemental Data

  • Data Sets

  • Creating Forms


Application Maintenance

  • Application Migration

  • Scheduling Jobs

  • Cloud Environment Updates


Exchange Rates and Translation

  • Managing Exchange Rates

  • Loading Exchange Rates


Understanding Calculation

  • Calculation Types

  • Cross Dimensional Operators

  • Pre-Seeded Calculation


Member Fomulas

  • Creating Member Formulas

  • Dynamically Calculated Members

  • Two-Pass Calculation


Introducing Business Rules

  • Block-Storage Concepts

  • Structure of Business Rules

  • Calculating a Member or Subset

  • Relationship Functions

  • Controlling Scope

  • Pre-Built Calculations and Translatioons

  • Using FIX in FCCS Calculations

  • Business Rule Efficiency


EPM Automate

  • Installation and Connection

  • Maintain Security

  • Create and Download Snapshots


Introducing the REST APIs

  • REST URLs and Methods

  • Install a REST Client

  • GET and POST requests

  • Retrieving details and executing jobs


This course is offered through our strategic partnership with Keyteach, using state-of-the-art technology and a live Cloud environment for hands-on labs. Contact us to schedule a private class, or view the public class schedule.​

Color logo - no background.png