Data Export / Import
Discussion List
-
EDMCS to SFTP using OICSummary: Is there any way where EDMCS can place the extract file directly to the OIC SFTP folder using Rest API . Content (please ensure you mask any confidential inform…dilip9597 21 views 1 comment 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
EDMCSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
ERROR [AIF]: Invalid row : The number of columns in the file is less than minimum expected count.Hello Experts : I am getting the below error when we trigger the mapping file from OIC integration to FCC application. 2025-09-25 09:40:00,813 ERROR [AIF]: Invalid row :… -
EDMCS Export to Fusion GLWhile exporting segment data from EDMCS to fusion GL, I am seeing some misalignment between the data properties. Before exporting the Cost Center to Fusion GL from EDMCS… -
edmcs FCGL Integration Auto publishOnce the request is approved in EDMCS. is there any way to export the segment values from EDMCS to FCGL immediately via rest Api?(not scheduled process)dilip9597 21 views 1 comment 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
Template migration failed due to different patch on Test and Prod applicationsSummary: Template migration failed due to different patch on Test and Prod applications Content (please ensure you mask any confidential information): Taken the .json ex…Pooja.Bhovi 43 views 5 comments 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management -
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 22 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 110 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 23 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 74 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 …