Financial Consolidation and Close (FCCS): Administrator On Demand (90 day) Subscription

 Buy Now  Prepaid Registration  View Demo


System administrators and implementation consultants

On Demand Subscription

Access to course materials: 90 days for ONE student

Default access to hands-on lab environment: 28 days (lab extensions are available to purchase if required) 

Learning objectives

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

© Keyteach Limited 2018

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 FCCS applications using Data Management (FDMEE).

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 Autom

Major Topics

Introduction to FCCS

  • Key Components
  • EPM Cloud Consolidation Landscape
  • The Close Process
  • Navigating the FCCS Interface
  • Point of View and Selecting Members

Application Creation and Configuration

  • Application Configuration Options
  • Creating a new FCCS Application
  • Applications from Migration Snapshots
  • Enabling New Features

Introducing FCCS Dimensions

  • Dimensionality and Data Storage
  • Extensible Dimensions
  • FCCS 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
  • Metatdata 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

  • Understadning 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
  • 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 Translations
  • 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

Hands-On Labs

Your subscription gives you 90 days of access to the course materials. We also provide 14 days of access to a live hands-on lab environment. Once the lab has been made available it cannot be suspended and will be available for a minimum of 14 consecutive days. You can request a start date for access to your hands-on lab. You will use the same environment for all workshops in this course and these should be completed within 14 days. It is possible to purchase a Hands-On Lab Extension for an additional 14 or 28 days. Keyteach will monitor the use of the hands-on lab and we reserve the right to cancel access to the course (without notice) if we believe it is in use by more than one named user.

Help from an Instructor

This is a self-paced course and you should be able to watch the videos and navigate through the course on your own. If you experience any difficulties or would like an opportunity to ask questions of our instructors, we will be happy to help. Please note that whilst we provide personalised support, we cannot provide one-to-one tuition across the entire course.  We will respond to any request for assistance within one working day (24 hours). 

Detailed course agenda / Justification for your manager 


Build solid expertise in your own time at your convenience

Administrator On Demand training is our most robust and flexible self-paced training option gives you the benefits of an instructor-led experience with instant access to course materials that you can download and keep. The learning experience is highly interactive with hands-on lab access to the real software. We're available to provide personalised support to help you build solid expertise in your own time at your convenience. The content is video-based, with plenty of additional reading, whiteboard presentations and structured workshops to provide comprehensive and flexible learning. 

Named Users

Your subscription is for an named individual and students should not share access to the course or distribute the course materials under any circumstances. Keyteach will monitor the use of the course and the associated hands-on lab and we reserve the right to cancel access to the course (without notice) if we believe it is in use by more than one named user.