Groovy
Discussion List
-
Looking for a way to use Azure service principal for connecting to EPMSummary: Hi, Looking for a way to use the Oracle EPM API through azure service principal instead of service account for authentication purpose? Found the below blog but …Tushant Pandey 7 views 1 comment 0 points Most recent by Abhinav Jain-Oracle EPM Platform and Freeform -
Create Dynamic Child with sequential codeHi, Can we create sequential project codes in EPM metadata? We know we can use the Create Dynamic Child option to create metadata members through RTP. In this option, we… -
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 18 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 38 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 168 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 708 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 36 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 670 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 27 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 23 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 392 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 46 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 27 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…
-
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…