Data Export / Import
Discussion List
-
What is the best Practice for exporting metadata to Fusion from EDMCS?We need to export incremental metadata updates to Fusion from EDMCS. Creating extract in EDMCS will work for this scenario or export option from EDMCS will help in this …Subramanian Karunamoorthi 31 views 7 comments 0 points Most recent by Subramanian Karunamoorthi Enterprise Data Management -
Load master data from Oracle EDM to Non-Oracle HCMSummary: Hi All, Could you please someone tell us, if we are loading master data from Oracle EDMCS to HCM which is not OOB, how do we automate the process end to end? Th… -
How to get a list of descendant nodes similar to ancestor list?Summary: How to get a list of descendant nodes similar to ancestor list? Content (please ensure you mask any confidential information): Version (include the version you …Neethu Durgaram 1 view 1 comment 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
In EPBCS, Deleted member showing up calc manager rule. Doesnt exist in Smartview or planning.Summary: In EPBCS, I have deleted a member and refreshed the Database. I confirmed that the member is not available in Smartview. . However , when I try to run the calc … -
How can you tell which properties are exported to FCGL application?Summary: We had some custom properties built out during implementation for some of our viewpoints in our FCGL application. What is an easy way to tell by looking in EDM …Lea Janitz 12 views 1 comment 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management -
EDM Extracts to AWS ServerSummary: I have a requirement from client to send EDM Extracts to AWS Server. What's the best possible way to achieve this? Content (please ensure you mask any confident… -
Base and current trees in EDMCSGL application for each segment have Base and current trees but in EDMCS do we need to maintain both base and current trees, if we not maintain base in EDMCS what is imp…Virupaksha Reddy 21 views 4 comments 0 points Most recent by Stuart.Porad Enterprise Data Management -
EDMCS viewpoint download, dates are populated in general format instead of date formatSummary: Dates are coming up in general format, instead of date format during viewpoint download, which is a concern for business users. Content (please ensure you mask … -
Can Hash values for a combination be sent to Oracle Control Budget from EPMSummary: We are looking for an advise to see if EPM has ability to send out Hashed Combinations to Oracle Control budget and is it acceptable at the Oracle Control budge…DharaniR 11 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform -
Why changes on new custom property not reflecting in FCGL?Summary: I have added a new custom property in EDMCS and added the same to the value extract for FCGL. Created the same property in FCGL and ran the integration. Integra…Cyril_Joseph 32 views 6 comments 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management -
Use Case Possible? Want to use a data file to only load new membersI'm exploring the feasibility of using EDM to manage dimension updates in Planning, and I'm hoping someone can clarify if this is possible. Here’s the scenario: We have … -
Please provide clarity for Oracle enterprise data management's capabilitiesSummary: Please provide details for Oracle enterprise data management's capabilities to integrate with other systems (specifically Azure). Specifically, if its possible …Owenker 21 views 1 comment 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
EDMCS to GL import value set valueSummary: We are using EDMCS to integrate with Oracle Financials ERP for COA management. We are using Oracle's native integration to sync the COA from EDM to Oracle Finan… -
Bulk Upload customers via spreadsheetWhat is logic for the person number in contact sheet? Can we repeat the person number if person first and last are the same for other customers sites or we have to assig…MohsinRehman 11 views 1 comment 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management -
member names with commas in export are getting double quotesSummary: Hi, I have a member name with a comma and when I export and import to EPBCS app, it is having issue with double quotes. How can I ignore these double quotes on … -
Can I rename a parent account in an alternate structureSummary: Can I rename a parent account in an alternate structure if it is part of the EDMCS to Financial Cloud GL export load? If so, will the newly renamed node be crea…John Burton 23 views 3 comments 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management -
Metadata Integration/sync Fusion ERP to EDMCSSummary: In essence, we are looking for the best (most simple) way to transfer our newly created segments from ERP to EDMCS. For this we are currently working with EPMAu…Pieter-Jan Vandendriessche 21 views 2 comments 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
Is there a way to restrict access to extracts?Summary: We have a business team that we built an extract for off of a viewpoint that has several other extracts used in OIC integrations. We want the business team to p…John Burton 21 views 1 comment 1 point Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
Specify 'From' & 'To' dates while executing Incremental Extract from EPMAutomateSummary: Hello All, We have an incremental extract in which we have specified 'From' & 'To' date. This Extract profile, we need to execute from a batch script using EPMA…Suyog Mandloi 21 views 2 comments 3 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
ADF_FACES-60097 ErrorSummary: How would we resolve this error? It happens on worklist. ADF_FACES-60097 Error Content (please ensure you mask any confidential information): Version (include t… -
Inherited value missing from extractSummary: Four records out of thousands in an extract have an inherited property showing no value ("") when the value looks correct in the viewpoint. Content (please ensu… -
Is there a way to extract CoA values in a flat structure (non-hierarchical) from EDMCS?Summary: Our Planning CoA is currently maintained in EDCMS in a hierarchical structure. Is there a way to extract CoA values in a flat structure (non-hierarchical) from …Alida Parreno 42 views 3 comments 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
Is there a way to get # children for implicit shared nodes as zero?Summary: I want to have an extract where # Children count to be zero for implicit shared nodes. I tried to create a property where for shared nodes ,the value would be z… -
How to Move a node in EDMCS if the Merge Import file has a different parentSummary: How to Move a node from One Parent to another based on the Import File while using Merge Import in EDMCS Content (please ensure you mask any confidential inform…Jui Chatterjee 42 views 1 comment 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management -
EDMCS FCGL Application :The import did not complete because an unexpected error occurred.Summary: When I am trying to Import .zip file containing both GlSegmentHierInterface.csv and GlSegmentValuesInterface.csv to a dimension, Import is getting failed with b…Pooja Mohan Bhovi 91 views 12 comments 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management -
Is it possible to connect EDMCS with Autonomous Database using Oauth 2 or how to setup Baisc AuthWhat is the process/setup to connect autonomous database with EDMCS to pull the metadata in EDMCS, as in EDMCS it accepts only basic auth while atonomous database is usi…Abdul.Raheem1997 31 views 2 comments 0 points Most recent by AbdulRaheemsnb1997 Enterprise Data Management -
Is there a way to create a fixed width Extract from EDM?Summary: I am working on an integration from EDM to PSFT and I need to format the extracts with fixed width for each column in the output. Is there a method or option in…