Data Integration
Discussion List
-
Exploring Automation Options for Loading Exchange Rates from Oracle ERP Cloud to FCCSHi Community, I’ve been exploring options to automate the exchange rates load from Oracle ERP Cloud to FCCS. As part of this, I referred to the following Oracle document…Lovaji1 4 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Using API Key Instead of Basic Auth in FCC Connection to Call OIC EndpointProblem Summary: We are triggering an Oracle Integration Cloud (OIC) REST endpoint from FCC using a Groovy script and a connection configured via the "Other Web Service …
-
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 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 382 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 21 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 37 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 25 views 5 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
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 1 view 0 comments 0 points Started by Stefano Francese 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…Miguel Medina Cerda 1 view 0 comments 0 points Started by Miguel Medina Cerda Financial Consolidation and Close -
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 54 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 21 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…
-
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… -
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 22 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 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Data integration child location mapping is not allowing changes to Parent locationSummary: Problem statement : We have enabled Parent location and attached to multiple child location as part of requirement. Now customer also require to update mapping …
-
FX rates extracted from ERP is not loading to FCCS rates cubeSummary: Hi all, I am facing two issues when using the standard ERP to EPM adapter - Oracle ERP(Exchange Rates), to bring FX Rates directly from ERP to FCCS, and wonderi…Sarita Menon 333 views 18 comments 0 points Most recent by Kemp2-Oracle Financial Consolidation and Close
-
Unable to retrieve Average exchange rate from Fusion GL to FCCS using direct integrationSummary: The integrated exchange rate import process in FCCS brings only Closing rate, while trying to retrieve closing rate & average rate from Fusion GL to FCCS Conten…Dhanasekaran Kasimani-Oracle 154 views 13 comments 0 points Most recent by Kemp2-Oracle Financial Consolidation and Close
-
FX rates extracted from ERP is not loading to FCCS using BIP reportSummary: Hi I am trying to load the exchange rate from ERP to FCC using BIP report. we configure ERP Custom data source type. i am able to import and validate, export wa…
-
running Data Management Reports using PipelineHi All, We would like to run Data Management report "TB Current Loc, All Dimensions-Targets, By Target Entity-Acct (Cat,Per)" using Pipeline. Could you please let us kno…Prem Siva Kumar Reddy Rami Reddy 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Import from Excel In data load mapping is not workingWe have exported the mapping to excel using Export to Excel option in Data Load Mappings, then added the new mappings in Excel, then when we try to import the excel we a…Prem Siva Kumar Reddy Rami Reddy 11 views 2 comments 0 points Most recent by Prem Siva Kumar Reddy Rami Reddy Financial Consolidation and Close
-
Not able to export data in Data Exchange/Management.Summary: Hello, I’m facing an issue with an export in FCCS. The error message I’m receiving is: "The member does not exist for the specified cube or you do not have acce…User_XLA01 51 views 6 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Java error when creating Authentication Token for EPMAgentSummary: Content (please ensure you mask any confidential information): Hi all We have an integration error with EPMAgent 24.12.05 and FCCS. The error is: when we execut… -
How can we use drill through for Custom BIP report integration in Oracle GL with FCCSSummary: We are loading sub ledger data through custom BIP report created in Oracle GL to FCCS. Wanted to check how can we use drill though functionality in this case. C…Ashok_Yadav 21 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
Drill Through after Migration ErrorSummary: After migration from one environment to another (e.g., Prod to Test). The Drill through functionality is not working. Understand that we need to reinitialize ag…Kenneth John Asper-Oracle 31 views 5 comments 0 points Most recent by Kenneth John Asper-Oracle Financial Consolidation and Close -
FCCS Data: The member does not exist for the specified cube or you do not have access to it.Summary: After consolidation, we have noted that we cant see the account No 235800506 IS-INSURANCE MMC. It was successfully imported, but when we check the logs for the …Martha Pauline Malaluan 56 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Push a journal category from Oracle Cloud GL to FCCS using enterprise journals in FCCS.Summary: Can journal category be pushed from Oracle Cloud GL to FCCS using "Enterprise Journals' in FCCS ? We are looking for a solution to pull journal category data fr…Ashok_Yadav 21 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Can we pull journal category value from Oracle GL to FCCS through Direct connection in Data exchangeWe have a requirement where we need to pull journal category data for Fixed Assets directly from Oracle Cloud GL to FCCS for Roll forward purpose. Wanted to check if the…Ashok_Yadav 11 views 2 comments 0 points Most recent by Ashok_Yadav Financial Consolidation and Close
-
Want to exclude 9* Accounts from Source FilterHi Everyone In GL to FCCS Data Integration we want to exclude 9* Accounts from Source Filter, We don't want to Exclude through Mappings as we don't want this data in Wor…Rashmi_Khodani 2 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close