Data Integration
Discussion List
-
Can you drill through to multiple currencies?Summary: We have two main reporting currencies that are users leverage, USD_Reporting and EUR_Reporting. I have enabled dill through data back for both currencies, howev… -
How to transform (not map) the Source-Entity column based on another dimensionSummary: I'm trying to find a way to transform the Source-Entity based on another dimension, so that the result can still be mapped after. Content (required): Let's say …
-
EPM 22.04 Data Management JSONObject["Consol"] not found.Summary: EPM 22.04 introduced a bug when integrating FCCS with Planning. When calling a Data Management Extract -> JSONObject["Consol"] not found. There is no such chang…User_2025-03-07-20-48-43-319 81 views 8 comments 0 points Most recent by SureshM-Oracle EPM Platform and Freeform
-
Data Management Range Mapping to Wildcards, possible?Hi All! Is there any way we can have the mapping below with Sql script? Range from 92??-???? to 933?-???? mapped to 92??_???? to 933?_???? Thank you -
automate start period and end period input when executing DLR in data managementSummary: Content (required): We are currently working on a custom query integration to extract data from a BI report in the ERP side using data management in ARCS. We al…
-
Data Management - Lookup dimension in a metadata load?Is there a way to use a lookup dimension as part of a metadata load? When we tried to set one up for our Projects dimension. It only allowed "Generic" dimension (aka met…Peter Joelson 42 views 3 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
How frequently can we clear the 'Data' and 'Logs' folder under application folder for EPMAgent?Summary: Will it affect anything if I delete all the files under 'Data' and 'Logs' folder monthly? Content (required): EPM agent Version (include the version you are usi… -
Data Load Rule with Export Mode is Loading only One Record instead of Two in Data ManagementSummary: We have an integration to load Oracle GL data to Planning Cloud. I came across an issue in Data Management that out of two records for a statistical account onl…Ija Vidaurri 121 views 5 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform -
ERP Cloud BIP Report to EPBCS for loading Account dimension keeps failing!Hi All, I have created a BIP report in ERP Cloud, and while running the integration in data management it keeps failing with the following error: 2022-04-06 09:33:52,266…yanni vossos 135 views 1 comment 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Best practices for updating EPM Integration Agent on Linux platformSummary: Hello experts, I'm looking for best practices of updating EPM Integration Agent on Linux Platform. Content: What are the recommendations to update Integration A…Ganesh Golla 44 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
How to check EPM Agent Run status on Linux machineSummary: We have configured the EPM Agent in asynchronous mode on OCI box (Linux). We need to monitor Agent run status. Content (required): To Monitor Agent status, we a…
-
EPM Integration Agent Unable to WriteBackSummary: Am trying to Writeback Forecast data from PBCS to On-premise DB and getting error which i am not able to fix. Content (required): Trying to export data from PBC…Amith Kumar Madisetty 41 views 12 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform -
Integration Agent two different ARCS pods.Hi all, We need to clone our ARCS prod POD to test POD. Both instances have configured a separate integration agent. What will happen after the cloning to the test envir…yanni vossos 11 views 1 comment 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Integration agent two different FCCS pods possible?Hi all, As we migrating our FCCS application to enterprise license POD DSO, is it possible to connect to an existing integration agent from the old POD? Thank you yannis
-
Why Run Integration role doesn't allow user to browse and select file in DLR for data load uploadSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Exporting data from PCMCS with DM how do I round the output values to 2 decimal placesSummary round exported values from PCMCS to export fileContent There does not appear to be a way to export values from PCMCS with DM, so that the values are rounded to 2…Dawn Watson 102 views 7 comments 1 point Most recent by User_2025-02-05-23-55-14-602 EPM Platform and Freeform -
"Setting Up Passwords that Do not Expire" in the Mar-21 updateContent Hi -- Trying to find some more information around a topic I saw in the Mar-21 release notes, specifically for a new topic in the EPM Cloud Operations Guide for :… -
Parameters for Drill-QuerySummary: I'm looking for Parameters for drill-query, e.g. Source-Entity, Source-PeriodKey, etc Content (required): Hi all, I'm just trying to build a drill-query for EPM…User_2025-02-03-23-55-06-250 11 views 2 comments 0 points Most recent by User_2025-02-03-23-55-06-250 EPM Platform and Freeform -
Issues with $START_PERIODKEY[YYYY]$: giving wrong yearSummary: I've implemented an integration, where I'm trying to leverage $START_PERIODKEY[YYYY]$ unfortunately for Dec-20 it gives me year 2021 but I would have expected 2…User_2025-02-03-23-55-06-250 22 views 3 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Data Integration Event Based Business Rules - Warnings when no data to loadSummary Data Integration Event Based Business Rules - Warnings when no data to loadContent Hello, We have configured a Clear to run "Before Load" using Data Integration …
-
Migrate On-prem Essbase Data to Oracle EPM CloudContent we have a use case to migrate 1.8 Million or more records from on-premise Hyperion Essbase to Oracle EPM - PBCS cloud SaaS Application. We see limitation on FDME… -
Integrating Oracle Cloud Enterprise Performance Management with JD Edwards EnterpriseOneSummary Tutorial explaining how to connect JD Edwards EnterpriseOne with Oracle Cloud EPM.Content The JD Edwards team has just released a tutorial that explains how to l…Mike Casey-Oracle 42 views 2 comments 1 point Most recent by Mike Casey-Oracle EPM Platform and Freeform -
EPM Agent: How to configure it with a floating IPContent Hi all we are starting to configure the EPM agent for the first time, but as we have a floating / virtual IP we are not able to complete the configuration. Is th… -
LOAD SAP GL DATA (S4HANA) TO EPM CLOUD (PBCS)Content Hello Everyone, I have a requirement wherein I have to pull SAP (S4HANA) GL Data to EPM Cloud (PBCS) using Oracle Data Management. Please guide me with pre-requi…
-
Set last process ID using epmautomateSummary How to set last process ID to 0 using epmautomateContent Hi everyone, We are implementing Incremental Data load Rule and we are trying to run it using epmautomat…User_2025-02-05-00-34-04-259 63 views 1 comment 0 points Most recent by Omar Shubeilat. EPM Platform and Freeform
-
Data Management Using Location and Rule Integration Options when defining POV for Business RulesContent In FDMEE on-premise when defining calculation scripts to be executed as part of the integration setup we are able to select Point of View values from Location an…Dinesh Chand 24 views 2 comments 0 points Most recent by Payal Kapoor-72335 EPM Platform and Freeform