Groovy
Discussion List
-
Timestamp on file name 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… -
Copy to SFTPSummary: Experts - I am trying to automate back up process and move the file to SFTP server with the new REST API Command Copy to SFTP. Below are the steps. 1- Business …
-
EPM groovy and DataExporter with two decimal restrictionsHi, We are using EPM groovy business rule to export data using class DataExporter. However we are seeing issues with decimals for some of data in the export file.I could…SrikanthReddy-Oracle 11 views 1 comment 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
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
-
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 141 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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…
-
GROOVY SCRIPT FOR ASO data exportSummary: Hi All, I have writeen a Groovy script to export the level0 data from the ASO cube to a csv file based on few conditions. Account dimension is not a compression…Sreekumar Hariharan 501 views 17 comments 0 points Most recent by SuneelKanthala EPM Platform and Freeform
-
EPM REST API SEND EMAIL V2 - Limitation in allowed characters or lines?Summary: Using REST API Send email v2. This does not trigger email when line exceeds >1 in Calc Manager (body of the email) Content (please ensure you mask any confident…
-
How to access file in DM Inbox using Groovy?Summary: How to access file in DM Inbox using Groovy? Able to access files in front end Inbox/Outbox explorer. Is it possible to access from DM Inbox or by default only …
-
EPM Automate Server-side script - Profile keeps lockingSummary: Using a EPM Automate Server-side script to execute Quick Mode rule for multiple periods in filters as this feature is still not there in Pipelines. The Business…NarayananS 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Finding current environment/application in GroovyI am trying to find what the current environment is (planning, planning-test etc) in a Groovy script so we can automatically switch of emails sent to user in test and de… -
How to search a string variable in Groovy for a specific part of a string.Summary: How to search a string variable in Groovy for a specific part of a string. Content: We're currently using an pipeline that triggers everyday and processes the f…
-
GROOVY FEATURE TO EXPORT DATA WITH ALIAS NAMESSummary: GROOVY FEATURE TO EXPORT DATA WITH ALIAS NAMES Content (required): Hi I am taking note of the new features of May 2023 for EPM Cloud. And in particular I am int…Alain Mathon 441 views 6 comments 0 points Most recent by Jonathan A Cohen EPM Platform and Freeform -
Why groovy rule for validation is not functioning properly ?Summary: We have an issue with the following Groovy rule validation command. In the current rule, the validation command "isMissing" is not functioning for the "Descript…Salma Mohamed 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Copy Version in EPCMCSSummary: Hi all, does it is possible to use the out-of-the-box copy version functionality in an EPCMCS application? I can only see the Copy Data Functionality, but i nee…
-
ASO Custom Calculation vs. Graphical Editor DifferenceHi folks, I'm working in a custom EPM Planning app and trying to create an ASO business rule to calculate a percentage of total headcount. I can use the graphical design… -
Data Export with Pivot DimensionSummary: Hello Wizards, I have requirement to export BSO data (Non Num as well) to csv file with Account dimension on the column (Pivot). Expected Output (StartDate and … -
Automate file transfer from SFTP to EPMOur current process with OIC renames the file on SFTP(Example file name: Testfile_MMDDYYYY_HHMMSS to Testfile MMM-YY) and moves the file to EPM then deletes the file on …
-
EPM automate connectionSummary: Currently, in our Groovy business rules, we are using the EPM Automate login command to establish the connection and then execute EPM Automate commands // Login…Priyesh P. Rane 21 views 4 comments 3 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPM Freeform supportSummary: Does EPM freeform support Artefacts, Rules (Calc & Groovy) same as per Planning? Content (please ensure you mask any confidential information): Does EPM freefor…
-
Run pipeline using restapi in Groovy ScriptSummary: Hello guys, I'm trying to run a pipeline using Restapi in Groovy script. There is no error but i'm getting status 0 and it's not triggering to run the pipeline.…Makam Krishna Vamsi 231 views 11 comments 1 point Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
How to Copy Data from a combination to another combination using groovy in PCMSSummary: Need to Copy Data from a combination to another combination in a form using groovy in PCMCS Content (please ensure you mask any confidential information): Versi…Sri Harsha Panchumarthy 41 views 5 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Has anyone used server side epmautomate with a loopback (127.0.0.1) or "localhost" server name?Summary: I'm using a groovy script that uses server side epmautomate. In place of the the server name in the URL, I would like to use a loopback address like "localhost"…
-
Data push from PCM_CLC to PCM_REP using Groovy in EPCMSummary: Hi Team, I am curious to know if we can push data from Calculation cube(PCM_CLC) to Reporting cube(PCM_REP) using Groovy Script in EPCM. If anyone has tried ple… -
How to print the Duplicate data in a form in incremental order using groovySummary: Exporting the Repeated Data Combination in a form in incremental order using Groovy Content (please ensure you mask any confidential information): I want to pri…Sri Harsha Panchumarthy 21 views 1 comment 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
Business Rule behavior in PipelineSummary: Business Rule behavior in Pipeline Content (please ensure you mask any confidential information): Data Exchange Quick Mode Rule (EPM Automate Server-Side script…
-
OAuth2 Refresh Token Request not working from EPM Groovy ScriptSummary: We are facing issue while calling Rest API to generate an OAuth2 token using EPM Groovy script. I am trying to run the following code, but if I try same step in…Gajendrababu Srinivasan 61 views 8 comments 1 point Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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…
-
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…