Data Integration
Discussion List
-
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 32 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 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 209 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_ 75 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 24 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 54 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 42 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 198 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 43 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 24 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 51 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 32 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Does anyone have a procedure for loading currency rates into FCCS using a spreadsheet?Summary: Does anyone have a procedure for loading currency rates into FCCS using a spreadsheet? Content (required): Does anyone have a procedure for loading currency rat…Phil Nibert 32 views 1 comment 0 points Most recent by Payal Vaidya-Oracle Financial Consolidation and Close
-
Error in loading data from Erp Cloud GL (essbase db) to FCCS.Hi all, Its been a very straightforward scenario, where I need to load Actuals ERP cloud data in to FCCS, please see below all my data / member maps, this i swhat im get…yanni vossos 42 views 3 comments 0 points Most recent by Payal Vaidya-Oracle Financial Consolidation and Close -
Is it possible to move a Data Input form from an application to another?Summary: Content (required): Is it possible to move a Data Input form from an application to another? We need to move a data form from Test to the Live application, is t…FT96 32 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
can we export data attribute dimension using data managementSummary: can we export data attribute dimension using data management Content (required): can we export data attribute dimension using data management Version (include t…
-
Procedure to end date / deactivate a natural account in FCCSSummary: Procedure to end date / deactivate a natural account in FCCS Content (required): Checking to see if Oracle or anyone has a procedure to end date / deactivate a …Phil Nibert 44 views 4 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close