Oracle Financial Consolidation and Close Cloud (FCCS): Calculations
On Demand Training Course (90 days)

90 days

Hands-On Lab Environment
21 days

More About this Training Course

Download the Detailed Course Agenda

download detailed agenda2 270x200


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

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

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.

What is On Demand Learning?

Target audience

Implementation consultants and system administrators.

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.

What's included?

Your subscription gives you 90 days of access to the course materials. We also provide between 14 and 28 days of access to a live hands-on lab environment (subject to the course purchased). Once the lab has been made available it cannot be suspended. 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 your allocated hands-on lab reservation. If you need additional time, it's possible to purchase a Hands-On Lab Extension for an additional 14 or 28 days. 

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 unlimited personalised support, we cannot provide one-to-one tuition across the entire course. We will respond to any request for assistance as soon as possible and within one working day (24 hours).

Hands-On Lab Terms and Conditions

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.

Connect with us

3 Station View
Rhino Court Business Park, Hazel Grove
Stockport, Cheshire, United Kingdom, SK7 5ER

  • USA +1 855 563 6723

  • UK +44 161 408 7722


Enter your email and we'll send you more information

© Copyright Keyteach Ltd 2023


UK +44 161 408 7722
USA +1 855 563 6723