Data Integration
Discussion List
-
ROWS COMING WITH "BLANK" FLAG FOR DATA LOADS in DATA EXCHANGESummary: ROWS COMING WITH "BLANK" FLAG FOR DATA LOADS in DATA EXCHANGE Content (please ensure you mask any confidential information): Hi Team, We are trying to load data… -
Pipeline Stage Failed If File Is MissingHi Team, We have a pipeline within the FCCS instance that consists of two stages. The first stage loads data into FCCS, and the second stage loads data into PBCS through…Jacob Gomes 19 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data integration to load data from ERP connection fails at extract stage.Summary: We are trying to execute an integration in data exchange to load actuals data from ERP data source connection, but the integration gets stuck at the extract sta…
-
Object Storage Large File SegmentingWe are looking to use Object Storage as a file staging zone for data extracts going to external systems that can readily retrieve files from Object Storage. To do this w… -
Data exchange connection to databricksSummary: Trying to connect to databricks through data exchange Content (please ensure you mask any confidential information): I am trying to create a connection to datab…
-
How to use the pipeline for data load in oracle account reconciliation?Summary: We would like to use pipeline for some sequence tasks including the data loads Content (please ensure you mask any confidential information): We would like to u…Omar Muhammed - PWC 15 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
DataMap error-The max no. of remote cubes in DataMap's has reached.I am trying to create a new DataMap from one instance to another. However, I received the message: "The maximum number of remote cubes in DataMap has been reached." The …
-
Integrating Forecast data from EPM to Fusion ERPSummary: Hi Oracle Community, I'm working on an engagement where we are integrating Forecast data from EPM into Oracle Fusion. I have hit a config challenge in the integ…
-
add refresh job in pipelineSummary: I want to add refresh database, refresh members and metadata as a job in a pipeline. How can I do that as that option is not available in the drop-down menu. Co…Suravi 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
How to remove dataload mapping of deleted lookup dimensionInitially during development , we have created some additional lookup dimensions and created mappings against this DM dimension. Later we deleted those Dimensions but fo…SrikanthReddy-Oracle 20 views 1 comment 0 points Most recent by NarayananS EPM Platform and Freeform
-
-
How to pass POV as parameters in URL from EPM as drill through to FDISummary: Hi, We want to drill through to FDI using direct drill option from EPBCS and pass the FORM POV selection as parameters in the URL used in direct Drill. Users re…
-
FCCS Data Exchange - RATES Integration Issue - DATAVIEWSummary: We have configured a RATES cube integration, which is supposed to import FX rates from a CSV file into the FCCS RATES cube. We are unable to correctly map the V…Andreas Otto 38 views 5 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Exporting data such as smart list, date, text using data Data IntegrationSummary: Hello Team, I am trying to export data set with different types such as numeric, smartlist, and date in file using Data Export to File in Data Integration. Howe…Viral Soni 250 views 15 comments 3 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
ERP to EPM Adjustment period loads fail INFO [AIF]: Current polled request status is: WAITSummary: Hi, I am trying to integrate the Adjustment Period(13th and 14th period ) data from ERP to EPBCS. My DLRs with Adjustment period mapping runs for 30 mins and it…
-
Batch to be replaced with Pipeline but how about Open Batch?Summary: "Pipeline is a replacement for the batch functionality in Data Management and can be migrated automatically to the Pipeline feature in Data Integration" as per …NarayananS 32 views 3 comments 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
EPM integration agent multi period import from on-premise file to data exchangeHi All, I am trying to do multi-period load using On-Premise File Data Source Application, but getting below error when it is trying to import dat file. Application Sub …Prem Siva Kumar Reddy Rami Reddy 22 views 4 comments 0 points Most recent by NarayananS EPM Platform and Freeform
-
Request for Suggestions to Optimize Data Integration Run TimeHello Everyone, We have a data integration process that takes approximately 15 minutes to complete. This integration loads data into FCC, with NetSuite as the source sys…Srinivas Challa17 17 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Configure Snowflake connection with EPM Integration AgentI am trying to connect to Snowflake via the EPM integration agent. I have followed the documented steps. I am using a File Credential Store. I am now receiving this erro…
-
Writeback to Oracle DB integration agent does not give error if the SQL insert is incompleteHi, I have a scenario in Oracle ARCS where i am doing writeback to Onpremise Oracle database using SQL in EPM integration agent. I am loading the csv file using insert q…
-
Issue with last process ID while executing incremental file - based integrations in a pipelineSummary: I am trying to execute an incremental file adapter-based integration wherein to execute the integration , I need to give the 'last process ID" as 0 if the data …
-
2Pipeline Parent and Child Jobs MonitoringSummary: We want to monitor all the Parent/Child pipelines jobs for the status as part of automation, The REST response provides the GET of the pipeline but not all the …
-
Schedule Remove Cells with Zero ValueIs there a way to schedule a job to run the database properties function in Calc Manager, "Remove Cells with Zero Value", on a nightly basis for a specific database or a…
-
Integrating Data into EPM from FDISummary: Hi All, I'm interested in understanding what the integration options are from FDI into EPM (I've seen plenty of posts regarding FDI→EPM). Thanks, Mark Content (…MarkDrayton 53 views 3 comments 0 points Most recent by MarkDrayton Fusion Applications Administration
-
Issue while Importing ERP Cloud data into EPM applicationsSummary: Data is not getting imported into EPM application from Cloud ERP. Error at Import step. The request tries to Import data for 30 mins and eventually errors out C…
-
Account Lock Issue Despite Successful Login in EPM AutomateSummary: Account Lock Issue Despite Successful Login in EPM Automate Content (please ensure you mask any confidential information): Hi All, I scheduled the IF account to… -
pipeline, variables and a "prompt" to choose a versionSummary: Allow administrators, when running a pipeline, to specify which data "version" is contained in a load file—without requiring this information to be embedded wit… -
data exchange Import issue Applying Amount MappingSummary: I am facing issue during Import step of Data Exchange. Below error: It is allocation data writeback from EPCM to ERP. Integration is able to extract data out of…Ravinder Singh-63390 24 views 11 comments 0 points Most recent by Ckopparam EPM Platform and Freeform
-
Multiple Adjustment Periods in Data Management for ARCS Data LoadSummary: Hello Everyone, I am working on ARCS Data Loads using Data Management and would like to check if anyone has experience with configuring multiple adjustment peri…DarshanJ 4 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Issues Importing Maps in Data Exchange/Management with Comma in Source ValueSummary: We have a number of maps that utilize commas within their Source Value definition. This has never presented as a problem, as wrapping them in double-quotes duri…