Groovy
Discussion List
-
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… -
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…
-
Can Groovy help to generate ad hoc file ?Hello everyone, I have one question about Groovy's ability. My business users use ad-hoc to input the essential data. Then, they return to the form and run the Groovy ru… -
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 (…
-
Pipeline Stage Failed If File Is MissingHi Team, We have a pipeline within the FCCS instance that consists of two stages. The first stage loads data into FCCS, and the second stage loads data into PBCS through…Jacob Gomes 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 open/close a period in "Manage Periods" from a Groovy script in FCCS?Hi everyone, I’m working with Oracle FCCS and need to automate the process of opening and closing periods (as done manually in Manage Periods) using Groovy scripts. Does…Loren LM 64 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Not able to create multiple column on the fly grid using GroovyWe are trying to create a groovy rule that can delete the whole rows where there is no data on OWP_Status and OWP_Start Date column, for that we are creating a on the fl…Murari-Oracle 13 views 1 comment 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
Display the File Name in Drag and Drop in File PickerSummary: How to Display the Selected File Name in Drag and Drop in File Picker Content (required): Version (include the version you are using, if applicable): Code Snipp… -
how to apply validationSummary: When we create contact for customer or Prospect Phone no field can accept anything including numbers ,characters ,Special characters. required format would be t…
-
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…