Groovy
Discussion List
-
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 61 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 11 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…
-
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…
-
CX Opportunities - edit status and win/loss reasonsBusiness is requesting changes to the current Statuses (such as Win, Loss, No Sale, etc) and corresponding Win/ Loss probability reasons, and requesting to deactivate a …
-
What is the order of execution for server scripts between parent/child objects?Summary: If I have groovy scripts in a parent object and in its child objects, which scripts run first? Parent scripts or child scripts? Version (include the version you… -
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…
-
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…
-
Profitability and Cost Management (EPCM) Model Calculations for multiple Periods with GroovySummary: I have a pipeline in EPM Planning that push data into EPCM for all periods of Forecast scenario/Run Model Calculations for all periods to allocate Overheads/ Pu…
-
New Groovy Engine Update DateSummary: New Groovy Engine update date Content (please ensure you mask any confidential information): We would like to confirm the Groovy Engine update date. In Sep Mont…