Groovy
Discussion List
-
DataExport Period PivotingSummaryI am working in Oracle EPM Cloud (Planning) and I am trying to generate a CSV export using the DATAEXPORT command inside a business rule. The export works correct… -
Automatically generated sequence scenario for custom objectSummary: We are in a unique situation for generating the sequence for custom object in a specific format. Content (please ensure you mask any confidential information): …
-
Groovy Calc script calling REST api fails when scheduled as Planning jobSummary: I have written a groovy script that runs as a part of a larger rule set. The groovy script has a rest api call that executes a pipeline having a data integratio…
-
Groovy Script to Return an Error Message if User Leaves Page Before Finishing RunSummary: I am currently working with a Groovy script in Oracle Sales/CRM Cloud. The requirement is to either warn or return an error message if a user navigates away fro…
-
Testing nonemptytuple on Planning Custom Calculation ASO (Groovy)Summary: Now that Essbase 21C is under the hood of Planning, did anyone notice performance gains from adding NonEmptyTuple to Custom Calculations in ASO? I have been adj… -
Possible to have Groovy Popup Warning, NOT Error?Summary: We have groovy rules set for validation that we use throwVetoException to stop processes before they start, but is there a good way using groovy to just throw a…
-
Custom Object Bell Notification - Configuration InquirySummary: To enable Custom Event notification Bell Function is there a way to include our Custom Sales Object in Notification Preferences (under Application Composer > No…Christian Gerald Patacsil 11 views 1 comment 0 points Most recent by Madhuri Cheruku-Support-Oracle Sales
-
We would like to know the Business rules association in EPBCS applicationSummary: We ran the system reports and found that they only display business rule associations related to forms, menus, and tasks. However, some rule associations outsid…
-
Data map is clearing data for different cost center in ASO even when CC is passed as parameterSummary: Hello Geniuses, I am facing an issue while running the datamaps using restapi connection. I am modifying the map definition in the job using rest api for cost c…
-
How to read the status of a specific period in FCCS from a Groovy scriptHi everyone, I'm working with Oracle FCCS and need to retrieve de current status of a specific period (e.g., Open, Closed, etc.) from a Groovy Script in Calc Manager. I'…Loren LM 32 views 4 comments 1 point Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 …
-
Forms 2.0 & Groovy throwVetoException not showing error messageHi - We are doing some validation of user entry before we run calculations on a form. We have been using Forms 2.0. When the validation fails and throwVetoException is c… -
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…
-
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…
-
Can Groovy help to generate ad hoc file ?Hello everyone, I have one question about Groovy's ability. My business users use ad-hoc to input the essential data. Then, they return to the form and run the Groovy ru… -
Upgrade to Essbase 21.7.x for 25.11 Connections failingThere was an error rendering this rich post.
-
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…
-
Push Data Failed: Error - The member does not exist for the specified cube or you do not have accessDescription: Hello, I am encountering the following error when trying to push data from an ASO cube (source) to a BSO cube (target) in Oracle PBCS: Error: "Push Data fai…
-
Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using GroovySummary: Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using Groovy Content (please ensure you mask any confidential information): I want to Cop…
-
How to return text values from a Business Rule (without using Smart Lists)?Hi everyone, I’m trying to write a Groovy Business Rule in Planning (EPBCS) that returns or assigns a text value to a member. The requirement is to store a text string (…
-
Pipeline Stage Failed If File Is MissingHi Team, We have a pipeline within the FCCS instance that consists of two stages. The first stage loads data into FCCS, and the second stage loads data into PBCS through…Jacob Gomes 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data duplicating after Groovy runs rule set when ad hoc runs are overlappedOur implementation partner was able to configure a set of Groovy scripts to kick off the various calculations in order, which can be both scheduled and/or run ad hoc by …
-
$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 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 12 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…