How to Use Apache Groovy in Oracle EPM Cloud
Apache Groovy is becoming a hot topic, ever since Oracle EPM Planning Cloud (formerly known as Oracle Enterprise Planning and Budgeting Cloud Service or EPBCS) integrated Groovy into Calculation Manager in June 2017. Groovy business rules offer the capability to design sophisticated rules to solve use cases that normal business rules cannot solve.
Groovy is an object-oriented programming language for the Java platform which uses a Java-like “curly-bracket” syntax. Most Java code is also syntactically valid, although semantics may be different. Groovy 1.0 was released on January 2, 2007. Groovy 2.5.7 is the latest stable version (as of May 2019).
You can download the Groovy console here (don’t forget to set up a Groovy home environment variable!):
Figure 1: Apache Groovy Homepage (Apache Groovy Website)
Groovy in the Oracle EPM Cloud
So, what does Groovy mean in Oracle EPM Cloud? Groovy was implemented in June 2017 in Oracle EPM Cloud, specifically Oracle Planning Cloud. Oracle Hyperion Planning also started supporting Groovy scripts in late 2017.
As mentioned earlier in this post, complex Groovy rules can be used to address certain business requirements that traditional calc script business rules cannot resolve. For example, you can use Groovy rules to prevent users from saving data on forms if the data value is above a predefined threshold. You can also use Groovy for business logic that can be isolated to the changes in a webform. Finally, you can use Groovy combined with Data Maps and Smart Push to provide a real-time consolidated report.
Groovy rules are created in Oracle EPM Calculation Manager, and are deployed, validated, and run in the solution. If your organization uses what was formerly called Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) or the Oracle Planning and Budgeting Cloud Service (PBCS) “+1” option, you will be able to see the Groovy rules option in Calculation Manager. There are currently no plans to make Groovy available for a standalone PBCS environment.
Step 1: Log into your EPBCS or PBCS+1 environment, and then select “Rules.”
Step 2: Create a new rule. Change the view to “Edit Script.”
Step 3: From the “Script Type” dropdown selection, select either “Calc Script” or “Groovy Script.”
We hope you enjoyed this topic! Please feel free to email us here if you are interested in learning more or if you need help.