Data Integration
Discussion List
-
Is it possible to use OAuth 2 in pod-to-pod integrations?Hello, I am wondering if it is possible to use OAuth 2 when setting up pod-to-pod integrations in Data Management? Documentation only shows the ability to setup basic us… -
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 … -
Data Management file to FCCS - Power users unable to export the data.Hello, We have a group of people as Power Users in FCCS, even though their access to the dimension is fine, while trying to load the file data in Data Management (DM), t… -
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…
-
Connection between BI tool- and Data Lake platform with Oracle EPM podsHi All, Is there any way we can connect Oracle EPM cloud based applications to Power BI? Also, can they provide different ways to load data from Oracle EPM apps to Data … -
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… -
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…
-
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…
-
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… -
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…
-
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… -
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… -
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…
-
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… -
"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…
-
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…
-
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 …
-
EPM Integration Agent - "EPM_AGENT_INBOX" Parameter error when starting as a serviceContent Hi -- We just downloaded the latest agent as of 5/27 from Data Exchange. We first tested the agent connectivity using the non-service method and everything worke…