Data Integration
Discussion List
-
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 114 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 42 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 32 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 52 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 31 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 22 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 42 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 154 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_ 61 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 22 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 170 views 5 comments 0 points 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 32 views 1 comment 0 points Most recent by Matt Maurer Financial Consolidation and Close
-
Mapping based on another field target member in Data Management/Data IntegrationSummary: Can we do some mapping based on another field target member in the Data Management/Data Integration. It just like excel we can use another field as source to an…
-
Data Validation Data Management to prevent data export to FCCSSummary: How to make some validation in Data Management to prevent data export to FCCS. Example: Validate amount total account (bs + pl) should be zero Validate amount o…J Mahero L 24 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Reports - Data ExchangeSummary: Where can we find Pre defined set of reports in Data Exchange likewise Data Management? Content (required): Currently within Data Management, there are a series…Arpit Ojha 22 views 3 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
How to extract dynamic calc member data from FCCS application using Data managementSummary: How to extract dynamic calc member data from FCCS application using Data management Content (required): Hi Team, Earlier we used to have one option in Source pa…
-
Data exchange fix maps functionalitySummary: In data exchange when there are validation errors, it directs you to fix the map, when you click on FIX MAP it takes you to the Account dimension. In data manag…
-
Mapping Data Management Based on Target to TargetSummary: Can we mapping target dimension to target dimension in data management. For example: There is 2 dimension such as Intercompany Dimension and Entity Dimension. I…Utari321 52 views 3 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Removal of Support for Custom Application in DMSummary: Removal of Support for Custom Application in DM Content (required): Can you please let us know how to create custom target application in Data Integration? If w…Ramsha Ansari 31 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close