Data Integration
Discussion List
-
Push Budget from EPM Planning to PPMSummary: Push Budget from EPM Planning to PPM options Content (required): Looking for best practice recommendations. This is a non-Planning Module implementation Groovy … -
Netwsuite integration fails when using System – Initialization with PBCS workbooksSummary: Content (required): We are using NetSuite Planning and Budgeting (NSPB) (built on Oracle Hyperion EPM technology). To connect it to NetSuite, in NetSuite we hav… -
Masking sensitive dataSummary: How do i mask some data (salary and wages) in DM or Planning? Content (required): I have a requirement to ensure none, including administrators should not be ab… -
EPM Integration Agent Stop Working from YesterdaySummary: EPM Integration Agent Stop Working from Yesterday Content (required): EPM Integration Agent Stop Working from Yesterday. I have checked the certification is sti…
-
How to use a semicolon as a character in a source expression without breaking everytingSummary: When using a semicolon within a source expression it's interpreted as a separator between stacked import format expressions and breaks up the expression, result…
-
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 84 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 41 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 132 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 45 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 43 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 105 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 21 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 43 views 2 comments 1 point Most recent by Mike Casey-Oracle EPM Platform and Freeform