Data Integration
Discussion List
-
How to remove last 4 characters from source file in data exchange (EPBCS)Summary: I am executing an incremental file adapter-based integration wherein a particular column has data which looks for example like "XYZBand13EP7.75". To meet a part… -
set up the ERP Cloud GL Balance (FRCOA) connection in Data ExchangeSummary: Hi everyone, I’m trying to set up the ERP Cloud GL Balance (FRCOA) connection in Data Exchange, but the connection does not appear in the list of available sour…Ouma_123 18 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 lock/unlock periods in Data ExchangeSummary: Looking for the functionality in Data Exchange that exists in Data Management to Lock/Unlock locations by Period. Content (please ensure you mask any confidenti…Stephanie Philopoulos 369 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Parallel Job Execution and EXECUTION_POOL_SIZE in Oracle EPM PipelinesSummary: Hello Everyone, I am currently working with pipelines in Oracle EPM Freeform and need some clarification. We are looking to optimize performance and would like …Kalaivani Ravichandran 27 views 0 comments 0 points Started by Kalaivani Ravichandran EPM Platform and Freeform -
Oracle's position on concurrent integrations?Does anyone know what Oracle's position is on running multiple loads at once? Can you pull from different cubes within the same EPBCS Applications at the same time with …
-
Unable to Map Source Periods (FSC1, FSC2…) to Global Periods During Data Exchange ExportSummary: I have Global Period mappings defined in Data Exchange in the format Jan-24, Feb-24, Mar-24, etc. However, my source system uses a different period format such …
-
New Cube Fields in Edit Integration Throwing Error When Trying to SaveSummary: We discovered that the 25.11 patch introduced new cube fields to the edit integration screen when viewing integration details. For some of our integrations, the…
-
Make mass updates to inactivate Departments in EDMSummary: We are undergoing a Department Rationalization and need to update ~100 departments to "Inactive". Using the Mass upload template, we know to update the departme…
-
Data Management - Passing Start Period and End Period to Business RulesContent In Data Integration I have a business rule that performs calculations post load for the period range loaded i.e. DM POV Start and End Period range. In DM Cloud, … -
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 20 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… -
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 22 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 43 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 11 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 42 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 260 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 36 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 …