FCCS: Calculations (3 days)

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


System administrators and implementation consultants

Learning objectives

Learn about the business rules and scripting language used to perform calculation and consolidation within Oracle’s FCCS. Gain an in-depth understanding of the options, features and capabilities within FCCS. 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 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 within FCCS.

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

Day summary

  1. Understanding Calculation, Member Formulas, Pre-Built Calculations, Calculation Administration.
  2. Graphical Rule Editing, Controlling Calculation Scope, Additional Capabilities, Calculation Functions and Syntax.
  3. Calculation Templates, Manage Ownerships, Statutory Consolidation Rules, On Demand Rules.

Major Topics

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 

Manage Ownerships

  • 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

Detailed course agenda / Justification for your manager 

FCC Page 1 

CPE Sponsors

Course title: FCCS: Calculations

Duration: 3 days

Audience: Implementation consultants, developers and system administrators

Pre-requisites: None

Delivery method: Classroom (group - live)

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: www.learningmarket.org

Oracle Financial Consolidation and Close (FCCS): Calculations (3 days)
Oracle FCCS Training Courses