Data Integration
Discussion List
-
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 -
[Data Integration] Trouble pulling ONLY adjustment period (P13) data from Oracle ERP Cloud into FCCHi everyone, I am trying to pull adjustment period (P13) data from Oracle ERP Cloud into FCC. However, when I do so, it also pulls Dec data. Does anyone know how to avoi…Matt Maurer 83 views 2 comments 0 points Most recent by Kapil_Bankeraika 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 45 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 53 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 64 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 35 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 21 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… -
Using Substitution Variables in Data Exchange FilesSummary Using Substitution Variables in Data Exchange FilesContent Hi- Is there a possibility to use substitution variable as a suffix in Data Exchange output files? We …Amit Agarwal-158816 37 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Deleting data in Data ManagementSummary Data was loaded in Data Management by mistake. We want to delete it before Exporting to FCCSVersion 21.06Roshni Mohan 36 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data management security - FCCSContent Hi Experts, Can we restrict users from upload of flat file in data management folder? Basically users should be able to load data from those file which are alrea…
-
Direct-connect or Integration between two domains for data/ metadata sharingSummary We have FCC in US2 and Planning in US6, is there a way we can establish connection between two.Content We have FCC in US2 and Planning in US6, is there a way we …YogeshKJain 9 views 2 comments 0 points Most recent by YogeshKJain Financial Consolidation and Close -
How to reload data that has been exported in Data ManagementContent Basically, I need to change the sign of data on some accounts that need to be changed from Expense to Revenue. I have exported the relevant data from FCCS to a f…Klaus Andersen 21 views 1 comment 0 points Most recent by Harshith Rao Financial Consolidation and Close -
FCCS: Data Management: is it possible to do multiple Period Mapping at once?Content Hi All I see that at the moment it is only possible to create Period mapping one row at the time. Is it possible to create several period mappings at once? I cou…