Data Integration
Discussion List
-
Job scheduling in FCCS for first 10 days in a close cycleSummary: We want to trigger the data load pipeline daily from the 1st to the 10th of each month. How can we achieve this using job scheduling in FCCS? We do not want to …AishShirke 22 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
View member FCCS_YTD_Input does not behave correctly when importing dataSummary: View member "FCCS_YTD_Input" does not behave correctly when importing data from Application\Overview\Actions\Import data. The YTD values in the file are stored …Arild Bjorsvik 34 views 3 comments 0 points Most recent by Arild Bjorsvik Financial Consolidation and Close
-
FCC: Restrict Security for Users in Data IntegrationSecurity Setup to restrict users in Data Integration is msissing. Our business case foresees users who need to trigger a data integration and access the Data Load Workbe…Andreas Otto 27 views 3 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close -
Conditional Source Expression with Concatenation as outputSummary: We are migrating HFM Import scripts to cloud. I am planning to leverage Conditional expression to achieve similar functionality but it is not working. Basically…SrikanthReddy-Oracle 1 view 1 comment 0 points Most recent by Guixdx Financial Consolidation and Close
-
SAP S/4 Hana Connector to EPM applications (FCC/EPBCS)Summary: Does Cloud EPM (FCC/EPBCS) have SAP S/4 Hana Connector to pull data & drill through features? Content (please ensure you mask any confidential information): Ver…
-
How to export the Data Management/Data Exchange job details using EPMautomate?Summary: How to export the Data Management/Data Exchange job details using EPMautomate? Content (please ensure you mask any confidential information): Client wants to mo…Harshith J Rao 22 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
RestDataGrid error in integration Fusion - EPMSummary: This month, the system gave an error in the transfer of data from ERP to EPM. The error is "RestDataGrid_XXXXXXXX is invalid". I saw other people having the sam…Pieter-Jan Vandendriessche 11 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close
-
Why do the data load process steps vary?Summary: We've noticed that the five steps in the data load process vary. The last step sometimes says "consolidate data for consolidation application mmm-yy" and someti… -
FCC REST API GET Approval unit StatusSummary: Dear Community, We are currently setting up an Oracle EPM FCC instance and need the ability to read the Approval Unit Status for our planned Data Integration. O…Andreas Otto 63 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
What are the recommended steps to follow for closing business operations from one countryHi All, Our client based out from US and is planning to close the UK operations. Can someone please provide what are the recommended steps to follow to close out all the…
-
ORA-00001: unique constraint violated ERRORSummary: We found this error on FCCS Data Integration with ERP CLOUD Content (please ensure you mask any confidential information): From FCCS Data Exchange > Application…Stefano Francese 5 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close -
Data Management Issue – TB Files Deleted & Mappings RevertingSummary: Is anyone experiencing issues in Data Management where TB files that were uploaded into a folder are being deleted unpredictably, and mappings are unexpectedly …B.Bhandari 22 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS tables for data similar to HFMSummary: Hi, We have one audit requirement requesting for FCCS schemas, tables, and databases in FCCS which contains data in backend. Do we have anything as such for fcc…Sud VJ 47 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can I use the 'Description' field in a Mapping with SQL Script?Summary: I'd like to use the 'Description' field (available in the workbench) in a SQL script for the mapping. Content (please ensure you mask any confidential informati…
-
Data with natural sign in FCCS (No Flip sign in data management)Hi All, We have a requirement to keep natural sign in FCCS rather than flipping the sign in data management. but the challenge is, If we don't flip the sign, data won't …Ashok_Yadav 27 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Data Management connection with Active Directory UserSummary: Is there a way to user Active Directory User or SSO user to configure data management connection ? Content (please ensure you mask any confidential information)…VineetPathak 12 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
Data Exchange - Logic GroupHello friends! We have a situation in a customer Environment, that we use Logic Group in Data Management to replicate some data. But in the Data Exchange menu, I do not …Guido Zanella 23 views 3 comments 0 points Most recent by Guido Zanella 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 42 views 2 comments 0 points Most recent by Harry Zhu Financial Consolidation and Close -
Exploring Automation Options for Loading Exchange Rates from Oracle ERP Cloud to FCCSHi Community, I’m currently exploring different approaches to automate the loading of exchange rates from Oracle ERP Fusion Cloud into FCCS. As part of this exploration,…
-
Loading FX Rates via Data ManagementSummary: Hi All, We are trying to load FX rates into FCCS Rates cube via DM and are running into issues. The data imports and exports fine but we do not see the rates lo…User_2025-02-12-04-44-51-669 404 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
What kind of file extensions are considered as invalidBased on Oracle EPM Apr'25 What's New, Block Upload Of Files With Invalid File ExtensionsMay I know what kind of file extensions are considered as invalid?Jennifer Kh'ng 22 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
multidimensional mapping in epm cloud planningSummary: can we do multidimensional mapping with descendants of two dimensions mapped to one target. Example I have 2 source entity and service , mapped to service.HarshitaSinha 31 views 6 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Does fccs data export supports Azure storage account as a destination for the file?Does fccs data export supports Azure storage account as a destination for the file? We're trying to automate trial balance report export to an external Azure storage acc…Adrian Garcia 21 views 5 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Connection between Netsuite and Financial Consolidation and CloseHello!!! We are exploring the possibility of establishing a connection between Netsuite and Financial Consolidation and Close. Is it possible using NSPB Sync?
-
Inquiries about the Enterprise Version and Domain CreationRegarding the Enterprise version contracted by the client, how many domains can be created within the application? Additionally, how is the billing for the domains handl… -
Run Consolidate from Business Rule in Data ExchangeHi, I built a Business Rule in Data Exchange and ran a union in it after uploading the data When I let a user who is defined as Power User to load the data, it fails and…Reut Phillips 56 views 11 comments 0 points Most recent by Reut Phillips Financial Consolidation and Close
-
In FCCS, where is the Fusion Connection Configuration? The UI has changed.Our organization is currently changing all Oracle service account account passwords due to the recent security breach announcement. In FCCS, the user interface has chang…Seth A McLane 32 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
A new YTD column needed in the FCCS workbenchSummary: When checking and reviewing data in the work bench in data integration in FCCS, we need a new column for the YTD target amount in addition to the already provid…
-
I want to export data in FCCS in text file and unable to do itSummary: I want to export data in FCCS in text file and trying to define a target application with category EPM local and Type custom application. The Type custom applic…Divya_Masoodi 23 views 2 comments 0 points Most recent by Shanthi Subramanian-Oracle Financial Consolidation and Close
-
Set Default Export Mode in Data ExchangeSummary: Hi. Is there a way to set the Default Export Mode for all Locations in Data Exchange? We have a rule which sets the Export Mode in Data Management. We wanted to…Alyssa Longo 25 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close