FCCS: Administrator (5 days)

Financial Consolidation and Close (FCCS): Administrator (5 days)

Audience

System administrators and implementation consultants

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).

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 Automate.

Day summary

  1. Overview, Navigation, Close Process, Application Creation and Configuration, Dimensionality and Member Properties
  2. Managing Metadata, Customising the Interface, Data Management (FDMEE), Designing Data Forms and Data Entry Techniques 
  3. Intercompany and Journals, Security and Managing Users, Approval Process, Smart View and Financial Reporting 
  4. Closing with Task Manager, Supplemental Data, Application Maintenance and Exchange Rates and Translation
  5. Understanding Calculation, Member Formulas, Introducing Business Rules, EPM Automate and Introducing the REST APIs

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 Metadata

  • 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 Metadata
  • Matching Intercompany
  • Creating Journals

Security and Managing Users

  • The FCCS Security Model
  • Creating Users
  • Assigning Roles
  • Managing Groups
  • Valid Intersections

Approvals

  • 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
  • Seeded Calculation

Member Formulas

  • 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

Detailed course agenda / Justification for your manager 

FCA HIGH Page 1 

CPE Sponsors

Course title: FCCS: Administrator

Duration: 4 days

Audience: Implementation consultants, developers and system administrators

Pre-requisites: None

Delivery method: Classroom (group - live)

Advanced preparation: None

Recommended CPE credits: 28 credits - specialised knowledge and applications

Programme level: Intermediate

Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org 
Oracle Financial Consolidation and Close (Oracle FCCS): Administrator (5 days)
Oracle FCCS Training Courses