Category 161
Discussion List
-
DELETE sql statement for on-prem databaseSummary: Has anybody found a way to run a DELETE sql statement before exporting data to an on-prem database using Data Integration? In Applications, there is field that … -
Unable to select YTD as an user variable in data formSummary: I am trying to select YTD for all months in user variables which I am able to but when I select period as a dynamic user variable it does not reflect in the dro… -
When testing strong ciphers with EPMAgent, 401 Unauthorized receivedSummary: We are in the process of testing our strong cipher set ups per the Oracle documentation here: How to Test with the Latest TLS Ciphers The documentation indicate…
-
Object Storage Large File SegmentingWe are looking to use Object Storage as a file staging zone for data extracts going to external systems that can readily retrieve files from Object Storage. To do this w… -
The substitution variable DataLoadConsolMember is not working as expected.We have two DLRs: one for overrides and one for trial balance (TB) load from ERP. First, we load the overrides data, which successfully appears in FCCS. However, when we…Avani Makwana 24 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Issue while migrating file based data source application from one environment to another.Summary: Hello, I have registered a file as data source and have created a file based integration to import data into EPM application which is working as expected in the…Neha_R 23 views 5 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Date picker in smart view formsHi We have a Date data type account member and when we use this member in Web Forms in EPM, this will allow users to pick the date from Date Picker. But if the same form…
-
We don’t receive the forgot password email (OCI login)Has there been any updates made, or process we need to follow to receive the forgot password email when logging in to OCI?
-
Does anyone encounter the following error while runnign IPM :Summary: Auto Prediction Data access errors _________________________________________________ MDX parser error: No data available Run Summary ___________________________…
-
25.05 | Deprecation of Java 8 for EPM AutomateThe 25.05 release notes says that EPM Automate will discontinue Java 8 and move to Java 17. We are using Java 15 on Linux OCI server. The latest Java version is Java 24.…
-
Using simulateConcurrentUsers, we have a question about testMode=1Summary: in simulateConcurrentUsage, if we have a requirements.csv file that has 25 tasks, and we ran testMode=1 for 10 users, will it cycle through the 10 users or will…ChristopherZ 24 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Groovy to show a message that does not indicate an error in Planning / Free Form?Summary: Hi, We're using the MessageBundleLoader in Groovy to display information to the users in our Free Form application. I have not found a way to display a message …
-
Is rtp a restricted word in simulateConcurrentUsage?We are experiencing an issue with simulateConcurrentUsage regarding how it is processing rtps when performing the Run Business Rule function of this command. We have att…Russ_Shellhamer 104 views 20 comments 1 point Most recent by Russ_Shellhamer EPM Platform and Freeform
-
Budgetary control integration from EPM to ERP unexpected behaviorHello team, We are running into some difficulties while configuring Budgetary Control integration between EPM and ERP. As far as I understand, to be able to see the Budg…
-
EPMAT-1:EPMFDM-ERROR: 'periodName' parameter format is invalid.Summary: Content (please ensure you mask any confidential information): Hi all, As specified in the Oracle Documentation,I'm trying to use the periodName parameter in EP…
-
Scheduling job for cross application data mapsHi, With the recent support for cross data maps push to remote application, I am not able to see such data pushes under Data Maps in Jobs scheduler. Is there any securit…Loganathan Nachimuthu 41 views 4 comments 0 points Most recent by Loganathan Nachimuthu EPM Platform and Freeform
-
Oracle EPM Platform: Looking for exact Release Date of new groovy engineWith the August Release of Oracle EPM (Planning Cloud) the update of the groovy Engine was announced for the 2nd half of Year 2025 (pop-up window on start screen and rel…R Abel 81 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPM REST API or Workaround to Update Data Exchange Connection PasswordsWe would like to know if there is an Oracle REST API available to update the password for Data Exchange (Data Management) connections in EPM Cloud. Our goal is to automa…Ab1010102 17 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPM Automate Server-side script- Running IntegrationSummary: Content (please ensure you mask any confidential information): I'm trying to run a data integration job using the runIntegration command from a Groovy Business …
-
Data Integration Pipeline feature in ARCSSummary: Availability of Data Integration pipeline feature for ARCS Content (required): Currently the data integration pipeline feature is not available in ARCS. Any ide…
-
Will EPMAutomate "copyFromSFTP" Support Non-Default Ports (Other than Port 22)?Summary: Content (please ensure you mask any confidential information): I’m currently using the copyFromSFTP command in EPMAutomate to pull files from an SFTP server. Th…Ayeshan 15 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
DM NZP: How to keep zero values and ignore blank valuesHello, During data integration, if I define NZP in import format, as expected it disabled zero suppression, meaning all zero values are imported from source. This also f…Vijay Mahantesh-Oracle 14 views 4 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform -
Data File rename in EPMDear Experts, We are moving file from SFTP to EPM application using REST API. As a next step we want to rename those files once it got moved to EPM overview. Is there an… -
Missing Groovy Script ValidatorHas anyone else managed to find the Groovy Script Validator? The release notes for Aug 2025 say, "This update provides a program called the Groovy Script Validator" but,…DGreen 69 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Rest API queriesSummary: 1.Oracle recommendation on the most efficient way to export files via Rest API. We are planning to use Pipeline to export data (job setup to export data) - then…Muruges89 25 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Oracle EPM Data AuditOur customer would like to see Data Audit by EPBCS Cubes. The audit feature currently does not provide the filters by EPBCS Cube. Is there a way to see data audit record… -
Results of Groovy Script Validator BlankSummary: For a number of applications, all of which have Groovy code in place, the Groovy Script Validator Report is not producing any results where we were expecting th…Evan L 112 views 5 comments 0 points Most recent by Ujwala Maheshwari-Oracle EPM Platform and Freeform -
Data Exchange Quick Mode Import Failing due to unknow membersHi, I am loading data using Quick Mode, but the job is failing due to unknown members. Since there are a large number of unknowns (around 5,000 records), it's not feasib…MohanJ 14 views 4 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
OAuth 2.0 - Secure Store Example and which encryption is suggested?Summary: What is indicated by Secure Store here and which is the suggested/preferrable encryption? This is for OAuth 2.0 Device code grant type, and this is as per admin…
-
substitution variables used as filter in EPM agent and pass it through SQL querySummary: substitution variables used as filter in EPM agent and pass it through SQL query Content (please ensure you mask any confidential information): substitution var…Sandeepgupta1981 37 views 5 comments 0 points Most recent by Sandeepgupta1981 EPM Platform and Freeform