Data Integration
Discussion List
-
Data Management - Error when no records presentSummary: Hi Everyone In our implementation when FCCS pulls data from Oracle Fusion, we might have a possibility it returns 0 records or just the header, which is ignored…I Mary John-Oracle 1 view 0 comments 0 points Started by I Mary John-Oracle Financial Consolidation and Close -
Showing Balance Sheet Accounts with natural signage from TB and P&L Accounts with sign flip in FCCSummary: Hi All Client requires us to show Balance Sheet Accounts with natural signage from ERP and P&L Accounts with sign flip. This requirement is from reporting stand…Parmit Choudhury-Deloitte 32 views 5 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
Performance Issues with DM loads in FCCSSummary: Data loads in FCCS seems to be quite slow. in the specific after "export" to the FCCS app, the process gets stuck for hours on the Consolidation into FCCS. it s…Emanuele Panichi 31 views 5 comments 0 points Most recent by Fabio Fiore Financial Consolidation and Close
-
Conditional Mapping through FDMEESummary Automation of grouping of credits into liability and debits in AssetsContent We generally records journal entries to regroup the negative numbers coming into Ass…User_ADS5Z 24 views 4 comments 0 points Most recent by Apoorv Jain-234550 Financial Consolidation and Close
-
Data Management Loading Differently for Power Users vs. AdminSummary: Data seems like it is loading differently for Power User's vs. and Admin into FCCS. Content (required): We have recently loaded data into FCCS using a Power Use…Matthew Gregory-137392 21 views 0 comments 0 points Started by Matthew Gregory-137392 Financial Consolidation and Close
-
FCCS Data management by default does not load zero balancesSummary FCCS Data management by default does not load zero balancesContent Hi Guys, We have experience interesting fact on Data management load, DM default does not load… -
Data Management (DM) ReportSummary Map Monitor Report by Location reportContent Hello, I am trying to run a report in DM to show mapping changes. When I put in the parameters and ran the report, i…Stephen Coleman-48124 30 views 10 comments 0 points Most recent by Michael C Stefanavage Financial Consolidation and Close
-
Started periods in FCCS not recognised during load from Data ManagementSummary: I cannot load from Data management as the error states the Entities is not started when they are. Content (required): I get the following error message despite …
-
FCCS and loading ZerosSummary We are forced to load or enter zeros to get closing balances or YTD movements correctContent Hi everyone, We have an FCCS application working on the YTD basis, i…Jaco Steenkamp 253 views 32 comments 0 points Most recent by Amit Kulkarni Financial Consolidation and Close -
Loading data using Data Management with Complex MappingHi All, we have a complex mapping requirement for a data load whereby we need to load the data into the correct product (Custom1 dimension) based on the parent (or in so… -
DSO FCCS - Can We pull YTD data from DSO FCCS to NON DSO FCCS or TRCS/PlanningHi I wanted to ask that Can We pull YTD data from DSO FCCS to NON DSO FCCS or TRCS/Planning application ?Husain_Kachwala_DP 21 views 0 comments 0 points Started by Husain_Kachwala_DP Financial Consolidation and Close
-
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 31 views 7 comments 0 points Most recent by Michelle Wagner Financial Consolidation and Close
-
Extracting YTD data from FCCS using Data ManagementSummary The attached document explains how to extract YTD data from FCCS using Data ManagementContent The current Essbase implementation for FCCS includes the view dimen…Mike Casey-Oracle 108 views 8 comments 3 points Most recent by Mike Casey-Oracle 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 21 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…Maruthi_FCC 21 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
FCCS: DSO with PBCS Data for AccountContent Hi all We have a doubt about data import from Planning to FCCS. What happens when account from Planning is set to Dense and we have a new application FCCS where …
-
Loading historical data as a picture in FCCSContent Hi guys, We're trying to load 2 years of historical data in the app, but we just want it to be as a picture. This is because the data is only for reference/compa…Luli18 39 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 11 views 4 comments 0 points Most recent by Rajesh CP-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 11 views 2 comments 0 points Most recent by Rajesh CP-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 22 views 7 comments 0 points Most recent by Rihan Jameel Financial Consolidation and Close -
Export of data with data management and suppression of zerosIn step 1 - when importing the data from FCC into Data Management, the zeros are suppressed. (by default) In step 2 - if the accumulation of rows in Data Management resu…Bjoern Schumacher 1 view 1 comment 0 points Most recent by Rajesh CP-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 21 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 121 views 0 comments 8 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 21 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 …User_3UODH 22 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… -
Copy / Recompute Ownership via REST-APISummary Is it possible to do a copy of ownership data and/or a recompute of the ownership data via REST-API?Content Hi all, I'm just trying to automate some things to ge…Markus Wipp 34 views 4 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…
-
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 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close