Data Integration
Discussion List
-
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 41 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 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
ARCS Snowflake Query - Make period name parameter instead of hardcoding monthSummary: I am trying to pass in period name to my Snowflake query in ARCS. I am not sure what I should be trying to use in the Query when setting this up. I have tried t…Erik_Olson 12 views 3 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Data Management - Multi Column IntegrationSummary: Import format dimension not visible or mapped in Workbench Content (please ensure you mask any confidential information): I've configured a multi-column all dat…
-
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
-
Conditional in Source/Target expressionHello there! Where I can find all the possibilities for the Conditional statement in Source/Target expression? In the documentation, there is only one example with the t… -
Using SSO Users or Oauth2 for Connections in Data Integration Planning CloudSummary: We are not allowed to use Native users - SSO from corporate Azure servers are the company policy. Is there a way to use an SSO user also for the connections/ ta…
-
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 -
Object storage namespaceHi I'm interested in using the new Pipeline feature to move files to and from Object Storage. How do I find out the namespace for my respective tenancy? I read the docum…
-
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 226 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_ 81 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
-
Drill through to GL Essbase cube using custom data load processSummary: We have decided to proceed with a custom data load process and not use the standard GL adapter to source GL balances. This has led for us to consider a custom d… -
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 -
Data integration job between Workato Rest API to EPM Cloud not working.Summary: Data integration job between Workato Rest API to EPM Cloud not working. Content (required): We recently migrated ARCS classic to Cloud. now we are establishing …Srinivas Nuthi 21 views 7 comments 0 points Most recent by Omar Shubeilat. EPM Platform and Freeform
-
Removal of Custom ApplicationsSummary: Removal of Custom Applications Content (required): Hi Team, When will the Custom applications be completely removed in FCCS. Please let us know the timeline pla…
-
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
-
How to load mutiple currencies from Fusion to EPBCS?Summary: Loading multiple currencies from Fusion to EPBCS Content (required): Hi, we need to load different currencies from Fusion to EPBCS. Can someone assist on how th…
-
How to add a prefix to specific members in Data Load MappingSummary: Having trouble mapping a prefix and no prefix while loading employee data. Content (required): I am trying to load employee data using employee number. In our s… -
How to set data precision when exporting data from ASO through Data ManagementSummary: We are trying to export data from PCM to a flat file using Data Management. Is it possible to restrict the data precision to 2 as the source is an ASO cube Cont…Vikasitha 51 views 3 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management