Groovy
Discussion List
-
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… -
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… -
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… -
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…
-
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…
-
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 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… -
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… -
How to rename the file in EPBCS to display timestampHello everyone, I am finding the way to rename the file in the inbox/outbox explorer. I had created a data pipeline to export data from the EPBCS system to a file with t… -
Cannot run pipeline through GroovyHello everyone, I am trying to run the pipeline using Groovy. I could run integration with Groovy, but the pipeline couldn't. It showed the error: The pipeline name is i…
-
Error Connection in Validator Engine GroovyHello, while validating with the Groovy engine validator, we encountered the following error: The connection is made in this way: How can we solve it?
-
Mails are not coming while launching pipeline using REST API through business ruleSummary: We have a business rule which uses REST API to call a pipeline. After the pipeline is completed , mails are not coming up. This happened very recently since 1st…
-
Groovy Strict Validator: Auto- update or manual fix needed?Summary: Hi All, While running Groovy Validator in Planning, I received an error. The rule we are using based on one oracle provided groovy rules. My Question is: Once G…Prasanthi mummareddy_123 30 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle Planning
-
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…
-
Pipeline invoked through Business rule REST API not sending emails on completionSummary: we have a business rule which is invoking pipeline through REST API call. The rule works as expected and the pipeline is invoked. Everything works as expected h…
-
Run Auto Predict Job through Groovy REST API callHey all, I feel like I'm missing something obvious here. I'm attempting to write a Groovy rule that executes a REST API call to allow a lower permissions user to execute… -
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…
-
Error when using Groovy's DataGridDefinitionBuilderSummary Error when using Groovy's DataGridDefinitionBuilderContent Hi, One for the nerds - I am using the Groovy DataGridDefinitionBuilder class to build a grid and am g… -
Update Valid Intersections Rules via GroovySummary I want to create valid intersections rules or conditions via groovy while creating a new memberContent Hey all, I have a situation where the client has several v…
-
Manage / Automate Valid Intersections with Groovy (Solution)Hi - The below post from @JeremieR-Oracle gave the inspiration to get over the hump on how to update Valid Intersections completely in the cloud inside of EPM. Hopefully… -
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…
-
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…
-
UnZipping Files using zipOutputStreamJust some sample code to use the new zipOutputStream function String exportJobName='Job_Console_Export_20250925.zip' zipInputStream(exportJobName).withCloseable { ZipInp…
-
New Groovy version 25.10 Validation ErrorHello Experts, I have a issue when I run validation Groovy Script: My HTML Report have same error in several rules, now are working fine but I'm afraid that is not worki…
-
Groovy getFormattedValue() not working?Summary: Content (please ensure you mask any confidential information): Hi, Just found that getFormattedValue() not working as expected, it was working correctly before.…
-
Groovy Script ValidatorSummary: Content (please ensure you mask any confidential information): Hi, With the Aug release in TEST to validate groovy rule scripting restrictions by the provided t…
-
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…
-
If Condition with a Range or Substitution variable Groovy ScriptSummary: Hi , We have a substitution variable SSClosedWeeks which has a value of OEP_W1:OEP_W39. This variable works perfectly in member formulas. I would like to use th…