Oracle Financial Consolidation and Close Cloud (FCCS): Calculations Training Course


3 days (21 CPE credits)


Implementation consultants, developers, system administrators 

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

How Can I Take this Course? 

You can search for scheduled course dates for your time zone or start training immediately with our self-paced 'On Demand' subscription or request a private class for your team:

You can learn on demand with Keyteach self-paced courses. Discover products from Oracle, OneStream, Tagetik and other vendors.
Keyteach can provide a private class for your team. Learn about OneStream, Oracle and Tagetik.
Download a detailed course agenda from Keyteach. Discover how to use products from vendors such as OneStream and Oracle.

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.

Scheduled Course Dates

Oracle Consolidation and Close Cloud (FCCS): Calculations - 3 days - LIVE ONLINE (Europe)

12 Apr 2023 - 14 Apr 2023 (09:30 am - 05:30 pm)
Location: LIVE ONLINE (Instructor-Led) European (Time UK)
Price: £ 2550.00

Oracle Financial Consolidation and Close Cloud (FCCS): Calculations - 3 days - LIVE ONLINE (USA)

12 Apr 2023 - 14 Apr 2023 (09:30 am - 05:30 pm)
Location: LIVE ONLINE (Instructor-Led) USA (Time Eastern)
Price: $ 2880.00

private horizontal

NASBA CPERegistry logo blue transparent

Course title: Oracle Financial Consolidation and Close Cloud (FCCS): Calculations

Duration: 3 days

Audience: System administrators, developers and implementation consultants

Pre-requisites: None

Delivery method: Group Live and Group Internet-Based

Advanced preparation: None

Recommended CPE credits: 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:

Civic Cookie Control

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