Home | All Courses | Oracle Hyperion EPM | Financial Consolidation and Close (FCCS)

Duration

3 days (21 CPE credits)

Audience

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:

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

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