Data Integration
Discussion List
-
[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 61 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_2025-02-06-06-07-43-641 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 31 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…User_2025-02-05-23-55-14-602 42 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 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 User_2025-02-05-23-55-14-602 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… -
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 35 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…
-
FCCS YTD Input - Not Calculating PeriodicContent Hi All, I am loading Year to Date amounts for a client using the YTD Input functionality to calculate the periodic balances. The calculation doesn't seem to be t…Preston Oakes 71 views 3 comments 0 points Most recent by Preston Oakes Financial Consolidation and Close -
Historical Rate disappears after data reload from DM using the replace modeSummary Historical Rate disappears after data reload from DM using the replace modeContent Hi all We are experiencing a strange behaviour from FCCS to which we would lik…
-
Scripting options in cloud Data ManagementContent Hi Experts, We are migrating HFM to FCCS. Client has FDMEE for integration in the on premise world with tons of customizations using custom and event scripts. Wh…Payal Kapoor-72335 39 views 5 comments 0 points Most recent by Payal Kapoor-72335 Financial Consolidation and Close -
How to configure data manager file base load to periodicContent I cannot find where in the data management setup you can set the view mode to periodic for a file based import so that it is treated as periodic in FCCS. FCCS au…User_2025-02-05-23-45-21-053 45 views 2 comments 0 points Most recent by User_2025-02-05-23-45-21-053 Financial Consolidation and Close
-
FCCS Application (Data Management) - Source System > Configure Source Connection (WEB Service URL ChSummary FCCS Application (Data Management) - Source System > Configure Source Connection (WEB Service URL Changed)Content Hi Experts, It has been observed early this wee…
-
Drill through from FCCS to Oracle Fusion GL not workingContent We opened SR SR 3-25410502941 21 days ago with errors using the drill through from FCCS to Oracle Fusion GL. After loading the GL data into FCCS via DM, I click …scgonz 23 views 1 comment 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close