Groovy
Discussion List
-
$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 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…
-
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: When I deploy or launch the rule, it only shows one RTP value to input, even though I have two RTPs…
-
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…
-
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…
-
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…
-
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… -
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… -
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…
-
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…