Category 161
Discussion List
-
New OCI console - how to check the EPM Cloud application statusesSummary: Content (please ensure you mask any confidential information): Hi all, Can anyone please tell me where the Service: EPM Status dashboard window has disappeared … -
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… -
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…Debbie Schwind 1 view 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
What hampers performance of DLR (data load rule in data exchange)Summary: What hampers performance of DLR (data load rule in data exchange), there are only 6 rows of data.. but it takes 30 mins to push the data Content (please ensure …Subhojyoti Chakraborty 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data Integration can only select first 6 target Plan typesSummary: We have a Freeform application with 8 Plan Types. When creating a new data integration to load from a file we can only see the first 6 of them in the target Cub… -
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…JyotiSharma 61 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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…Subhojyoti Chakraborty 32 views 13 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
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…Subhojyoti Chakraborty 11 views 3 comments 0 points Most recent by Subhojyoti Chakraborty EPM Platform and Freeform
-
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…Partha Sikdar 11 views 3 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
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…
-
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…Ron Reiley-Oracle 42 views 3 comments 0 points Most recent by J Thomas-Oracle EPM Platform and Freeform -
Unable to delete Shared entity from Oracle FCCSSummary: Hi All, In my project we are trying to delete few shared entities (from alternate hierarchies) from Oracle FCCS application. However FCCS is giving consolidatio…Himanshu Saxena 34 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…Raj N 12 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
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…bpepper 65 views 1 comment 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
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…Amarnath_Kothapalli 25 views 3 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Smart View retrievals are tremendously slow in 25.100Summary: New & existing workbook, sheets, Ad-hoc retrievals are tremendously slow in 25.100, Any known issue or anyone is encountering this? Content (please ensure you m…
-
Identity Domain change of EPM instance OCI Gen2Summary: Fusion EPM OCI Gen2 application (SWP) is under default Identity Domain (OracleIdentityCloudService). Customer wants to move the instance to one of the existing …
-
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 - Your organization's policies may require you …Vijay Ramani VJ 26 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
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 3 views 1 comment 0 points Most recent by Abhinav Jain-Oracle EPM Platform and Freeform
-
Is There Any Rest Or Soap Web Services To get Error Log Files for FSM Import Using OICSummary: I am trying to get error logs for FSM package using OIC How to automate setup data load in Fusion Cloud ERP system | by Vishal Palakurthi | Medium using these l… -
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…
-
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…
-
Please advise on how to extract Data Management Workbench data before Logic Group logics are appliedSummary: We have a process to extract Data Management workbench data (using SQL query) for all the locations for any specific period. Our process is working fine. Genera…
-
Being logged out of EPM when using Nav flows with ReportsWithin the context of EPM Planning Navigation Flows, if we navigate away from a tab with a Report in it, we are being logged out of EPM. I have tested this in the test e…
-
Form 1.0 vs 2.0 - Different Behavior on Expanding MemberSummary: Expanding first column also expands 2nd column on form 2.0 Content: I have more than one columns on rows and start with members collapsed. Whenever I open form …Vijay Mahantesh-Oracle 92 views 6 comments 0 points Most recent by Sara_Nordea EPM Platform and Freeform -
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…
-
How to setup SSO for EPMSummary: Any guidance on how to setup SSO for EPM? We also just moved to OC2. Content (please ensure you mask any confidential information): Version (include the version…