Data Export / Import
Discussion List
-
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 31 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 21 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 41 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 41 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… -
ability to add schema prefix for EBS GL Balance AdapterSummary: We have created a custom schema SVC_HYPERION2EBS in Oracle EBS and have provided grants to the Custom schema to access all the required tables for the EBS GL Ba… -
Date property type for Financial Cloud General LedgerSummary Does anyone know if Date property type will be added to Descriptive flexfield values for a Financials Cloud General Ledger application? I see the March 25 update…Jason Rausch 11 views 1 comment 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management -
Renaming a Member in EDMCS and sending to EPM Planning cubeSummary: Renaming a member. We tested this by renaming a base level member in EDM, sending the txt file to the PLAN_PROV cube with the thought that it could rename the m… -
Viewpoint Extract Expression Builder: Extract Elements with Defined Value (ignore inherited values)Summary: Defining a Viewpoint Extract for Non-Inherited Properties. I am using a property in a viewpoint that has inheritance enabled. I would like to define an extract …Andreas Otto 11 views 1 comment 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management