To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
EPM Platform and Freeform
Discussion List
-
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…
-
YTD calculation issue in ASO CubeHi All, I have a query on YTD calculation in ASO Cube. We copied 4 months of actuals in forecast and remaining 8 months forecast is present in forecast data type(which u…
-
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…
-
Issue with exporting xls data from several reports for some usersSeveral of our users are facing the issue(see a screenshot below) when they try to extract XLS from several Financial reports (all of them for reports from the EPM works…
-
how to make budgetaryControlBudgetTransactions REST API work with the "Others" source type in FusionWe are using the REST API endpoint: /fscmRestApi/resources/11.13.18.05/budgetaryControlBudgetTransactions to perform budget adjustments in Fusion from Oracle EPM, trigge…
-
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…
-
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 …
-
How to connect / build reports against data integration schema?Summary: In Data Exchange, after loading we need to get some statistics on numer of records exported, sum/avg of these records, etc. In EPM Integration Agent documentati…
-
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…
-
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…
-
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,…
-
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…
-
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…
-
Unable Add/View Line Item Details from Dashboard 2.0Summary: Unable to view line item details when viewing a form in Dashbaord 2.0. Is this a limitation of Dashboards 2.0, and is a solution/fix coming? Content (please ens…
-
How to load HFM data with Year and Period in multiple rows to FCC ?Summary: I’m trying to figure out how I can load data from HFM to FCC. Content (please ensure you mask any confidential information): The HFM extract comes in this forma…
-
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…
-
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…
-
Process Monitor Report Customized as per Client Requirement from Data ManagementSummary: Process Monitor Report Customized as per Client Requirement from Data Management: Business Requirement : User have 2 categories Actual_JD and Actual_AM where so…
-
Planning data exchange power user with Administrator role cannot run integrationSummary: Content (please ensure you mask any confidential information): Hi all We have applied to the Power user the new Integration role of Administrator so we can run …
-
Linking Source Documents in Cell text – Transferring and Using Document URLs from Source SystemsSummary: We’re currently exploring a scenario where, in addition to transferring numerical data from our source systems, we also transfer hyperlinks pointing to the unde…
-
How to export data from TPROCESSLOG table data managementIm trying to create a process with sql qurey on maintenances tables (Like TPROCESSLOG, TPARTITION and others) to export data to a file . This is to get process details h…
-
How Does Data Integration Order Columns for Load?Summary: How does Data Integration order the columns for load? Content (please ensure you mask any confidential information): We are integrating some data from an on pre…
-
Oauth2 token refresh using grant type "devide code" automationHello, Has anyone implemented to automate the Oauth2 token refresh process using grant type "device code" for accessing cloud EPM applications? I am interested in unders…
-
TLS 1.3 - Decommissioning TLS 1.2The following note states that TLS1.2 will be decommissioned, starting in the June update. IMPORTANT Actions and Considerations I have 2 questions: Can you please confir…
-
selecting specific index number of UDA does not workSummary: I am using the following function to select only 1st value of the UDA. MemberProperty("Group","UDA", (1)) But the report gives all the UDA comma separated. Cont…