Oracle Financial Consolidation and Close Cloud (FCCS): Calculations
On Demand Training Course (90 days)
Subscription
90 days
Hands-On Lab Environment
21 days
More About this Training Course
Download the Detailed Course Agenda
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).
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.
What is On Demand Learning?
Target audience
Implementation consultants and system administrators.
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.
What's included?
Your subscription gives you 90 days of access to the course materials. We also provide between 14 and 28 days of access to a live hands-on lab environment (subject to the course purchased). Once the lab has been made available it cannot be suspended. 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 your allocated hands-on lab reservation. If you need additional time, it's possible to purchase a Hands-On Lab Extension for an additional 14 or 28 days.
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 unlimited personalised support, we cannot provide one-to-one tuition across the entire course. We will respond to any request for assistance as soon as possible and within one working day (24 hours).
Hands-On Lab Terms and Conditions
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.
