Data Integration
Discussion List
-
FCCS | Data Exchange - Export Data ErrorFCCS | Data Exchange - Export Data Error In Data Exchange > Workbench > Actions > Export Data: when tryinng to export mode online, the process ends with the error "Expor…Timestamp EPM Team 53 views 4 comments 0 points Most recent by EPMRuben9172EPM Financial Consolidation and Close -
DM Data Load Mapping: Import user-defined attributesWe would like to import metadata by Data Management, in this case Account dimension. When importing account with 2 UDA (user-defined attributes) separated by commas, gro…Timestamp EPM Team 12 views 0 comments 0 points Started by Timestamp EPM Team Financial Consolidation and Close
-
Connecting to multiple ERP Cloud GL'sI have a requirement where a customer wants to connect to multiple ERP CLOUD GL's (multiple instances). I currently have one ERP Cloud source system setup - Oracle ERP C… -
FCCS Load failuresSummary: Hi We are seeing data load in to FCCS fails. Below is the error message. Can you please help us as this issue is in production? Error Message: HTTP POST on reso…Divya_Masoodi 45 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Issues while trying to drill back to FCC to EBS (Custom table)Summary: We had configured the EPM Agent is OCI VM and the query is been setup properly to pull the data from the custom table. We had set up the drill URL as well. but …Sudhir_Sinha-Oracle 60 views 3 comments 8 points Most recent by Sudhir_Sinha-Oracle Financial Consolidation and Close -
Setup EPM Agent (Additional?)Hello all, How do you get the EPM agent to pull data from an additional data source? How or where is it configured? We have a single EPM which pulls data into our FCC/AR…
-
Data Integration Pipeline - EPM Platform Job - Clear Data not working / need additional parameters?Hello, We have an FCCS "Clear Data" task that exists in the local FCCS application & runs fine manually via "Overview" -> "Clear Data" from FCCS, but we cannot get it to… -
Protection of data when data exchange is used to load to FCCIs there a way of protecting override rates data that has been manually keyed to the "managed data" data source when a load is done from data exchange to the same entity…
-
Users Unable to see the existing file and folders (flat file) in Data exchangeSummary: Hi , Power users having access all the entity, he trying to upload the file in Data Exchange card. but he can upload the file but file is not visible and he can…Nagarajan Mouttouvelou 84 views 4 comments 0 points Most recent by Ananthakrishnan Mahalingam Financial Consolidation and Close
-
SubVar DataLoadConsolMember set to TRUE is not workingSummary: We add this subvar DataLoadConsolMember to TRUE to prevent data amount override being cleared during export data to FCCS using Replace Method, but don't know si…J Mahero L 107 views 20 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
Data Load Rule Data Not Populating FCCSHi all, We are trying to directly integrate FCCS and OAC, so we have set up a data load rule that extracts the data from FCCS and puts it in an excel file that gets pick…Sarah Paroya 41 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Data Management job fails with tunnelling error messageSummary: We have jobs being run overnight with EPMAutomate used to extract data from our Oracle Fusion ERP and load into FCCS and EPBCS within 5 minutes of each the one …Jeremy Stubbs 16 views 3 comments 0 points Most recent by ioannisvossos Financial Consolidation and Close
-
Drill through from FCCS to Cloud ERP redirecting to a different URLSummary: Drill through from FCCS to Cloud ERP redirecting to a different URL Content (please ensure you mask any confidential information): A connection is setup in Data…
-
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…Jay Banda-278274 193 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Downloading file from OCI sub-directory using Pipeline Object Store JobsSummary: Using EPM Pipeline - Object Store Jobs, I tried downloading a file from root folder of OCI bucket, it worked fine. I need to download the file from sub-director…Mohit Sharma-73954 31 views 2 comments 0 points Most recent by Mohit Sharma-73954 Financial Consolidation and Close
-
Import Data using a text file by a Power User or UserHi all, In our application we have users with the Power User and User role. These users need to load data in the application using a text file. After creating the Data I…Stefano Guida 51 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
UPDATE HEADER IN "DATA EXPORT TO FILE" APPLICATIONSummary: UPDATE HEADER IN "DATA EXPORT TO FILE" APPLICATION Content (please ensure you mask any confidential information): Hi All, I created a specific "DATA EXPORT TO F…Antonio Barbaro 11 views 0 comments 0 points Started by Antonio Barbaro Financial Consolidation and Close -
Is FCCS able to connect ERP daily cube to get Average Daily Balance (ADB) for creating dashboard?Summary: Is FCCS able to connect ERP daily cube to get Average Daily Balance (ADB) for creating dashboard? Content (please ensure you mask any confidential information):…Sukittima Siwapetcharakorn 36 views 5 comments 0 points Most recent by Sukittima Siwapetcharakorn Financial Consolidation and Close
-
Data Management and Data Integration Setup Security for Role "User"Summary: Is there something that need to be setup for Role "User" to access Data Management and Data Integration. I have enabled "Location Security" and have assigned us…J Mahero L 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to Extract data in FCCS_YTD?Summary: I want data extract in FCCS_YTD, however I am getting Extract in FCCS_Periodic . I changed the Source Option as "FCCS_YTD", still result is showing FCCS_Periodi…Sneha Mallick 25 views 3 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Question related to format number - Custom ApplicationSummary: Question related to format number - Custom Application Content (required): HI All, in my FCCS Application, I created a specific Custom Application in order to h…Antonio Barbaro 35 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
loading exchange rates - Entity is locked.FCCS newbie here. I have been tasked with loading exchange rates to FCC. I have an integration pulling data from a ERP BI Publisher report and loading to the rates cube.…
-
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 99 views 7 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
how to pull parent level data in the applicationSummary: The issue is w.r.t ectracting data from fccs for Net Income, we are able to extract only base level members (the ones with store or never share data storage pro…_Sanjay_ 27 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data Management - block data importWhen Exporting from Data Management to FCCS receiving error ERROR [AIF]: The rest service request has failed: 400 - {"status":400}. In the target options, when we define…Timestamp EPM Team 21 views 3 comments 0 points Most recent by Timestamp EPM Team Financial Consolidation and Close
-
Run Business Rule for All PerriodsSummary: How to Run on demand business rule for all periods Content (required): I want to include business rule that clears budget data for Jan:Dec in a pipeline. Pipeli…Ija Vidaurri 32 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Drill through integration agent from ERP to FCCSSummary: Hello Experts !! To meet the client requirement where source is ERP on premise and Traget FCCS latest version. Data integration is working fine , challenge is h…AlokPriyadarshi-Oracle 46 views 5 comments 0 points Most recent by Swaraj Vamaravelli Financial Consolidation and Close
-
In Data Management->Data Load Mapping->Export to Excel does not show dimension detailsSummary: In Data Management->Data Load Mapping->Export to Excel it downloads an Excel. In this Excel in the Map tab there is a drop down for all the dimensions. SO when …rahul shinde-Oracle 15 views 0 comments 0 points Started by rahul shinde-Oracle Financial Consolidation and Close
-
Export Aggregated Data from FCCSSummary: We have issues in exporting aggregated data out of FCCS. even if we point the aggregated level member, the export result in file always shows level 0 data. Cont…Emanuele Panichi 47 views 4 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
How can we schedule pipeline?Summary: How can we schedule pipeline? Content (required): How can we schedule pipeline in Oracle FCCS? Version (include the version you are using, if applicable): 23.08Shelbi 103 views 7 comments 2 points Most recent by Mike Casey-Oracle Financial Consolidation and Close