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
-
After April patch, Data Exchange ping shows up as log inSummary: After the April patch, we see that our robot user that we use to control our EPM Integration Agent is showing up on the log in report every five minutes. We can… -
We are trying to write a calculation referring FCCS_YTD member but its not workingSummary: Hi Team, We are trying to write one calc script using FCCS_YTd data but rule gets stuck whenever we try to run it. This is working fine when we run it with "FCC…
-
Why do the data load process steps vary?Summary: We've noticed that the five steps in the data load process vary. The last step sometimes says "consolidate data for consolidation application mmm-yy" and someti… -
What are the ways to extract data from Oracle PCM application?Summary: What are the ways to extract data from Oracle PCM application other than extracting into file from data management? Content (please ensure you mask any confiden…
-
Excel Export Issue: Times New Roman Font Causing Overlapping TextDescription (Required): The "Times New Roman" font is not displaying text correctly in the title/heading of the report when extracted into Excel. The report title appear… -
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…
-
What is the significance of BSO data Storage in PCM metadata file.Summary: What is the significance of BSO data Storage in PCM metadata file. What needs to be selected for BSO data storage in case of shared data ASO data storage. Conte…
-
Data Management Mapping question - when two different categories of mapping for the same dimensionI need to set up a Data Management Load rule to transfer data from CPX to FIN cube in a custom Planning application. The source of the mapping must vary based on whether…
-
EPM Automate command for ARCS auto reconciliation ruleSummary: Is there any EPM automate command to run auto reconciliation rules like auto submit and auto approve after reconciliation is created. Generally once the reconci…
-
In Oracle PCM, Can we retain the data in the application after creating new dimensionSummary: In Oracle PCM, We already have a application with existing data. Due to a new requirement, we need new dimension. Can we retain the data in the application afte…
-
Create new EPM Pods in OCI consoleSummary: Oracle is announcing that the My Services will be replaced with OCI Console after Mar 31st, 2025. Does anyone know how to create new EPM PoDs/monitor EPM enviro…
-
redwood themeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can I use the 'Description' field in a Mapping with SQL Script?Summary: I'd like to use the 'Description' field (available in the workbench) in a SQL script for the mapping. Content (please ensure you mask any confidential informati…
-
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… -
Moved: source expression transformation after CONCATThis discussion has been moved. -
EPM Reports Contents/TOCSummary: Creating Contents/TOC in a book (After migrated from FR) Content (please ensure you mask any confidential information): Hi, We migrated all the reports from FR …
-
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,
-
Running into capacity limits due to throttling of API requests since migrating to GovCloud OCI Gen 2Summary: Since migrating to GovCloud OCI Gen2 we have been running into what appear to be numerous API throttling limits in place on our identity domains. Content (pleas…
-
Monitoring EPM Integration Agent healthSummary: Hello, I'm looking for a tool or method that proactively checks the health of the EPM Agent before running a Data Exchange integration. We use the EPM Agent to … -
New video available for FreeFormWe are pleased to announce the availability of the following new video: Introduction to IPM in FreeForm This overview shows FreeForm Applications now support Intelligent… -
Need instruction or guidance to extract the DLR rules in excel format.Summary: We need instruction/steps to extract the DLR rules which are set up in the PCMCS (Data Management). Business need to validate the existing filter conditions ava…
-
Any plan to deprecate EPM SKUs?Summary: We would like to know if there is any plan to deprecate these SKUs and if there is some mandatory plan to move to B91074 - Oracle Enterprise Performance Managem…
-
EPM Automate login for new userWhen we add a new user and is provisioned with role assignment, for e.g. Service Administrator role is added to a particular environment… that user is unable to login fr… -
1remove restricted characters within data integration for attributesSummary: Current data integration Edit Source Expression functionality is limited with regards to Restricted Character handling Content (please ensure you mask any confi…
-
Using encrypted key pair authentication to connect to Snowflake through integration agentSummary: We are trying to connect to Snowflake using a JDBC driver through integration agent. I've added the following to my .ini file: [AGENT_JDBC_CONNECTIONS] snowflak…
-
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… -
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…
-
Moved: Unable to delete Shared entity from Oracle FCCSThis discussion has been moved.
-
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 …
-
How Do I Export Line Item Details from Current Provision?Summary: I need to be able to export the breakdown of figures on the Current Provision within the Line Item Details function. Is there a way to export these in bulk usin…