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… -
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…
-
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…
-
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…
-
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… -
Network Perimeter with IDCS - Issue with Clone and Groovy rulesSummary After setting network perimeters in IDCS, EPBCS cloning failContent Hello, we have just setup in our IDCS foundation primary instance network perimeters to allow…
-
Dedicated EPM Disaster Recovery standby environmentSummary Dedicated EPM Disaster Recovery standby environmentContent Hello - We are in process of evaluating if we should be configuring our own dedicated EPM DR standby e…
-
data for 2018 is missing in reportContent Hello after running integration data script for this month i missing all data for 2018 in TB report please advise Thanks Mahgoub -
Currency Conversion Type in the FBDI file load using direct integration to Oracle Cloud ERP GLContent Hi All, When posting allocation data to Cloud ERP using DIrect integration from PCMCS, we want to specify the Currency Conversion Type from the PCMCS DM applicat…
-
Rounding data to zero decimal precision when loading to Cloud ERP GL using Direct integrationContent Hi We have a ledger in Cloud ERP that was configured with zero decimal precision for business reasons. We wanted to round the debit and credit amounts to zero de…
-
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…