Data Integration
Discussion List
-
Copy file from Object StorageHello all! I'm not able to configure properly my EPM instance to copy a file from Oracle Object Storage to 'inbox' in my Pipeline. 1- I created a Connection named Object… -
Netsuite source period mapping not working with FCC data integrationSummary: Hi please can anyone help with defining the source period mapping using Netsuite as a data source and bringing data into FCC via data exchange? I have added the… -
Pipeline Limitation - Combination of Static and Substitution VariablesHello, When submitting a Pipeline with a combination of static and substitution variables, say StartPeriod of Jan-23 and EndPeriod of &SubVar(Value is another period), t…
-
EPMAUTOMATE command doesn't exist to launch pipelineSummary: EPMAUTOMATE commands are not available to launch Pipeline. Content (please ensure you mask any confidential information): Unable to launch pipeline job. Version…Sreenivas Rayala-Oracle 31 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management -
How to access data management load rule log file using EPM REST APISummary: We are using REST API to trigger a data lod rule and we are able to expose the output as a REST API CSV content but we need to access the corresponding log file…NarayananS 131 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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… -
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 SOURCE file from sub-d…Mohit Sharma-73954 91 views 14 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Where i can find sequence option available on Target application in DM in Data ExchanageDear Experts, I want to change order/ sequence of processing order for dimention in data load mapping. Earlier Squence option was available in DM target App screen now i… -
Metadata load from Data Management fails for Replace in Import and Export modesSummary: Metadata load from Data Management fails for Replace in Import and Export modes, it works for Replace and Merge when executed from Pipeline. Error is 'Plan type…
-
Warning status in Data ManagementSummary: In Data Management, processes can finish successfully with a warning indicated by a yellow icon. This usually happens when there are no records imported from th…
-
Error in loading PCMCS data to EPBCS financialsSummary: Trying to push data from pcmcs to epbcs but facing a issuse in transform step. Content (required): We tried mapping the target application values(EPBCS Financia…
-
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 127 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 135 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 103 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