Groovy
Discussion List
-
Forms 2.0 & Groovy throwVetoException not showing error messageHi - We are doing some validation of user entry before we run calculations on a form. We have been using Forms 2.0. When the validation fails and throwVetoException is c… -
Data map is clearing data for different cost center in ASO even when CC is passed as parameterSummary: Hello Geniuses, I am facing an issue while running the datamaps using restapi connection. I am modifying the map definition in the job using rest api for cost c… -
Groovy - Tidy up Job Console ExportSummary: This code is to automate the job console export and format it in a more readable format Code Snippet : // #### RULE HEADER - START // // Author: Jeremie Richard…
-
Can Groovy help to prevent user promoting based on approval flow?Hello everyone, I have one question about Groovy's ability. I now have an approval flow for both Entity and Project. And I also have a form to show the validation by usi… -
groovy failing with datagriddefinationbuilderHi Team one of our Groovy BR (due to huge volumes) is failing execution with below error. Any suggestions / alternative ways? A method called by the script failed on lin…
-
Upgrade to Essbase 21.7.x for 25.11 Connections failingThere was an error rendering this rich post.
-
How to write csv file with groovy rule without adding Byte Order Mark (BOM)I am trying to create a csv file with groovy rule. All went well, except this created file contains byte-order mark (BOM), which is not needed. Automation is sending thi…
-
Push Data Failed: Error - The member does not exist for the specified cube or you do not have accessDescription: Hello, I am encountering the following error when trying to push data from an ASO cube (source) to a BSO cube (target) in Oracle PBCS: Error: "Push Data fai…
-
Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using GroovySummary: Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using Groovy Content (please ensure you mask any confidential information): I want to Cop…
-
How to return text values from a Business Rule (without using Smart Lists)?Hi everyone, I’m trying to write a Groovy Business Rule in Planning (EPBCS) that returns or assigns a text value to a member. The requirement is to store a text string (…
-
Groovy - Issue passing variable between templates within the same jobHello I have Issue passing variable between templates within the same job. In GroovyValidationReport I got error: The Groovy script failed to compile with internal error…
-
Data duplicating after Groovy runs rule set when ad hoc runs are overlappedOur implementation partner was able to configure a set of Groovy scripts to kick off the various calculations in order, which can be both scheduled and/or run ad hoc by …
-
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
How to print attachment file in cell commentHello everyone, I have attached the Excel file to a cell : My question here is: How can I print all the attachments in all the cells at one time? Is there any feature or…
-
RTP in Groovy rule only shows 1 promptHello everyone, I based on Oracle document here to validate the rule: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/groov/groovy-example…
-
401 Authorization Required when using /interop/rest/v2/mails/sendUsing groovy to send email in business rule: HttpResponse jsonResponse = operation.application.getConnection("SendMail").post('/interop/rest/v2/mails/send').header("Cont…
-
epmautomate SendMail is blocking emails from being sent to specific usersSummary: I encountered strange behavior where it appears (based on the epmautomate log) that SendMail is being blocked from sending emails to a specific user. The kicker… -
Using getSharedMembers for cube specific shares?Summary: I am trying to find cube specific shared members using getSharedMembers since the documentation shows this should be possible, but I'm getting shared members fr…
-
what is the syntax to update alias with groovy scriptSummary: Is there a syntax to update alias using a groovy script? We would like to update the alias of a period member based on the start period of the actual scenario. …
-
Threading / Multi-Processing Equivalent in GroovySummary: Is there a way to accomplish threading / multi-processing in Groovy within EPBCS? We have a number of jobs where scripts are running on a large set of Project d… -
Groovy Validator Missing in Production for Prebuilt ScriptHi All, We’re using a prebuilt Groovy rule in our Dev, UAT, and Production environments in Oracle EPM Cloud. In Dev and UAT, we can see the Groovy Validator Option under…
-
Groovy Validator Missing in Production for Prebuilt ScriptHi All, We’re using a prebuilt Groovy rule in our Dev, UAT, and Production environments in Oracle EPM Cloud. In Dev and UAT, we can see the Groovy Validator Option under…
-
Update Cell-Level Security in GroovyHere is some sample code to create CLS in Groovy // #### RULE HEADER - START // // Author: Jeremie Richard // Date: Sep 2025 // Purpose: Generate Cell Level Security (CL…
-
Can Groovy script produce Business Rule logs?Summary: When we run a Business Rule in could EPM, the job console does not show the log as it would when run on prem. Is it possible to generate essbase-like calculatio…
-
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
Sort values in form using Groovy, possible?Hello! Does anyone have experience with sorting values in a Form? For example displaying "top 10 values" or "least profitable services" or similar? My search so far have… -
New Groovy Engine EnquiryWe came across the following Oracle notification: "A future version of the Groovy engine, which is planned for the second half of 2025, has stricter validation rules tha…
-
PBCSSummary: Groovy Engine update and its questions Content (please ensure you mask any confidential information): 1. Could you please confirm the correct Groovy Engine upda…
-
Resolving Groovy Business Rule Validation IssuesHello experts, I have a problem validating groovy rules using new tool that is able to check if rule is good or not: Groovy Script Validator I have a rule using this cod… -
How to clear PCM multiple Periods for Forecast scenario with Groovy scriptSummary: I just want to clear all the data in PCM for Forecast dimension by using groovys script for all periods before laoding it from EPM. I have tried groovy with mdw…