Data Export / Import
Discussion List
-
Export Dimension or incremental extractSummary: Export Dimension will give the full export and extract will give the delta in the metadata update. We want to have the process automated between EDMCS and EPM a…Subramanian Karunamoorthi 31 views 6 comments 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management -
Oracle GL CVR and Enterprise Data ManagementSummary: Oracle General Ledger have Cross Validation Rule. We wanted to check if in Enterprise Data Management we can store our Cross Validation Rule Master of Oracle Ge…Vipul_vipul 73 views 4 comments 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management -
EDMCS REST API (incrementalExport) is not returning dataSummary: We are not able to export incremental dimension changes from EDMCS using REST API : "/epm/rest/v1/dimensions/byName/incrementalExport" Content (please ensure yo…Sunil Yerramsetti 41 views 7 comments 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management
-
Ability to exclude implicit shared nodes from a Generational extractSummary: Need to exclude implicit shared nodes from a Generational extract Content (please ensure you mask any confidential information): We have a requirement for creat…
-
How to check Request Items in Merge Import if more than 20,000Hi, It seems EDMCS is generating more than 20,000 Request Items in Merge Import where in when I compare the exising Dimension Data with the Merge Import File being loade…Jui Chatterjee 31 views 6 comments 0 points Most recent by Jui Chatterjee Enterprise Data Management
-
How to load HFM data with Year and Period in multiple rows to FCC ?Summary: I’m trying to figure out how I can load data from HFM to FCC. Content (please ensure you mask any confidential information): The HFM extract comes in this forma… -
Deleting the system members in EDMCSSummary: Will it be possible to remove the system inbuilt hierarchies and keep only the required hierarchies in EDMCS? Will it be a good practice? Appreciate any inputs.…Subramanian Karunamoorthi 11 views 3 comments 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management
-
Does the sensitivity of an excel file matter for a request load?Hello, I downloaded 2 identical Company Maintenance files out of EDMCS. One of the excel files was marked with a sensitivity of Internal and the other was marked with a …
-
Debits and Credits are in separate columns. How do you load a flat file in this case?Summary: We have a client that uses Quickbooks. The flat file that is being provided for load into Data Integration has a column for debits and a column for credits. Wha…
-
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 11 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 22 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 22 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