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
-
Moved: Need guidance task manager rules (few issues too)This discussion has been moved. -
groovy rule to track changed data to get entities loaded via data management in FCCSSummary: Requirement: We are currently looking to optimize our data load process and are looking for a way to track which entities have actually loaded to the applicatio… -
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.…
-
Reports folder missing from Freeform Apps in SmartViewSummary: Reports folder is missing for some users in SmartView in our Freeform applications. This issue persists only for few users and not for everyone. Content (please… -
Moved: Is There Any Rest Or Soap Web Services To get Error Log Files for FSM Import Using OICThis discussion has been moved.
-
Is it possible to turn wrap text off for a Report when it's run in excel?Summary: The Reports tool appears to default every cell with wrap text on when run in excel. I can't see a way to prevent this from happening. We had a report with a cus…
-
Drill Through between EPM Cloud: Planning to FCCS using Smartview Drill through optionSummary: Content (please ensure you mask any confidential information): Hi all We have an integration set up EPM Cloud and ERP and that works fine, but now we want to us… -
Option to Disallow Service Administrators from Assigning EPM Predefined RolesHad anyone tried the option to Disallow Service Administrators from Assigning EPM Predefined Roles. Here is the reference - https://docs.oracle.com/en/cloud/saas/readine… -
Drill through request for Exchange rates in EPBCSDrill through URL is currently not working for exchange rate when the source is NetSuite. Is it possible to drill through the fx rates from EPBCS when the source is Nets…
-
Is it possible to use two-factor authentication in EPM Automate?Hello! We have an intern necessity for the users to be able to execute data loads through EPM Automate. However, the users use a two-factor authentication Regards,
-
How do Planning or Freeform users know when the application/cube was last updated In Smartview?Summary: When using Smart View, how do Planning or Freeform users know when the application/cube was last updated? Content (please ensure you mask any confidential infor…
-
EPRCS Narrative reports Exporting to Excel not taking pages names in the Excel tabSummary: EPRCS Narrative reports - After Exporting to Excel, Excel tabs are printing with Report name not with Report pages member names. Is there any option to customiz…
-
How to export Period and Years dimension values from PBCS to ADB (EPM Integration Agent)Summary: Hi, I'm trying to create an integration in order to write back data from PBCS to ADB using the following procedure: https://docs.oracle.com/en/cloud/saas/enterp…
-
Error while converting RTP To Smartlist ValueSummary: We have a requirement where we're updating smartlist values based on form POV through RTP using function : "Tgt_Dept1" = @CalcMgrDoubleFromString(@SUBSTRING(@AL…
-
Database note in Smartview for EPM cloudSummary: For on-prem Essbase applications, we have "Database Note" option in SmartView which refers to a text field or annotation that can be associated with a specific …
-
oracle EPBCS reports period offset function is not workingHello Community, The EPBCS reports which are using Peiod Offset function worked until last week have broke this week and not sure if this is the result of April patch. T…
-
Navigation to extract metadata for certain entities for EPM ODAHi, Can anyone help with the navigation to extract metadata for following entities for EPM ODA Configuration? JOB_NAME DIM_MEMBER FCM_REPORT_GROUP_NAMES FCM_REPORT_NAMES…
-
EPM Agent SQL parametersWe have this source query which is working well (see below), but we need to add a bit to update the period value. For example, if the EPM period (~Period~) is 02 then @P…
-
Data Exchange Workbench Source Period Dimension pull AmountSummary: Hi all, I'm encountering an issue in Workbench: the "Source Period" column is showing amounts instead of the period dimension. I've already mapped the "Dimensio…
-
calculating YTD from MTD dataHi, As the data is loaded in MTD values I want to calculate the YTD value for the Balance Sheet accounts in EPM Planning. The dynamic time series only considers the curr…
-
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…
-
Smartview 25.100 Excel and Word crashes when trying to create a new private connectionSummary: New Smart View Installation; Shared Connections work but when trying to create Private connection, the popup does not appear and excel/word crashes. If anybody …
-
Purpose of daily maintenance for EPM CloudSummary: I wanted to check if there’s a specific reason why the daily maintenance is required for EPM Cloud. Is this behavior consistent across all Oracle Cloud Fusion a…
-
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 …
-
EPM Data File does not show Import Format/Map and how to export this?Summary: When creating the data export to EPM Data File there is no option to upload Dim names as a CSV. Once a target app is created as EPM data file it does not allow …
-
remove spacing between two grids in EPM Freeform ReportsRequirement is to remove spacing between two grids in EPM Freeform Reports Content (please ensure you mask any confidential information): screenshot is provided above Ve…
-
Is it possible to add superscript to Report text ?Summary: Is it possible to add superscript in the Report text ? For e.g. we have names to be displayed in report as shown below: Content (please ensure you mask any conf…
-
Hide the sheet Table of contents in Book Excel outputSummary: Is it possible to hide the sheet "Table of Contents" in Book Excel output. Still need the sheet names which we define in the TOC Heading properties. Content (pl…
-
EPM FormsHello community, regarding EPM forms, do you know if version 1 forms will need to be migrated to version 2 or if they can be used automatically when Oracle disables vers…
-
Unlock by Location does not work in CLOUDSummary: I'm unable to unlock a single location once a period is locked. Steps are as follows: 1) In DM, under Application Settings, choose Target Application and then L…