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.
You can use Groovy rules in Financial Consolidation and Close On-Demand rules. You create Groovy rules in Calculation Manager.
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 Cloud for 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.
-
Pure Groovy rules that can, for example, perform data validations and cancel the operation if the data entered violates company policies.
Watch this tutorial video to learn how to improve calculation performance on business process forms by creating context-specific, dynamic business rules using the Groovy scripting language.
