Data Integration
Discussion List
-
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 81 views 13 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close -
Entity should not have intercompany with itself. How to restrict data load for these intersectionSummary: We wanted to restrict data entry to the intersections - Entity and intercompany itself. Content (please ensure you mask any confidential information): Version (…Kumara Surendra 12 views 3 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Dry Run on EPBCS applicationSummary: Dry Run on EPBCS application Content (please ensure you mask any confidential information): Hi Oracle, We tried running dry run in EPBCS and could not find opti…Ramsha Ansari 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to put validation to make sure that intercompany account is always tagged with ICP EntitySummary: We wanted to make sure that we always have Intercompany accounts being tagged with ICP entity so that the data in the Intercompany account will be eliminated pr…Kumara Surendra 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
YTD PL Account can't be filtered when integrating from FCCS to PBCSSummary: I did integration from FCCS instance to PBCS instance. I already filter the dimension that I need (YTD data for BS and PL account). Unfortunately, the result is…
-
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 101 views 7 comments 0 points Most recent by Timestamp EPM Team 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 33 views 4 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
Unable to extract data from FCCS with 4 decimal pointsSummary: We are trying to export data from FCCS to flat file using data target application for particular POV and we have specified data precision and data number of dec…ShubhamV 41 views 3 comments 0 points Most recent by Ashutosh Bhatikar-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… -
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 121 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 52 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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…
-
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
-
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 33 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 24 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 21 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 41 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…User_2025-02-03-23-55-06-250 210 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_ 77 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 31 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 51 views 5 comments 0 points Most recent by Swaraj Vamaravelli 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 44 views 4 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
Data load error messageSummary Data load error message - Data was loaded via Import data in FCCSContent Hi all, Tried to load the data, getting the below information. Here my question is where…
-
FCCS - Pipeline - Is it possible to use variables in a 'Business Rule' type jobSummary: I'd like to use variables for the parameters of my business rules. Content (required): I created a pipeline containing one job: 'Translate'. This is a 'business…Julie Belurier 211 views 5 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Audit Log for Export Method of Data Management/Data IntegrationSummary: Is there any audit log report in Data Management/Data Integration to check export method that is runned by user whether the method is Replace, Merge, etc. Thank…
-
"Data Export to file" option in FCCS is not generating YTD valuesSummary: We have created Target application with application Type of "Data Export to File" in order to extract data from FCCS application and then selected "FCCS_YTD" ag…Harshith J Rao 43 views 1 comment 0 points Most recent by Matt Maurer Financial Consolidation and Close