Data Integration
Discussion List
-
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… -
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…
-
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 13 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 48 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 19 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 36 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 237 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 15 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 23 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… -
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, … -
Need to capture the start and end time of a Data load Rule(Data Exchange) in Groovy Rule.The Request is to get REST API output in json format like start time and end time of a Data load rule in Data Exchange. I have created groovy script to extract the log f…Radha Yerra 53 views 5 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
oracle account reconciliation : how to delete data by locationSummary: I need to delete data from two location only and not from all the location Content (please ensure you mask any confidential information): Version (include the v…
-
Unable to Export Attribute Member Consolidated Data in EPBCSCurrently, in on-prem, we are exporting data using attribute members, which means we are getting consolidated data rather than associated members through a report script…