Running Groovy Rules in Forms

Data source types: Planning, Planning Modules, Financial Consolidation and Close, FreeForm, Tax Reporting

Forms with Groovy rules associated with them can be opened in Oracle Smart View for Office for further exploration. You can select any number of contiguous or non-contiguous cells on the form, right-click to access theSmart View context menu, and then select the Groovy rule to run on the selected cells.

Note:

• As a prerequisite, the form must have Groovy rules attached in order receive the information of cells selected in Smart View. To associate Groovy rules with a form, create the Groovy rule, and in the form definition, in the Business Rules tab, add a Groovy business rule to Selected Business Rules.

• This feature requires Oracle Enterprise Performance Management Cloud 22.10 or later.

When running Groovy business rules from the right-click context menu in a form, the selected cells are available in the Groovy rule using the isSelected() method on the grid cells. The information about the selected cells is included when the Groovy rule is invoked as part of the right-click menu. This enhancement also helps Groovy rule designers to access and use the information of selected cells in the Groovy logic.

Note:

• The ability to select cells and use their information for processing Groovy rules is available forms opened in Smart View.

• This ability is not available when Groovy business rules are launched and run from the Business Rules dialog opened from the Smart View ribbon.

• Any Groovy rule attached to the form can utilize information from the selected cells.

To run a Groovy rule in a Smart View form:

1. Open a form with an associated Groovy rule.
2. Select the cells on which to run the Groovy rule.
3. Right-click the cells and, in the context menu, select Smart View, and then select the Groovy rule to run.

   After the rule is processed successfully, note the updated values in the selected cells.