Groovy
Discussion List
-
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 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…
-
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…
-
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…
-
Oracle EPM Data Pipeline Cross Pod ExecutionSummary: Executing One Pod Pipeline from Another Pod, triggering FCCS Instance Pipeline from EPBCS Instance Pipeline Content (please ensure you mask any confidential inf…
-
How to get the Dimension names which are present on the Columns of a webform via groovySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to get the Smart Push functionality to work in Dashboards when they are being utilized via SmartSummary When submitting data for an EPBCS Dashboard in Excel via the Smart View 11.1.2.5.910 (Build 172) add-in, the Smart Push for the underlying simple forms being sav… -
Using Groovy in EPBCS to export data from EDMHello everyone, I am doing step by step to set up the Groovy rule to import metadata from EDMCS to EPBCS based on this guidance: However, when I executed this Groovy scr… -
How to use groovy script to run the allocation in PCMCS and how to load driver data using groovySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is it possible to set attribute value from SL value?Summary: Is it possible to convert SL Value and attach it on attribute dimension. Can we do it using groovy, if yes could you please share code snippet. Content (please … -
Getting error Cannot find matching method java.util.Date#format(java.lang.String, java.util.TimeZoneSummary: Getting below error for one of the Groovy scripts in Groovy Script Validator. But we can validate and run the rule without issues Cannot find matching method ja…
-
Groovy script to Validate comment entered through data formSummary: Hi, I am new to groovy BR. I am working on Groovy BR to validate "comment" entered by user using data form. A member with "Text" data type is used in data form …
-
Automation Mechanism for Approval Status SynchronizationHi Gurus, I am seeking an automation mechanism that will allow the approval status of an entity in PBCS to change based on the approval status of the same entity in FCCS…
-
Data push for large volumeContext: We need to push ~12–15 million records from a Source ASO cube to a Target ASO cube within the same application. Standard data push and Groovy-based export/impor…
-
Delay in calc manager to recognize new Smart Lists/Variables?Summary: I created a new SmartList within Planning and new Variables in Calc Manager. The SmartList isn't showing in the options for variables and the variables are givi…
-
Metadata Integration between EPM Cloud ApplicationsSummary: How to integrate metadata between EPM Cloud Applications? How to transfer metadata files to other EPM applications? Content (required): Hi all, between two EPM …
-
Groovy script validatorHi Community Folks, As released by Oracle in August patch, while using Groovy script validator, I am getting below two compile errors in some of my groovy scripts writte…