Data Export / Import
Discussion List
-
On FCCS Data Management, it fails to round the amount value to two decimal places for file exportI am trying to round the amount value of the file export in Data Management. I followed the suggested options in below page but still fails. Restricting Amount Value to … -
The BICC Database Lineage Mappings and View Objects excel documents include inactive datastores?We are reviewing our BICC datastore extracts and want to make sure we are not using any inactive datastores. The BICC Database Lineage Mappings and View Objects excel do…Holly Wells 21 views 1 comment 0 points Most recent by BBrocklesby-Oracle Reporting and Analytics for ERP
-
EDM Exports and Multiple Ledgers in the ERPSummary: Does EDM support multiple ledgers in one ERP instance? Content (please ensure you mask any confidential information): The client is establishing multiple ledger…Katrina Boyajian 31 views 4 comments 0 points Most recent by Katrina Boyajian Enterprise Data Management -
Manage COA MappingSummary Manage COA Mapping via EDMCSContent Is there any way in EDMCS that we can manage & export COA mapping between primary & secondary accounts to Finance GL? Thank Y…User_2025-01-28-04-44-52-981 107 views 10 comments 0 points Most recent by Brian Dandeneau Enterprise Data Management -
Laoding dimension metadata from EDM to FAHSummary: Trying to load the metadata from EDM to FAH need to know the process Content (please ensure you mask any confidential information): Trying to load the metadata …User_HXKPN 31 views 5 comments 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management
-
Custom file name for Fusion export in the Oracle EDMCSCan we keep custom file name when we export the metadata to Fusion from oracle EDMCS. At this point, based on the user Id logged in, it is concatenating user Id along wi…Subramanian Karunamoorthi 51 views 11 comments 0 points Most recent by RVohra Enterprise Data Management -
EDMCS Alias Uniqueness for EPBCSWhen we create a new member under particular parent and if the alias is duplicated among the siblings, then we are getting the error for the duplicate alias. In similar …Subramanian Karunamoorthi 21 views 5 comments 0 points Most recent by Subramanian Karunamoorthi Enterprise Data Management
-
How to import 2 hierarchies into 1 dimension?Hello everyone, I am familiarizing myself with EDMCS and have 1 question. In my ERP, I created 2 hierarchies for the valueset "Natural Account": So my question is How ca… -
How to Format Tree-Style Hierarchy Extract in EDMCS Without Repeating Ancestors?Hi everyone, I'm trying to replicate a tree-style hierarchy extract in Oracle EDMCS, where each node appears only once and is aligned to its respective generation level.…
-
How to change the system timestamp in EDMCS?Hello everyone, I am exporting data from EDMCS to EPBCS. However, I saw that the history timestamp is incorrect: How can I change this time to my timezone in EDMCS? Than…
-
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 71 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
-
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…