FCC: Calculations (3 days)

Audience

System administrators and implementation consultants.

Learning Objectives

Learn about the business rules and scripting language used to perform calculation and consolidation within Oracle’s FCC. Gain an in-depth understanding of the options, features and capabilities within FCC. Discover how to create highly sophisticated and custom rules to support complex calculation requirements within this powerful cloud-based financial consolidation solution.

Course Description

Understand how calculation takes place within FCC. Explore the multi-dimensional business rules and calculations scripts and understand the capabilities, features and syntax of how to perform calculation, translation and consolidation within FCC.

​

This three-day course covers everything required to design, build and deploy effective calculations within FCC applications. Learn about member formulas and when they should be used. Find out about the FCC 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.

Course Information

Audience: Implementation consultants, developers, system administrators.

Duration: 3 days

Pre-requisites: None

Delivery method: 

• On Demand self-paced training via our Keyteach partnership (click here for details)

• Classroom: Public - Live Online (check current schedule)

• Classroom: Private - In Person or Live Online (contact us to schedule)

Advanced preparation: None

Recommended CPE credits: 21 credits

Day Summary

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.

​

Detailed 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

Calculaton 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

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