Data Integration
Discussion List
-
FCCS Data management Replace mode creates opening balance offsetContent We use data management to load data in FCC. We load Life to date Balances. We use YTD input, Closing Balance input for ( B/S accounts) and Mvmts Net income for P…Arindam Roy-244870 71 views 2 comments 1 point Most recent by Arindam Roy-244870 Financial Consolidation and Close -
Extracting large amounts of base data from FCCSSummary Requesting best method for extracting large amount of base level data from FCCSContent What is the best method of extracting large amounts of base data from FCCS…MKLC 68 views 3 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Loading YTD Revenue/Expense Values to Closing Balance Input MovementSummary Loading YTD Revenue/Expense Values to Closing Balance Input MovementContent When uploading Revenue/Expense Values to FCCS_ClosingBalance_Input Movement through D…
-
Enable Drill Region Gives ErrorSummary Enable Drill Region Gives ErrorContent Hey Everyone, Trying to enable Drill Region for FCCS Application in Data Management. I keep getting error. Has anyone face… -
FCCS - Blocking Data Loading for Future PeriodsSummary FCCS - Blocking Data Loading for Future PeriodsContent We are looking for a way to block trial balance loading through Data Management for future periods. Should…
-
Cannot extract data from Dynamic Calc members?Summary Trying to extract data from Dynamic Calc members but cannotContent Hi, I am trying to extract data for six lines in the Account dimension which are Dynamic Calc.… -
Extract journal data with the identification of the journal label using Data ManagementSummary Extract journal data with the identification of the journal label using Data ManagementContent Hello, Does anyone know if it is possible, with Data Management, e…Carolina Silva 35 views 6 comments 0 points Most recent by Klaus Andersen Financial Consolidation and Close
-
How best do I create a Proforma scenario in FCCS?Summary A client wishes to have an "adjusted" Actual scenario that adds historical data from acquisitionsContent Since we would be entering new data into the past, this …JoachimB 39 views 3 comments 0 points Most recent by Lynda Gastaldello-183189 Financial Consolidation and Close -
How to connect to FCCS using REST API ?Summary Requirement is to connect to FCCS data for post elimination with MS P-BIContent Hi There, I have an requirement to connect to the FCCS cubes to pull out financia… -
Reference Attribute values in Mapping ScriptSummary Reference Attribute values in Mapping ScriptContent Loading GL balances data using a file into FCCS. I want to flip the sign of Liability (L), Owner's Equity (O)…
-
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 92 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… -
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 53 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…Ernest Garcia 104 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 49 views 7 comments 0 points Most recent by Jeffry Kadarusman Financial Consolidation and Close
-
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
-
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
-
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 55 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
-
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…