Groovy is a Java syntax compatible object-oriented programming language and has similar features like Python and Ruby along with being a dynamic and static language. In recent years, Oracle has incorporated the use of Groovy when running business rules in Enterprise Performance Management(EPM) Cloud systems; it provides a way to interact with Data Forms in ePBCS.
For those of you that are familiar with writing calculation scripts and business rules in the Planning and Budgeting Cloud Services (PBCS or ePBCS) , you know that when running operations utilizing business rules for data forms or complex aggregations, the system tends to slow down based on the size of data the business rules are processing. Oracle has introduced a new way to optimize and dynamically calculate the data. Oracle has changed the data forms based on POV, the text value of a smart list, and calculation only for the associated members. The EPM object model in Groovy gives you tools to design interactive Run Time Prompts (RTPs) for users to work with metadata, such as adding new members, renaming existing members, moving members under new parents, updating other metadata properties and so on. The second feature is the utilization of Groovy rules to perform validations of the data entered. For example, when performing data validations Groovy will analyze the data with the rules set in place and cancel anything that violates those rules.
These are some limitations with the standard Oracle Calculation Scripts in Planning:
However, limited context-specific calculations are available in forms by right-clicking and calculating only a specific row. This option is less useful for large forms or when you update cells in multiple rows. This is where Groovy Script Business Rules have an advantage over the standard Calculation Scripts:
This is just the tip of the iceberg on Groovy for business rules and from what we know and there is a lot more to explore and learn.
Author: Sunil Keezhangattu - Enterprise Architect
Call Us! Schedule your Free Enterprise Performance Managment Demo, to see it in action!
We offer Autonomous Systems for EPM Cloud Applications such as Oracle Planning & Budgeting Cloud Service (PBCS)/EPBCS, Financial Close & Consolidations Cloud Service (FCCS), Hyperion Financial Management (HFM), Account Reconciliation Cloud Service (ARCS), Profitability & Cost Management (PCM) and more.