Data Integration
Discussion List
-
Sample groovy script to export aggregated FCC dataSummary: Sample groovy script to export aggregated FCC data Content (required): I am trying to write a groovy script to export aggregated data from FCC for an interface … -
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 …Nkehli 60 views 24 comments 2 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close -
loading to FCCS to a different currency via Data ManagementSummary: Content (required): I have a location set up in data management to load FX rates from Oracle ERP to FCCS. I cannot get the data to load to the correct target cu…TejC 33 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Calculate entity on the various members of the Consolidation dimensionSummary: Content (required): Hi, In the project where I am currently, in the entity dimension there is the following hierarchy: The requirements are: Ent1, Ent1_Y, Ent2,…Carolina Silva 11 views 2 comments 0 points Most recent by Carolina Silva 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 73 views 6 comments 0 points Most recent by Randa-Oracle Financial Consolidation and Close
-
Loading of Members in the Order in IntegrationSummary: Even if a full load is provided. All new members are always added at the end of the Structure. The Client wants the Structure to be in the same order. We are on…I Mary John-Oracle 11 views 0 comments 0 points Started by I Mary John-Oracle Financial Consolidation and Close
-
Data Management and zero loadingSummary: I thought that when loading data via data management the defualt behavior was that zero balance lines were NOT loaded to FCC Content (required): I am reviewing …Nancy Ackerman 80 views 10 comments 0 points Most recent by User_EVRIV Financial Consolidation and Close
-
Calendar Change to Fiscal Year - Impact on data management YTD loads?Hi all, We received a request to change the Fiscal Year from November start to January, as we load data "YTD_Input" via data management to "FCCS Closing Balance Input", …ioannisvossos 13 views 1 comment 0 points Most recent by Vani-Oracle Financial Consolidation and Close -
No Input rule/optionSummary: client is moving from HFM to FCC and currently "locks" data by adding the completed year to a No Input rule - is this available in FCC? Content (required): Is t…Nancy Ackerman 72 views 10 comments 0 points Most recent by David Corredera Financial Consolidation and Close
-
Generate Process Monitor Report for all locations in single goSummary: Hi team, User is requesting to Generate Process Monitor Report for all locations in single go. Kindly suggest This was available in FDMEE FDMEE- Process Monitor…
-
Journal Load button of Data Management in Data ExchangeSummary: Journal upload from Data Exchange Content (required): Is there an equivalent of Journal Load button of Data Management available in Data Exchange interface? I t… -
Mapping for account based on amount Greater/Less than zero in data load mapping using #SQLSummary Trying to write a SQL script in Data load mapping for defining target account and amount based on the value of source-amount Content (required): In FCCS, I have …Apoorv Jain-234550 41 views 4 comments 0 points Most recent by Thejas Shetty-Oracle Financial Consolidation and Close
-
Setting Replace Mode by Default in Data ManagementSummary: Setting Replace Mody By Default in Data Management Content (required): Hi All, is it possible to setting (in Data Management) the "Replace Mode" by Default ? In…Antonio Barbaro 13 views 1 comment 1 point Most recent by Randa-Oracle Financial Consolidation and Close -
Can the integration agent pull FX rates from Oracle Cloud FusionSummary: Client is asking if data management can pull the FX rates from Oracle Cloud Fusion (which they are implementing at this time along with FCC) Content (required):…Nancy Ackerman 21 views 1 comment 0 points Most recent by Randa-Oracle Financial Consolidation and Close
-
Dry Run option - Data ManagementSummary: Dry Run option - Data Management Content (required): Hi All, I see the "Dry Run" Option in Data Management. Do you know what's it? Version (include the version …Antonio Barbaro 22 views 2 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close
-
FCCS Data Management - Export Mode "Replace"Summary: Export Mode "Replace" option not working in FCCS Data management. Content (required): We load the data from ERP Fusion GL to FCCS. When we perform the data load…karthick chinnathambi 15 views 0 comments 0 points Started by karthick chinnathambi Financial Consolidation and Close
-
FCC integration to SAP BW Hana (On-premise) using EPM Integration AgentSummary: FCC integration to SAP BW Hana (On-premise) using EPM Integration Agent Content (required): We wanted to know if we can connect to On-premise SAP BW Hana using …SenthilSSN 59 views 3 comments 0 points Most recent by SachinSawant Financial Consolidation and Close
-
How to load Budget amount @Specific Currency from Planning to FCCS?Summary: We want to load Budget info for 1 specific currency across different Entities to FCCS. But in FCCS this is not in correspondence with the 'entity currency'. Not…Ilse De Vries_43167 12 views 1 comment 0 points Most recent by CAPawan Kumar 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 43 views 6 comments 0 points Most recent by KapilBankeraika-Oracle Financial Consolidation and Close
-
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 2 comments 0 points Most recent 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 34 views 5 comments 0 points Most recent by Ija Vidaurri 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 351 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 22 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 135 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. …