123EPM

Address: 2425 N Center St, Suite 240, Hickory, NC 28601

Tel. 828-278-8588

linkedin button.png

FCC: Administrator (5 days)

Audience

System administrators and implementation consultants.

Learning Objectives

Also available as

ON DEMAND

self-paced training via our Keyteach partnership.

Click here for details.

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

 

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

  • 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

Register

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