Groovy
Discussion List
-
UnZipping Files using zipOutputStreamJust some sample code to use the new zipOutputStream function String exportJobName='Job_Console_Export_20250925.zip' zipInputStream(exportJobName).withCloseable { ZipInp… -
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…
-
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…
-
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…
-
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… -
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…
-
Deleting file from Inbox/Outbox Explorer using REST APIHi all, We are trying to delete a csv file from Inbox/Outbox Explorer using the below REST API https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-co…
-
Groovy: Essbase Error(0) Invalid member nameHi all, I am trying to retrieve the date from a combination using DataGridDefinitionBuilder and extract year, month and day from it. The approach might be a bit long but…
-
how to extract Integration period in EPM Agent using GroovySummary: I am trying to extract the period for which that integration has executed , Content (please ensure you mask any confidential information): Version (include the …
-
Data workbench export to excel optionSummary: I tried to export workbench data to excel Content (please ensure you mask any confidential information): I have received a requirement from a user to export wor… -
Exporting Supporting Details to CSV via GroovySummary: Hello, I'm looking to see if there is a way to export Supporting Details/Line Item Details from EPBCS via Groovy in a CSV. As of right now we have a process of …
-
ChatGPT API IntegrationSummary: Posting a small groovy snippet to allow chatGPT API integration. This is meant as a bit of fun with no practical applications at the moment. You will need to ge…
-
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…
-
Is there a way in Groovy to throw an error message with line separator in error promptSummary: Content (please ensure you mask any confidential information): Hi Experts, Is there a way to include line separators in error messages when using Groovy? I'm cu…
-
Run More Than One Calc Script in Groovy ScriptSummary: I am trying to run multiple pieces of calc script from one groovy script. It is executing the first piece essCalc1 and then the data push that is after essCalc1…