Oracle Cloud EPM: Financial Consolidation and Close (FCC) Administrator (5 days)

Image

How Can I Take this Course?

Keyteach provides flexible training options to suit your needs. Choose from globally scheduled instructor-led courses, private team classes, or our self-paced 'On Demand' training. The 'On Demand' option features a live hands-on lab for in-depth workshops and unlimited instructor support.

Would you like to arrange a private class for your team?

Keyteach provides the flexibility to deliver this instructor-led course on dates that suit your team’s schedule. Private classes, conducted live online with a remote instructor, require a minimum of two participants. Alternatively, we can arrange in-person training at your location upon request.

  • Oracle Financial Consolidation and Close (FCC): Administrator Private Class   $4,800.00 per person (min 2 attendees)
fca-01_285787691
30PC_OFF
-30%$4,800.00$3,360.00 per person Oracle Cloud EPM: Financial Consolidation and Close (FCC): Administrator: On Demand
ppv_voucher-01_2116661483
30PC_OFF
-30%$4,800.00$3,360.00 per person Oracle Cloud EPM: Financial Consolidation and Close (FCC): Administrator: (Pre-Paid Vouchers)

Course Summary

By the end of this course you will be able to create and manage applications with Oracle’s Financial Consolidation and Close Cloud (FCCS). 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 applications using Data Integration.

Audience

  • System Administrators
  • Implementation Consultants

Duration

  • Instructor-led training: 5 days (35 CPE Credits)
  • Self-paced on demand training: 90 days (32 CPE Credits)

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 applications using Data Integration.

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.

Learning Objectives

By the end of this course learners will be able to:

  • Identify the various aspects of metadata configuration and how they relate to data consolidation
  • Explore the use of Data Management in relation to the import and export of data
  • Recognize how to configure and make use of the Intercompany features
  • Critique the ways in which user tasks can be compiled into time-based schedules
  • Implement Supplemental Data strategies to allow the gathering and inclusion of external data into schedules
  • Differentiate between the various calculation methods

Course Agenda

Introduction

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

Application Creation and Configuration

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

Introducing Dimensions

  • Dimensionality and Data Storage
  • Extensible Dimensions
  • 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 the web interface
  • Metadata Administration in Smart View

Interface and Navigation Flows

  • Creating Custom Navigation Flows
  • Dashboards and Infolets

Data Integration

  • Concepts
  • Import, Validate, and Export
  • Data Integration Setup
  • Pipeline Creation

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 Consolidation Journals
  • Managing Journal Periods
  • Creating Enterprise Journal Templates
  • Deploying Templates and Using Enterprise Journals

Security and Managing Users

  • The 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

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 Calculations

  • Calculation Types
  • Cross Dimensional Operators
  • Pre-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 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

National Association of State Boards of Accountancy (NASBA)

Image
  • Course title: Oracle Cloud EPM: Financial Consolidation and Close (FCC): Administrator
  • Duration: 5 days
  • Audience: System Administrators | Developers | Implementation Consultants
  • Pre-requisites: None
  • Delivery method: Group Live, Group Internet-Based and QAS Self-Study
  • Advanced preparation: None
  • Recommended CPE credits:
    Group Live and Group Internet-Based: 35 credits - computer software and applications
    QAS Self-Study: 32 credits - computer software 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 Cloud Service (FCCS) is a cloud-based configurable solution to ensure that financial consolidation processes are compliant, auditable, timely and transparent. As cloud consolidation becomes a reality, Keyteach has the training courses that you'll need to get ahead of the curve and master the major concepts including the underlying calculation script language.

Associated products, such as FDMEE Data Management and Financial Reporting Web Studio, mean that training is essential to unlock the potential of FCCS and support its successful development and deployment.

Keyteach has a variety of ‘On Demand’ training courses for Oracle FCCS that can be undertaken at home. These training courses are designed for system administrators and include a live hands-on lab environment to undertake in-depth workshops. You can start the training straight away and there is unlimited instructor support. These courses are self-paced and can be purchased as a 90 day subscription:

Find out more about our range of self-paced 'On Demand' training courses for system administrators and implementation consultants to learn at home by clicking here.

Keyteach has many different types of training solution for Oracle's Financial Consolidation and Close Cloud Service. We have a regular global schedule of system administrator training with a five-day administrator course and a three-day calculations course, as well as online training in On Demand format that enables you to start training today, If your organisation is implementing FCCS, you should consider our two-day enablement training for project teams. This FCCS training course is best scheduled directly before design sessions with your implementation consultants, enabling project teams to make a more valuable contribution to the design and implementation of FCCS applications.