About Groovy Business Rules

Groovy business rules allow you to design sophisticated rules that solve use cases that normal business rules can't solve; for example, rules to prevent users from saving data on forms if the data value is above a predefined threshold.


Groovy is an advanced customizable rules framework that comes with EPM Cloud Platform and is available with EPM Enterprise Cloud along with Enterprise PBCS and PBCS Plus One. You can create and edit Groovy rules in:

  • Planning (including these application types: Custom, Module, FreeForm, Sales Planning, and Strategic Workforce Planning)

  • Enterprise Profitability and Cost Management

  • Financial Consolidation and Close

  • FreeForm

  • Tax Reporting

You create Groovy rules in Calculation Manager and execute them from any place that you can execute a calc script rule in an application; for example, on the Rules page, within the context of a form, in the job scheduler, in dashboards, in task lists, and so on.

Groovy rules are also supported in rulesets. You can have a combination of calc script rules and Groovy rules within a ruleset.

Groovy rules are not supported in composite forms.

You can execute jobs of type rules, rulesets, and templates synchronously from a Groovy rule.

You can write Groovy scripts to run select EPM Automate commands directly in Oracle Enterprise Performance Management Cloud, without installing EPM Automate client on a client machine. Refer to Running Commands without Installing EPM Automate and Supported Command in Working with EPM Automate for Oracle Enterprise Performance Management Cloudfor information on which EPM Automate commands can be run via Groovy and example scripts.

Oracle supports two types of Groovy rules:

  • Rules that can dynamically generate calc scripts at runtime based on context other than the runtime prompts and return the calc script which is then executed against Oracle Essbase.

    For example, you could create a rule to calculate expenses for projects only for the duration (start and end dates) of the project.

    Another example is a trend-based calculation that restricts the calculation to the accounts available on the form. You could use this calculation for various forms in Revenue, Expense, Balance Sheet, and Cash Flow. This allows for optimization and reuse.

  • Pure Groovy rules that can, for example, perform data validations and cancel the operation if the data entered violates company policies.


Your Goal Watch This Video

Learn about training options for creating Groovy rules in Oracle Enterprise Performance Management Cloud.

Video icon Learning Groovy in Oracle EPM Cloud