Data Integration
Discussion List
-
How can we remove shared entities from a Data Management extract?Summary: We need to generate a SOX control from Data Management. Content (required): The shared entities are duplicating the results. We have tried using mapping to filt…Michelle Wagner 62 views 7 comments 0 points Most recent by Michelle Wagner Financial Consolidation and Close -
FCCS: DM: Loaded data does not display is FCCS_YTD bu remains under FCCS_YTD_INPUTSummary: Content (required): Hi all A while back in FCCS we used to see data loaded and displayed always under FCCS_YTD_Input when we want it to display under FCCS_YTD. … -
Struggling with data extract/integration performance after enabling DSOWhile testing DSO in FCC, our integrations are taking much longer to run (5x to 10x longer). We have extracts/integrations that utilize the following: 1) Pulling upper-l…Matt Maurer 31 views 2 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close -
We have a rule to copy data from Income Statement Intercompany account to Balance Sheet IntercompanySummary: We have a rule in F10 to copy data from Income Statement Intercompany account to Balance Sheet Intercompany account and specific movement, the rule is working f…MRAO 51 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
Getting error in Data Integration between Fusion GL to FCCSSummary: We are getting below error in Data Integration between Fusion GL to FCCS Not all dimensions were specified Please let me know if anybody has faced this issue an…Ramesh Nayak 43 views 4 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Direct integration Planning to FCC - Change YTD default to PeriodicSummary: I have created a direct connection from a Planning app to FCC. I'm not able to get the View default change to save. Content (required): While I have been succes…Mats Ostberg 31 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
FCCS (EPM) Backup & AutomationSummary: We would like to find out if any of you all have been successful in automating FCCS daily backup Content (required): We have a requirement to hold up to 60 days…Rihan Jameel 73 views 7 comments 0 points Most recent by Rihan Jameel Financial Consolidation and Close -
How to connect Oracle EPM Cloud to SAP ERP S4 HANA CloudIs there a way to access the SAP S4 Hana Cloud directly to pull the data from ERP into the FCC?Bjoern Schumacher 391 views 1 comment 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
Help!! How to troubleshoot? Where can I find that webcast? What's New? Don't panic, it's all in hereI totally get it, the community can sometimes be overwhelming. A lot of great content is available, but where do I find it, what to look for, how do I search? Should I u…Michel Schoolenaar-Oracle 362 views 0 comments 12 points Started by Michel Schoolenaar-Oracle Financial Consolidation and Close -
How to connect Oracle EPM Cloud to SAP ERP S4 HANA CloudIs there a way to access the SAP S4 Hana Cloud directly to pull the data from ERP into the FCC?Bjoern Schumacher 41 views 2 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
Load Ownership data through Data Management or EDMContent Hi, We are looking for a solution to upload Ownership data through either Data Management or EDM integration. I know one of the potential option to automate the …Kotak Pramit 32 views 1 comment 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close -
Export YTD data in data management to file, errorHi all! How to export via data management YTD data to a file? My challenge is to load YTD data for the last month of the year 2021, to a newly created FCCS system from a… -
Data Management Location Security cannot make it work....Hi All, We have many locations in data management, and we need to give access to our regional controllers to load their ERP files to FCCS. I have enabled the Security by…yanni vossos 81 views 3 comments 0 points Most recent by LucaScarpa Financial Consolidation and Close
-
Need to have an automated process to export Journal Entries into a file or database.Summary: Need to have an automated process to export Journal Entries into a file or database. Content (required): In HFM we were able to extract Consolidation Journal En…Zenithz 71 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Management Exporting "Ghost" Amounts/Records for "FCCS_OpeningBalance" movement member !Hi All, I´m trying to export to a file opening balances for Actual Scenario and one period only. I can see the amount in smart view correctly, however when I check my ex…yanni vossos 21 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Cannot longer load data via Data Management due to new Approval PhasesSummary: After 22.03 FCC update, we are no longer able to load data via Data Management. After the 22.03 FCC update, we are no longer able to load data via Data Manageme…LucaScarpa 131 views 8 comments 0 points Most recent by Kumaresh Sankar-Oracle Financial Consolidation and Close
-
EPM Pod to Pod (FCC to FCC) integration issue after 22.04 updateSummary: Since this Monday, after the 22.04 update was applied, we are no longer able to import data from an FCC application. EPM pod to pod integration are not working …Krunal_Kapadia 111 views 10 comments 0 points Most recent by MrKellyGreen Financial Consolidation and Close -
Data Management: with invalid member, do the other records load?Just started seeing in an application where data is loaded to FCC with Data Management and there is an invalid member, that none of the data is loaded. In the past - and…ericerikson 31 views 1 comment 0 points Most recent by SureshM-Oracle Financial Consolidation and Close -
How have you Archived data out of FCCSSummary: Strategy to archive data out of FCCS so that we keep a rolling current 5 years. Content (required): We are looking for a strategy to archive and keep historic d…
-
Data Management->Data Load Workbench...import/validate fish is orange but 0 record imported.Summary: We are suddenly facing this issue with "Data Load Workbench"...it was working earlier. We are loading a CSV file having 1839 records. Data Management->Data Load…KV001 21 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Data Management - accumulate in file option??Summary: Data Managment mappings contain many to one mappings but only last line of each intersection loads Content (required): We are loading data via data management. …Nancy Ackerman 162 views 3 comments 1 point Most recent by Nancy Ackerman Financial Consolidation and Close -
How to Export Amount Overrides?Hi All, Is there a way I can export Amount Overrides for a couple of accounts, ICO, Entities all at the same time in USD input? I tried so far: 1) dataexport ODR (receiv…yanni vossos 51 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Handling YTD Trial balance load for Offline entities.Summary: We currently load YTD files into FCCS. We have an offline entity for which we load a separate Trial balance. Now we have actually merged the offline entity and …
-
Loading YTD balance sheet movements and closing balanceSummary: I currently have a client that is loading data from HFM. I have split my integration so that one data load rule loads the movements and a second loads the closi…
-
The specified member's dimension is not valid for this plan type: FCCS_DefaultGroup!Hi All, We have a brand new application created from scratch. While trying t load a file in data management, to my surprise there is a new dimension in the mapping secti…yanni vossos 91 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Management - Planning Custom to FCC Fails for multiple periodsSummary: Data Management Job sending Budget Data From Planning Custom to FCC Fails when multiple periods are selected. Content (required): We have a Data Management Data…
-
Impact Status in FCCSSummary Issue related to copy rule from a source scenario to anotherContent Dear All, we created a specific copy rule in FCCS that copies data from a source scenario (GL…Antonio Barbaro 61 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 21 views 1 comment 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close -
DM: Getting unusual errors when doing a metadata refreshSummary: Content (required): When we do a metadata refresh we get these strange errors which do not make sense and log is not generate even though it is set to level6: T…Nkehli 21 views 1 comment 0 points Most recent by Rich Wilkie-Oracle Financial Consolidation and Close