Financial Consolidation and Close (FCCS): Calculations On Demand (90 day) Subscription

 Buy Now  Prepaid Registration  View Demo


System administrators and implementation consultants

On Demand Subscription

Access to course materials: 90 days for ONE student

Default access to hands-on lab environment: 21 days (lab extensions are available to purchase if required) 

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.

© Keyteach Limited 2019

Course description

Understand how calculation takes place within FCCS. Explore the multidimensional 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.

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

Hands-On Labs

Your subscription gives you 90 days of access to the course materials. We also provide 21 days of access to a live hands-on lab environment. Once the lab has been made available it cannot be suspended and will be available for a minimum of 21 consecutive days. 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 21 days. It is possible to purchase a Hands-On Lab Extension for an additional 14 or 28 days. Keyteach will monitor the use of the 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.

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

Detailed course agenda / Justification for your manager 

FCC Page 1

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. 

Named Users

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.