Groovy
Discussion List
-
Dynamic Substring Function - Essbase Equivalent of FIND/SEARCH Function from ExcelSummary: We have a need to perform dynamic member name lookups with member names that are varying lengths (something outside of our control as they come from a source sy… -
Script doesnt work as expectedHi we want the aggregation of a different dimension eg row 6 and 7 needed to be summed up in row 11 ie where ever the functionl area = Room Sales_FA it need to summed to…Althaf Abdullah 31 views 2 comments 0 points Most recent by Lakshani Hettiarachchi EPM Platform and Freeform -
Receivables Billing Object in Groovy ScriptHello, Is there any object accessible by Groovy script to access Receivables/Billing information? The scenario is: To create a subscription, I need to have the account a…
-
Decimal precision not working -groovy-csvwriter -datagrid exportSummary: Hi All, I am exporting datagrid to csv file(csvwriter) using Groovy script. The exported data has precision issues as below. For Example: In smartview, the data…
-
Groovy - How to exclude shared members from ASO createDataExporter()?Summary: HI All - I need to exclude shared members from a createDataExporter() ASO data export. Would the best way way be to create two lists : List 1 with the members f…
-
Is there a way to automate updating data map member mappings?Summary: We have a cross pod data map with member mappings. There is no ability to do dynamic member maps so we need to manually update it every time a new member is add… -
How to convert JSON Format REST API Payload (Request Body) into Groovy format for the below PayloadSummary: The below Payload is working fine with the POSTMAN (The attachment element with multiple IDs with comma separated values in the Body Request) {"to" : "to_email@… -
Create Dynamic Choice list based on Opportunity Line Item ProductsSummary: Can we create a dynamic choice list to show a list of products that are on the opportunity line items for a custom object related to the opportunity object. Con…
-
Groovy to query only Contacts but not user recordsHi All, I have actually written a code to query the Contact object based on email. But the query is also searching for user records with that email and returning the res… -
Passed parameter goes as null when calling BI Report from groovy scriptSummary: Trying to call BI report from groovy script, but the parameter is going in as null Content (required): I am passing the parameter in the payload but it is going…
-
Using groovy to move a file from the Data Management Inbox To the Oracle Planning Inbox ExplorerI am working with OTBI report(s), and this report holds master data which needs to come into EDMCS. OIC is being used as the facilitator from Oracle Fusion into the Orac…
-
How to get the user resource roles using Groovy ScriptSummary: Hi, We want to send email notification to manager when partner contact is created in Partner object. but how to get resource role of user in groovy to check in …VIBHA S D 103 views 6 comments 0 points Most recent by Carmen, User Assistance Oracle CX-Oracle Sales
-
How to fetch contact email and phone number before the contact is deleted using REST API in GroovyHi Team, We have a requirement to store contact email/phone number whenever the contact is deleted. We are able to capture details if the contact is deleted using Delete…NikhilSamudrala-Oracle 41 views 7 comments 0 points Most recent by Satyavani Gundumogula-Oracle Sales
-
Changing background color to cell in data froms using GroovySummary: Requirement to change the background color for a data cell based on certain condition Content (please ensure you mask any confidential information): Hello, We n…
-
How to make Recurring revenue editable if Recurring quantity cannot be edited and vice versa?When I enter the Recurring Quantity on the Opportunity Line Item, the Recurring Revenue field should no longer be editable. When I enter the Recurring Revenue on the Opp…
-
Create a trigger based on resource person typeHi, We need to create a trigger based on the PersonType attribute of the Resource object. The logic should be as follows: if(PersonType='EMP'){ setAttribute(newField_c,'…
-
How can we access the Manage Daily Rates in groovy scriptHello Team, We have a requirement in our current implementation like we need to convert the a currency value to different currency based on the Manage Daily Rates stored…
-
Ruleset parallel execution issueSummary: Content (please ensure you mask any confidential information): Hi, I got a weird issue when running a ruleset with parallel execution enabled, and want to seek …
-
Get ResourceUsers data via groovy scriptWe need to create a trigger that, when a Resource User is created, sets a custom field with specific values. How can we retrieve data from ResourceUsers in a Groovy scri…
-
Error When Saving DataGrid in Production - "An error occurred while processing this page"Hi Folks, I have encountered an issue when calling the saveGrid() method to save a DataGrid in the production environment, which works fine in the cloned environment. He…
-
How get all contacts linked to Account in groovy scriptSummary: In Accounts groovy script I want to get all the Contact's those are linked to it. Content (please ensure you mask any confidential information): Version (includ…
-
data export 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…
-
Did the port for Connections Rest API change with the 25.02 monthly update?Summary: When performing regression testing of the 25.02 (Feb) monthly update, our groovy/rest api calls fail with error "Invalid port specified in the URL. The only all…CCel 162 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Utilizing UDA Members (Level 0/Parent Members) in Data Export via Data Integration Filter or GroovyWith Data Export in Data Management (Data Integration in Planning): We are experiencing difficulties in applying a filter condition for data export using UDA. The requir…
-
Update Resource Class Dimension Members Parent via GroovySummary: I am looking into the best way to update Resource Class member's Parent value via a groovy script. The reason would be to move from an ACTIVE parent to an INACT…
-
Send email with Groovy PBCSHi, I use PBSS. I would like to send emails to users with the REST API: "rest/v1/services/sendmail". I created a connection in PBCS with an admin account, but the email … -
Pre-Validation Error report to check for the error of Data Management before execution of DLRsSummary: If there's any way to get the Pre-validation error report before the DLR execution for loading the data: To know if any member is missing (not in the system but…
-
Can we update multiselect field through groovy when we are merging accountsSummary: When merging accounts, we need to update the multi-select custom field for the survivor account using Groovy scripting to store the values from both the merging…