Oracle Cloud EPM: Financial Consolidation and Close (FCC) Calculations (3 days)

Image

HOME | TRAINING COURSES

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 Cloud EPM: Financial Consolidation and Close (FCC) Calculations Private Class   $2,880.00 per person (min 2 attendees)
fcc-01_565219448
30PC_OFF
-30%$2,880.00$2,016.00 per person Oracle Cloud EPM: Financial Consolidation and Close (FCC) Calculations On Demand

INSTANT ACCESS

  • An immediate 'On Demand' subscription for you
  • Instant access - start training today!
  • 90 day course subscription
  • Hands-on lab access for 21 days
  • Unlimited instructor support
  • Train anywhere, anytime at your convenience
ppv_voucher-01_2060125498
30PC_OFF
-30%$2,880.00$2,016.00 per person Oracle Cloud EPM: Financial Consolidation and Close (FCC) Calculations: Pre-Paid Vouchers

PRE-PAID VOUCHERS

  • 'On Demand' vouchers for you or your team to redeem later
  • Voucher codes valid for 12 months
  • 90 day course subscription
  • Hands-on lab access for 21 days
  • Unlimited instructor support
  • Train anywhere, anytime at your convenience

Course Summary

Learn about the business rules and scripting language used to perform calculation and consolidation and gain an in-depth understanding of the options, features and calculation capabilities. Discover how to create highly sophisticated and custom rules to support complex calculation requirements in Oracle's Financial Consolidation and Close Cloud (FCCS).

Audience

  • System Administrators
  • Implementation Consultants

Duration

  • Instructor-led training: 3 days (21 CPE Credits)
  • Self-paced on demand training: 90 days (21 CPE Credits)

Course Description

Understand how calculation takes place within Oracle's Financial Consolidation and Close Cloud (FCCS). Explore the multi-dimensional business rules and calculations scripts and understand the capabilities, features and syntax of how to perform calculation, translation and consolidation.

This three-day course covers everything required to design, build and deploy effective calculations. Learn about member formulas and when they should be used. Find out about the out-of-the-box calculation capabilities and understand how ‘seeded’ calculations can be modified to amend the standard consolidation process. Discover how calculation manager is used to manage calculations both within the graphical designer and script editor. Learn how to control calculation scope and how to build custom validation rules vs the automated validation on the balance sheet.

Explore the available calculation functions, the associated syntax and understand how to use templates to create reusable code snippets for efficient design of calculation rules. Find out about statutory consolidation rules and strings and how to deploy, duplicate and modify rule sets.

This course also investigates the development of efficient ad hoc ‘On Demand’ rules that add additional flexibility and run outside of the consolidation process.

Learning Objectives

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

  • Recognize the methods by which business rules can be assembled graphically
  • Critique the methods by which translation types can be used and how they can be overridden
  • Identify the methods for controlling the scope of calculation
  • Contrast the use of On Demand business rules with the standard consolidation rules
  • Examine the use of Design Time Prompts to customise the members for which a calculation is run
  • Apply Configurable Consolidation rules to recalculate data at the Elimination level

Summary by Day

Day 1

  • Understanding Calculation
  • Member Formulas
  • Pre-Built Calculations
  • Calculation Administration

Day 2

  • Graphical Rule Editing
  • Controlling Calculation Scope
  • Additional Capabilities
  • Calculation Functions and Syntax

Day 3

  • Calculation Templates
  • Manage Ownerships
  • Statutory Consolidation Rules
  • On-Demand Rules

Course Agenda

Understanding Calculation

  • Consolidation
  • Translation
  • Calculation Methods
  • Ownerships
  • Calculation Status
  • Dynamic Calculation
  • FCCS System Rules
  • Business Rule Security

Member Formulas

  • Member Formula Syntax
  • Dynamic Calculation
  • Two-Pass Calculation

Pre-Built Calculations

  • Consolidate and Force Consolidate
  • Translate and Force Translate
  • Translation and Overrides
  • Consolidation and Translation
  • DataLoad_PreProcess_Consol
  • DataLoad_PostProcess_Consol
  • DataLoad_PostProcess_Rates
  • MetadataLoad_PostProcess_Consol
  • FCCSFormStatusProcessor
  • RefreshDatabase_PostProcess_Consol
  • RefreshDatabase_DelegatePostProcess
  • ComputeRates
  • RefreshDatabase_PostProcess_Rates
  • ClearEmptyBlock

Calculation Administration

  • Calculation Manager Views
  • Filtering Rules
  • Importing and Exporting Rules
  • Validation and Analysis
  • Database Properties
  • Opening, Editing, Copying, Saving
  • Searching, Printing, Deleting
  • Deployment

Graphical Rule Editing

  • Introducing the Designer View
  • Graphical Rule Components
  • The Assembly of Graphical Rules
  • Design Principles Within the Graphical Interface
  • Transformation to Script

Controlling Calculation Scope

  • Block Storage/Creation
  • Dense and Sparse
  • FIX and IF
  • Variables
  • Run Time Prompts
  • Design Time Prompts

Additional Capabilities

  • Cross-Dimensional Operators
  • Two-Pass Calculation / Back Calcs
  • Enabling Automated Balance Sheet Validation
  • Calculation Triggers and Copy Data
  • User Defined Attributes
  • Defining Script Snippets

Calculation Functions and Syntax

  • Common Syntax
  • Allocation Functions
  • BLOCK Functions
  • Boolean Functions
  • CALC Functions
  • CLEAR Functions
  • Conditional and Logical Operators Functions
  • COPY Functions
  • Date & Time Functions
  • EXPORT Functions
  • Forecasting Functions
  • Mathematical Functions
  • Member Set Functions
  • Misc Functions
  • Range and Financial Functions
  • Relationship Functions
  • SET Functions
  • Statistical Functions

Calculation Templates

  • Creating Reusable Code with Calculation Templates
  • System Templates
  • Custom Templates
  • Using Variables within Calculation Templates
  • Calling Templates from Rules

Managing Ownership

  • Changing Ownership Settings
  • Import and Export Ownership Data
  • Manage Consolidation Methods
  • Ownership Settings Year to Year
  • Ownership Settings in Forms and Configurable Consolidation Rules
  • Review Consolidation Contributions

Statutory Consolidation Rules

  • Managing Rule Sets and Rules
  • Consolidation Strings
  • Rule Sets, Rules, and Execution
  • Deploying and Undeploying Rule Sets
  • Duplicating and Modifying Rule Sets
  • Configurable Consolidations

On Demand Rules

  • Understanding On Demand Rules
  • Creating and Deploying On Demand Rules
  • Running On Demand Rules
  • Creating On Demand Rules
  • Rule Prompts
  • Creating Consolidation Rules

National Association of State Boards of Accountancy (NASBA)

Image
  • Course title: Oracle Cloud EPM: Financial Consolidation and Close (FCC) Calculations
  • Duration: 3 days
  • Audience: System Administrators | Developers | Implementation Consultants
  • Pre-requisites: None
  • Delivery method: Group Live, Group Internet-Based and QAS Self-Study
  • Advanced preparation: None
  • Group Live and Group Internet-Based: 21 credits - computer software and applications
    QAS Self-Study: 21 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.

KEYTEACH