Groovy
Discussion List
-
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…
-
Groovy Script Validator is no longer working in Oracle Planning after the October Update.Summary: Groovy Script Validation Report is No Longer Working after the October Update 25.10.76 Content (please ensure you mask any confidential information): Our groovy…
-
How to identify change in industry field using triggers?Summary: When we update the Industry field on accounts changed CX, how can we able to identify the changed value from scripts? Content (please ensure you mask any confid…
-
Groovy script with POST rest command creates a unexcepted filename in targetSummary: I am running a groovy script which basically copies a file ( Outbox folder ) from environment-1 to Inbox folder of the target environment-2, ait then runs the i…