Groovy
Discussion List
-
How to pass dynamic parameter to POST API from GroovySummary Need to pass dynamic parameter to Account REST API in the post call from Groovy script -
how to create a groovy script if a DFF in the contract line is null it will raise a warning messageSummary: how to create a conditional groovy script if a DFF in the contract line is null it will raise a warning message Content (please ensure you mask any confidential…
-
Export specific dimensions from ASO cube to BSO cube using Groovy ScriptSummary: I've a script in groovy, basic script, it works but i need to remove a dimension that's in the row; Script: Cube cube = operation.application.getCube("CAPEX") c…
-
how to export and import using groovy scripHi eveyone, I'v 2 cubes, ASO and BSO, for dense dimensions, to ASO its Account and to BSO its Period, can i use groovy to Export and Import with this case?? I mentioned …
-
Need Calculation scriptsSummary: Our Company Contribution to Staff Association (1) Use the prior year’s actual contribution to staff association to forecast the contribution to staff associatio…
-
CsvIterator fails when the file size is >100Mb script gives unknown errorSummary: CsvIterator fails when the file size is >100Mb script gives unknown error when the size is reduced the same code works fine. Content (please ensure you mask any…
-
run the groovy to execute data map with Planner userHello everyone, Is there any way to run the data map when using planner users? A user with planner access facing issue while saving the data form that have the data push… -
Sort Pipeline GET responsesSummary: Pipeline returns DM Process IDs in unsorted manner, would like to sort this Content (please ensure you mask any confidential information): Am trying to sort the…
-
When I run the rule, the system prompts an error, but when I run it a second time, the error disappeThis is a rule written by "groovy". Groovy acts like a rule set that calls rules and gives some parameters. The JOB status is “completed with Erros” . Details content of…
-
Navigate to another URL from a form passing a dimension name in the pov throughContent Hi, does anyone know if we can navigate from a form in EPM cloud, picking up members in a pov and passing them through to another web site and surfacing that web… -
MDX Calculations with Custom Groovy Scripts In ASO Cubes.I want to write a Groovy Script in ASO cube, that should execute complex calculations involving multiple operators across various dimensions. Can anyone provide any sugg…
-
PBCS run an epm automate process through a groovy ruleHi all, i'm trying to run a epmautomate process into a ePBCS groovy rule. If i put the password into the code (or into a variable) as, for example: /*RTPS: {rtpUser}, {r…Enrico Amabile 131 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Pipeline GET Call errorSummary: Pipeline POST is successful but trying to get the status of pipeline jobs and says error occurred while processing this page. The error appears same for any 'it…
-
Read csv file using groovy scriptSummary: Hello all Below is the requirement I'm trying I have a csv file in inbox/outbox explorer which has data in a particular combination. Example : A1 jan 2024 = 100…
-
Json ArrayI have requirement of writing JsonArray data which is pulled from a wen API to a csv file Rest API url : https://jsonplaceholder.typicode.com/users Json array : [ { "id"…
-
Cross Pod Data Map - Dynamic Wildcard Mapping from Source to Target in Groovy/Smart PushSummary: We have a need for a cross-pod Smart Push to push data from a cube in one Planning environment to a cube in a another, separate Planning environment. I am loopi… -
Read Document Record Attributes values from an Attachment and create recordsSummary: In Oracle Sales Cloud is there any option to read .Xlsx file data and create records in custom Object. Content (please ensure you mask any confidential informat… -
Fastest way to export large filtered ASO data setWhat is the current consensus for the fastest method of exporting ASO plan type data? Assuming it could be a large data set with dynamic members and would need to be fil… -
EPBCS groovy CustomCalcParameters script syntax issueHi All, I'm struggling with MDX syntax to calculate actual to Date using groovy CustomCalcParameters. Although when I use RHS part of the script Sum(TupleRange(([FY20],[…
-
Using Groovy, need to select upper level members to push data to other cubesSummary: Using Groovy scripting, when pushing to other cubes, need to select upper level members to push data. Content (required): Using Groovy scripting, we need to sel… -
How to elaborate a groovy script when im a Starter and can't find sintax from DocsHi everyone! I hope you all be good! Im starting to use groovy into scripts to performance the application and i already passed by some cases and im not finding the corr…
-
Cannot find a universal way to input Date formats via Data Grid BuilderSummary: Hi, We are working with data grid builder in groovy rules. We need to upload today's date once a modification is performed. Though, we are noticing different be…
-
Executing a Refresh Job from API Using Groovy Console Continuously Poll Status AssistanceSummary: I am trying to construct a script in Groovy (not a business rule on the EPM server, but rather a pure Groovy script to be run on prem) to leverage the Planning …
-
DataGridBuilder security issueSummary: Hi, We have a rule using DataGridBuilder to do some calculation and save data back. When the rule is executed by users, data didn't get saved back. Then we figu…
-
How to upload file to inbox in EPBCS using REST API through groovy Business Rule?Summary: we are trying to upload file to inbox in EPBCS using REST API through groovy Business Rule. we are struggling on how to define the file path which is on the ser…
-
Is it possible to display a custom message when saving on a form?Summary: I would like to display a custom message after saving the form that notifies users that they need to run another step. Content (please ensure you mask any confi… -
Groovy MDX script to get HTD valueHi Folks, Can you please help me writing MDX script in groovy to calculate HTD value or at least YTD value. Below script is throwing error: A method called by the script…
-
Groovy code on Business Object Data Security RulesSummary: I can hardcode a value in a BO Data Security Rule condition & it works fine. However, when i try to use an expression in the rule (i.e. Groovy), although i can …
-
How to copy the attachment and create in new RecordSummary Using groovy, How to copy the Attachments from one record to other recordContent Hi, I have a requirement in one of our business process, need to create a copy o… -
Planning Provider Error occurance when linking Custom Measure and standard measure in Measure DmHi Oracle Support, We created a custom measure called "Current Target" under the Measure Dimension for sales planning. Our goal was to reference this standard measure us…