Groovy
Discussion List
-
Error occurred in Groovy datamapsSummary: We've created a custom datamap using groovy, where We're customizing few dimension members. The script runs smoothly if we hardcode the Account members but fail… -
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…
-
Business Rule/Groovy Scripting to remove data in ASO at a specific intersectionSummary: Trying to determine if there is a way to create a business rule or groovy script which would clear data in ASO at a specific intersection utilizing members deri… -
Retrieving Base currency tagged to an Entity in EPBCS using groovyHi all, I am trying to retrieve Base currency tagged to level 0 entities in EPBCS application using groovy. As shown in the below image, for the respective level 0 entit…
-
Groovy Script is Failing with Expression exceeded the maximum number of new view instances (50)Summary: we are building Cascading feature for copying header bill to details to line level details with out Amendment for the lines where Interfaced flag is N we are en…
-
Automation of user variable limits/definitions?Summary: Is it possible to automate additions of new members in user variable definitions? Content (required): We have a number of user variables to assist in the limita…
-
how to retrieve the child job status for a Groovy DataImportRequestWhen executing a groovy rule using createDataImportRequest() the rule that calls the import will succeed even if the import fails. what is the way to check if the import…
-
Groovy failing while calling external REST API when adding date filtering conditionDear Experts, We have groovy script to generate csv file from RSET API json response. It is working fine when we don't have date parameter filter in REST API. The moment… -
Use Workforce OOB template/BR with RTPs and DTPs in a custom groovy scriptI have requirement where I need to Transfer bulk employees in the OOB WF module (Using the OOB BR OWP_Transfer, or the included OOB templates OWP_Transfer_T, & other 2).…
-
How to create a groovy rule to check for line returns in a text fieldSummary: We our trying to prevent our end users from entering a line return in a text data type member. Content (please ensure you mask any confidential information): We…
-
How to change the file name of data export to file processSummary:Hello, in PBCS, we have an integration to export some data, the filter changes, then, this data changes, how can we change the file name dynamically? Right now, …
-
The best way to get scenario start year for certain module by using groovySummary: I want to get Scenario start year & end year for workforce module by using groovy Content (please ensure you mask any confidential information): Hi All, I would… -
how to establish a connection with an oracle database server using the REST API using groovyhow to use that connection to perform crud operations in groovy
-
How to set up the EPM agent for Groovy scriptingSummary: I have used basic functionality of EPM agent, i.e extracting the data from on-premise database to EPM cloud in ASYNC mode. now i trying to get data using the AP…
-
Looking for Groovy exampleSummary: I am looking for an example of a groovy script that will make columns read only depending on an account value that is derived from a Smartlist. In this form exa…
-
Copy No_Currency data to Local Currency based on Entity base currencySummary: Is there a way to copy No_Currency data to the respective Entity base Currency with out using UDA's or Attribute assignments Content (required): In a Simplified… -
Using [[PlanningFunctions.getIdForString("text")]] within a calc script in a groovy scriptHello, I am trying to save some data into a Text field using the PlanningFucntions.getIdForString within a Calc script, that is nested within a Groovy script. I have bee…
-
Using Groovy trying to import mapping into the EPM data management INBOXSummary: Content (please ensure you mask any confidential information): Hi all, Can someone confirm if it is NOW possible to move an export mapping file from one cloud e… -
Cross App Data Map - Source as FCCS and Target as Free From Essbase ApplicationSummary: Cross-App Data Map - Source as FCCS and Target as Free From Essbase Application - Is this possible? Content (please ensure you mask any confidential information…Suresh Ratnala-Oracle 21 views 3 comments 0 points Most recent by Viorel "Van" Andritoiu-Oracle Planning -
Triggering OIC integration via Oracle Planning using GroovySummary: I am trying to trigger an OIC job from Oracle Planning using groovy. Content (please ensure you mask any confidential information): The connection is set up for…
-
Upload file from EPBCS inbox to files.com via REST API through 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 there a way in Groovy to throw an error based on certain validations and close the prompt screen?Summary: Hi Experts, Is there a way in Groovy to throw an error based on certain validations and close the prompt screen? In my current application, I am using throwVeto…
-
EPBCS : API call to Run Rule not fetching parametersWe have two Rules. Groovy_Rule1 should run on form save. Should pick Run time prompts and pass it to API call which will call Groovy_Rule2 to run a Data Map. Issue: For …
-
Groovy - Setup Scenario PeriodHello, I have my Groovy script for scenario and year changes, similar to the Planning Financial Module. I have a form with the "run before save" function associated with… -
Automated cleanup of scheduled jobs/mail notifications in DR instance post-EPBCS environment cloningIn our EPBCS application, we use the cloneEnvironment command as part of a daily automation to refresh our Disaster Recovery (DR) environment from Production. This clone…
-
Member Name contains comma for Data IntegrationSummary: Account name contains comma Content (please ensure you mask any confidential information): Hi All, I am performing an ASO to ASO cube data transfer using Data I…
-
group by / sum createDataExporter aso data exportsI'd like to use createDataExporter to extract data from ASO but i'd like to extract only the totals of some dimensions. This isn't possible without extra steps because y… -
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…
-
How to Allow Non-Admin User to Execute Groovy Rule Changing Dimension Member ParentSummary: Hi, have a groovy rule that updates a members parent member to move from one parent to another. It works for admin users but doesn't work for the non-admin busi…
-
FUTA Member Formulas Needs to Run Twice to WorkSummary: Content (please ensure you mask any confidential information): I have the below member formula for FUTA. It is kicked off by a business rule, and below is the s…