Groovy Scripting for Oracle Enterprise Planning Cloud (EPBCS) Training Course


3 days (21 CPE credits)


Implementation consultants, developers, system administrators 

Course Summary

By the end of this course you will be able to enhance the potential of Oracle's Enterprise Planning Cloud (EPBCS) applications through the use of intelligent and dynamic Groovy Rules. This can be achieved by making use of a Groovy Rule’s ability to generate code dynamically at runtime, enabling more targeted and faster executing calculations.

How Can I Take this Course? 

You can search for scheduled course dates for your time zone or request a private class for your team:


Learning Objectives

By the end of this course learners will be able to:

  • Recognize the fundamental concepts relating to the Groovy scripting language
  • Identify the ways in which Groovy rules can be created, maintained and utilized in the application
  • Explain how pure Groovy rules can be used to interact with interface elements, such as data grids and run-time prompts
  • Describe how Groovy rules can be used to generate Essbase calculation scripts dynamically, allowing for more flexibility in standard calculations
  • Ascertain how to look up information and troubleshoot by exploring the Java API reference for Groovy Rules
  • Recall how connections can be made to external resources, including the application’s REST APIs, facilitating broader processes in Groovy rules

Course Description

Groovy is an object-oriented programming language for the Java platform that can be used with Oracle's Enterprise Planning Cloud subscriptions. Groovy Rules are created in Calculation Manager and are deployed, validated, and run within planning and budgeting applications, like standard business rules, however they provide a wealth of potential improvements over traditional rules. This three-day course focuses on the design of sophisticated Groovy Rules to address scenarios that normal business rules can't solve.

Groovy Rules focus calculations more specifically than traditional business rules, meaning that it is possible to calculate only what is absolutely required. This in turn leads to faster calculation and aggregation times and quicker availability of data in ASO reporting cubes. Groovy Rules can also interact with the data in a webform, providing a host of dynamic improvements to the user interface. This can be used to provide real-time feedback to users, allowing for sophisticated and highly visible data validation.

In this course, we’ll explore the fundamentals of Groovy scripting for the Oracle Cloud, from an introduction to syntax and setting up a development environment through to writing complex scripts that enhance and improve an application. We’ll investigate the Groovy Rules Java APIs and explore working with data and metadata to perform validations. We’ll also find out how to dynamically generate focused calc scripts at runtime, based on execution context. Additionally, attendees will be given the opportunity to explore how Groovy can be used to interact with the available REST APIs.

Scheduled Course Dates

There are currently no scheduled courses. Please use the link below to request a private closed class for your team.

private horizontal

NASBA CPERegistry logo blue transparent

Course title: Groovy Scripting for Oracle Enterprise Planning Cloud (EPBCS) - 3 days

Duration: 3 days

Audience: System administrators, developers and implementation consultants

Pre-requisites: Knowledge of Oracle Planning Cloud system administration

Delivery method: Group Live and Group Internet-Based

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:

Connect with us

3 Station View
Rhino Court Business Park, Hazel Grove
Stockport, Cheshire, United Kingdom, SK7 5ER

  • USA +1 855 563 6723

  • UK +44 161 408 7722


Enter your email and we'll send you more information


UK +44 161 408 7722
USA +1 855 563 6723