Data Export / Import
Discussion List
-
Error while importing Entity dimension into FCCSummary: While importing Entity dimension to FCC I got error "Shared members must have Shared Data Storage for all cubes, member E_****" Content (please ensure you mask …KonradKo 35 views 9 comments 0 points Most recent by BBrocklesby-Oracle Financial Consolidation and Close -
Loadviewpoint and Loaddimensionviewpoint commands are not workingHi, We are trying to load a file into a viewpoint using epmautomate commands. As per the oracle document Commands at a Glance the 2 possible commands are Loadviewpoint a…Guntuka VenkataKrishna 21 views 6 comments 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management
-
Can Em Dash (long dash) be added to the invalid characters list for properties?Summary: We have a scenario where a property value contains an Em Dash, as opposed to a regular dash, and the Em Dash is not being recognized by a downstream system, whi…
-
Need to exclude line break, carriage return and tab in a property in EDM & send to EPBCS in extractSummary: EPBCS has a requirement wherein they want all the line breaks, carriage return and tabs in a property to be replaced with a space. They are using the extract ou…Anisha Mohanty-256661 34 views 4 comments 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management
-
Hierarchy Dates Not Considered During EDMCS Import from Fusion GL FBDISummary: While importing Fusion GL FBDI files into EDMCS, the Start Date and End Date properties are being derived from the Segment ValueSetValues interface, rather than…Gaddam Jagannath - Trinamix 22 views 3 comments 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management
-
how to create csv extract for formula property from EDMSummary: Create .csv file Extract from EDM Content (please ensure you mask any confidential information): The Property Formula creates issue in the extract file since it…
-
How to use Clear Shared Members dimension import option when importing from EDM into FCC?Summary: The Clear Shared Members option shows an error in FCC when importing dimension metadata from Enterprise Data Management (EDM) because we cannot perform any acti… -
How to remove special characters/ foreign keys from EDM ?We had a European symbol entered in the data due to the business user using a European keyboard this caused an error (Example "Â"). We are trying to find a way to enter …ChrisT99 21 views 1 comment 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management
-
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 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 trigger automation when new member added for any of the EPM apps in the EDMCS?We are scheduling the nightly jobs on daily basis for the new member addition from EDMCS to EPM apps through automation. We also need to have an option to trigger the au…Subramanian Karunamoorthi 32 views 1 comment 0 points Most recent by Josh Winters 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…