Data Integration
Discussion List
-
FCCS DSO no direct integration to ARCS in data management?Hi all, We need to integrate data from FCCS with Account Reconciliation, however there is no target type of ARCS in data management. Is there a way to integrate directly?yanni vossos 121 views 2 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Error loading YTD trial balance file into FCCS.Summary: We are trying to load YTD Trial balance file into FCCS. This file was used to load into HFM and now we are trying to load it into FCCS. When loading under YTD_I…Zenithz 62 views 8 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close -
FCC Task Manger Integration of Reporting Packages from Narrative ReportingSummary: How to integrate in FCC Task Manger as a Basic Task a Reporting Package from Narrative Reporting? Content (required): Hi all, what is the best practice/ are det… -
'Check' Function in Data Management giving error if we use alternate hierarchy for Entity in FCCSSummary: Im using 'Check' feature in Data Management (4th fish in Import-Validate-Export-Check ) 'Check' is giving me error if I use alternate hierarchy for entity dimen…Srinivas Hindupur-Oracle 51 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Local and Reporting FX data import rather than Calculation in FCC - what is best practise?Summary: What is best practice for FX ledgers, pull from ERP or re-calculate? Content (required): A client is using SAP erp and has multiple ledgers with local and repor…Lesa Muir-175186 41 views 6 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
Can you connect Oracle ERP to Repository / Reporting Web Studio?Summary: Client is trying to create an automated data load reconciliation report at hash totals. As the DM cannot extract data at dynamic calc members, we are looking in…Ryan Heyvaert 22 views 5 comments 0 points Most recent by Al Marciante-Oracle Financial Consolidation and Close
-
What member (movement) do I load my first ever Trial Balance to?Summary: First time user for consolidation. Struggle to find to get started with my first period. what member does this need to be loaded to? Content (required): My firs…Ilse De Vries - Sinube 51 views 7 comments 0 points Most recent by Kapil_Bankeraika Financial Consolidation and Close
-
FCCS default Period Mapping is not showing data managementSummary FCCS default Period Mapping is not showing data managementContent Hi All, We have created FCCS application with adjustment period(P13) and when we are trying to …SathyaSundaram Angappan 65 views 6 comments 1 point Most recent by User_CGD11 Financial Consolidation and Close
-
Migrate particular Data Integrations from Test to ProdSummary: Migrate particular Data Integrations from Test to Prod Content (required):I have created New data integrations in Data Exchange in FCCS Test Env. I would like t…Amit Agarwal-158816 41 views 1 comment 0 points Most recent by Matt Maurer Financial Consolidation and Close -
Guidance to Configure Data Management to Load Trial Balance Data for FCCSummary: Guidance to Configure Data Management to Load Trial Balance Data in FCC Content (required): We want to load Trial Balance (TB) Data for data being sourced from …Al_DuqueEstrada 51 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Load YTD data for BG accounts in JanuarySummary: Content (required): Hi guys, Is there any way of loading data YTD for balance accounts in January. We have tried several ways, but we can't find a proper one. W…Luli18 31 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close -
Trial balance with Multiple currenciesSummary: Content (required): Hi guys, Our client extracts from the ERP a trial balance with multiple currencies, and then, in Excel, they make the currency conversion. I…
-
[Data Integration] Using a dense dimension as the Source Dimension for multiple Target DimensionsHi everyone, I am trying to use a dense dimension (Account) as the source for multiple target dimensions in a data integration. This is in the context of a data extract …Matt Maurer 21 views 7 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close -
Does Data Management sum data for matching POV?Summary: Should Data Management sum data for multiple records that map to the same POV for FCC and Planning? Content (required): My latest FCC app does not behave this w…MrKellyGreen 65 views 2 comments 0 points Most recent by MrKellyGreen Financial Consolidation and Close -
Is it possible to get a separate period for the adjustment period?Is it possible to get a separate period for the adjustment period? Not merge it into an existing period. According to data loads in DM are driven by the period key, but …Sun Wei-Oracle 11 views 4 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
View Role for Data Load Rule and MappingContent In Data Management, is it possible to give a view role/security to a user so that he can only view Data Load Rule and Data Load Mapping? Any response will be hig…Nrupansh Joshi 43 views 3 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Drill THROUGH to source emptyContent Hello, I have arranged for a file to be uploaded to the application via Data Management. I also enabled the Drill region function and in fact after importing the…Alberto Parisella 23 views 7 comments 0 points Most recent by Ryan Li Financial Consolidation and Close -
FCCS's DM Workbench data disappeared after snapshot restoreSummary: FCCS's DM Workbench data disappeared after snapshot restore Content (required): We got to know that FCCS-DM Product has limitation of workbench data not being c…User_QER4O 21 views 1 comment 1 point Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Task Manager - Integration with WorkivaHi Experts, We are evaluating below integration options from Oracle Task Manager. Appreciate if you can share your views. Task integration with Data Exchange Option Task…Kotak Pramit 33 views 1 comment 0 points Most recent by Tom LeFebvre-Oracle Financial Consolidation and Close
-
FCCS Data Export CommandSummary FCCS Data Export CommandContent In recent past, FCCS Data Export Command was not supported in Calculation Manager but when creating a custom app in DM with filte…Narayanan S 42 views 1 comment 0 points Most recent by Narayanan S Financial Consolidation and Close -
Data Management and Data ExchangeSummary Data Management and Data ExchangeContent Hello, We have data management and data integration available in FCC. Most of the features are similar and I could see t…
-
Subtotal with rows in a source file FDMEEContent Hello to all, I'm setting up a mapping on FDMEE. I'm importing data from a file, the purchase cost field values of which are sorted in ascending order. I have …Alberto Parisella 27 views 1 comment 0 points Most recent by Narayanan S Financial Consolidation and Close
-
Separate an account string in Data ManagmentContent Many file exports have a concatenated account string such as 000-0000-00000-00 where each segment represents a different FCCS dimension. Is there any method for …
-
Resubmission of TB after loading STAT accountsContent Hi Team, We are following below data loading process as a standard load, However there can be a need of resubmission of Trial balance for some entities (In Repla…Kotak Pramit 20 views 2 comments 0 points Most recent by Kotak Pramit Financial Consolidation and Close
-
Cutting of leading characters in Data Management (before Mapping)Summary A source system extract will change and we will need to cut of the leading 4 characters (or change all mappings)Content Hi everyone, an extract from a source sys…
-
Data Integration - connection cloud to cloudContent Hi all Does Oracle support / facilitate Data Integration from Cloud to Cloud? I see that it is designed to pull data from on-premise to Cloud, but not Cloud to c…