Data Integration
Discussion List
-
Import Fusion Supporting References in EPMSummary: Is there a way to import Fusion Journal Supporting References as attributes/use them as LOOKUP mappings in EPM applications (FCC)? Content (please ensure you ma… -
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 132 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 51 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to refresh members from source (EPBCS) application in an EPBCS to EPCM integration.Summary: In Data Management I am unable to refresh members from the source application (EPBCS Reporting cube) after registering the EPBCS application. In error log it's …Sanchari Chakraborty-Oracle 136 views 4 comments 0 points Most recent by Sanchari Chakraborty-Oracle Profitability and Cost Management
-
Period name - Source filter in Data load ruleSummary: The EBS on-premise data base is integrated with FCC using the EIA agent . We have used the EBS adaptor for the integration which internally uses two parameters …
-
EPCM - YTD from PTD source data for every periodSummary: In EPCM, all of my current month calculations require previous month YTD data for calculation. we have not created any additional period type dimension and its …Anantha Krishnan 182 views 9 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
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…
-
EPM Integration Agent encryptionSummary: EPM Integration encryption Content (required): Client's network security team requires to know how EPM Integration Agent secure the data transfer and protect th…Gary-consultant 102 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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
-
FDMEE Error: ExtractBalanceData:Error::Cannot perform cube view operation. Essbase Error(1260046)Summary: Hi, in FDMEE, using: Data Source: ERP Cloud Target: EPM Local Clicking on the import phase, the system returns no "fishes" (image below) and the log returns the…
-
Pipeline Migration MethodSummary: Is it supported to migrate pipelines by exporting via a snapshot and importing to the Target? Content (please ensure you mask any confidential information): We … -
Data Export to File does not workSummary: Hi Team, In FDMEE, when using Data Export to File as Target, the first step of the Data Load Workbench (Import+Validate) does not load any data! I tried to use …DavidePacilio 131 views 9 comments 0 points Most recent by Kumaresh Sankar-Oracle EPM Platform and Freeform
-
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
-
quick mode EXPORT from EPCMhi All from our EPCM application, we want to extract the data set and send to target systems for reporting. We have extremely huge volumes of data (approx 1 million of r…Sucharitnarang 81 views 3 comments 0 points Most recent by Sucharitnarang Profitability and Cost Management
-
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 11 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