Data Integration
Discussion List
-
File based load that works will start failing if database isn't refreshedContent Hi. Wanted to see if something is common behavior or not. Please comment if you're seeing or not seeing this behavior (or you know what's going on). In all cases…ericerikson 25 views 4 comments 0 points Most recent by ericerikson Financial Consolidation and Close -
Data migration from Prod to TestSummary Getting warning message 'Essbase data import is only supported during create application'.Content I am trying to copy data from Production to Test instance by ta…Hari Nagumalli - Oracle EPM-Oracle 110 views 3 comments 0 points Most recent by Vasantha Kumar Raman Financial Consolidation and Close -
Data Management - Download Source FileSummary Data Management - Download Source FileContent Hi All, there is a short problem in "Data Management" section. From Data Management (Workbech section) we are not a…Antonio Barbaro 38 views 3 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
DM with FCCS: Too many objects match the primary key oracle.jbo.keyContent Hi all While trying to create 4 different cloud connections for the same user under Data management for FCCS, we have this error: Too many objects match the prim… -
Update Dimension Causing the PCMCS Instance to go down and unresponsiveContent Hi Everyone, Please can i request some one to share the best practices to update dimension into PCMCS. Currently, we are executing Rest API scripts to update dim…Parmit Choudhury-Deloitte 27 views 4 comments 1 point Most recent by Alecs Profitability and Cost Management -
Data Management Export from FCCS - two columns of amountsSummary Output of values in two columns (Amount, Quantity) - Depending on the accountContent Does anyone have an idea how I can export the amounts to two different colum…Bjoern Schumacher 63 views 5 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
Extracting data with Data Management - Two header lines requiredSummary data export file with two headlines requiredContent The system to be supplied with data from FCCS needs two header lines. The first header consists solely of 1;2…Bjoern Schumacher 45 views 2 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
Substitution Variables in Data Exchange when Integrating with On-Premise EBS when utilizing EPM InteSummary Can a substitution variable be utilized in a Data Integration->Option->Filters for Ledger Name and Period when utilizing EPM Integration AgentContent We have con…User_2025-01-28-16-03-29-902 129 views 1 comment 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close -
Options for One to Many in FCCSSummary Options to Migrate One to ManyContent Hello all, have a client that performs a one to many allocation of gl balances. However, not sure what option to use. 1) Da…mhylton 28 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
DM - Mapping file is empty for only one dimensionContent Hello, I am using data management to integrate data. Usually I export the mappings to Excel file, setting the mappings and then import the file. However, now whe…Carolina Silva 32 views 1 comment 0 points Most recent by James Liaskos Financial Consolidation and Close
-
DM - Mapping accounts according sum valueContent Hello, Does anyone know if it is possible, in Data Management, mapping members according the sum of the data? I need to create the following mapping: If the sum …Carolina Silva 46 views 7 comments 0 points Most recent by Jeffry Kadarusman Financial Consolidation and Close
-
Integration Agent with PCMCSSummary Can we use integration agent with PCMCSContent In Data Management, we have an option to choose Data Source -> On Premise Database very much like Planning but I d…User_3HEOY 26 views 3 comments 0 points Most recent by Mike Casey-Oracle Profitability and Cost Management
-
Mapping members - PerformanceContent Hello, Anyone knows if there are any performance impact on the member mapping (one by one) or through a group of members, mapping to a single member? Eg: - Mappi…Carolina Silva 36 views 3 comments 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close
-
Data Managment (DM)ExtractSummary We need to generate a extract from FCCS using DM and can see for few of dimesnions we are unable to extract Parent MembersContent We are trying to extract the da…user13680091 43 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Change sign not workingSummary Account mapping change sign not workingContent I have created a general mapping for the accounts hierarchy. Source data has revenue, liabilities and equity as cr…User_2025-02-05-23-45-21-053 22 views 4 comments 0 points Most recent by Denitza Krasteva-Oracle Tax Reporting (Direct Tax)
-
Drill through functionality not workingSummary Unable to acess data in Fusion ERP vide drill through functionalityContent Have configured the source system with following drill through URL but it is not fetch…TarunG-Oracle 30 views 1 comment 0 points Most recent by Denitza Krasteva-Oracle Tax Reporting (Direct Tax) -
How to change default load options in Data Integration screen?Summary When loading data Export mode should be replace instead of No Export; Period Dec-30Content Hi, when we click on Data Exchange, we get the Data Integration screen…Joost Mellegers 38 views 4 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
Data Management missing period mappingSummary Created test pod, but the period mappings were not created in the test pod.Content Sorry, did not add more to this. I created an SR as well. I have periods in TR…
-
Valid intersection not affect the admins !!Content Hello, I configured a valid intersection rule for ICP transactions that specific account must come with ICP, however when users load the data through data manage…Hussein Mahmoud 52 views 1 comment 0 points Most recent by Joost Mellegers Financial Consolidation and Close -
Mapping Export Button DisabledSummary Mapping Export Button DisabledContent I need to export a mapping definition in Data Management, but the Export and Import buttons are disabled. Can anyone help m…Carlos Amaral 42 views 12 comments 0 points Most recent by Carlos Amaral Financial Consolidation and Close
-
Can we change the default value in export mode?Summary We would like to change default value in export mode from merge to replace when user execute data road rule.Content customer have default value - replace on thei…Quincy Chen 26 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Importing MetadataSummary Importing MetadataContent Hello : Maybe this is a very basic question. I have the EBS Chart of Accounts information from EBS that I need to populate into FCC. 1.…Martin Kinovisques-110450 41 views 7 comments 0 points Most recent by DariaM Financial Consolidation and Close
-
Movement dimension setup for imported Trial Balance dataSummary Custom movement dimension requirements for TB data loadContent 1. Should the movement hierarchy for income statement and balance sheet be customised into similar…User_2025-02-05-23-45-21-053 44 views 1 comment 0 points Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax)
-
Using Integration Agent to load data from Oracle EBS to FCCSSummary Using Integration Agent to load data from Oracle EBS to FCCSContent Hi All, greetings. I was just wondering if any of you have used EPM Integration Agent to load…
-
Usage of Enable Application EPM Automate Command and REST APIContent Hi Experts, I came across epmautomate enableapp command and Enable File-Based Application REST API. epmautomate enableapp APPLICATION_NAME REST Resource POST /ep…Parmit Choudhury-Deloitte 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Data Protection option in Data Management?Summary Is it possible to replace data in one Multi-GAAP member and leave the other Multi-GAAP members?Content Hi, we load with replace csv files to a FCC application to…Joost Mellegers 57 views 3 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Rest Service API Timeouts when performance testing future periodsSummary OFC loads fail in DM when performance testing more than 5 months in the futureContent We are performance testing FCCS 4D application and have seen dramatic impro…Brian Robinson 12 views 8 comments 0 points Most recent by Brian Robinson Financial Consolidation and Close
-
Running a Consolidation Rule in automatic after loading data from Data ManagementContent Hello All, I would like to know if it is possible run a consolidation rule in automatic from Data Management. At the moment, Users run manually the Consollidatio…Gianluca Natili 57 views 3 comments 0 points Most recent by Hari Jetti Financial Consolidation and Close