Data Integration
Discussion List
-
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 … -
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 8 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-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 6 views 1 comment 0 points Most recent by Shanthi Subramanian-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 …
-
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 …
-
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 33 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…
-
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…Jeevananda R 1.6K views 21 comments 0 points Most recent by Philip Hulsebosch EPM Platform and Freeform
-
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 2 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, … -
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…
-
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…
-
Registering application and configuring connection for ARCS Transaction Matching's GL Data SourceWhen configuring ARCS Transaction Matching for AR to GL and AP to GL which data source should we use for the GL? I can see that there are available data sources for AR a…JML-820830 13 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Drill thru to data management in FreeForm appSummary: I have a FreeForm app where during configuration Scenario dimension wasn't enabled. I recently setup a drill region for direct drill thru to the staging area of… -
REST API to populate EPM Application with Forecast DataSummary: REST API to populate EPM Application with Forecast Data Content (please ensure you mask any confidential information): We are integrating PMIS (3rd party system…
-
Select Account from Target Dimension in Data MappingWe have to configure data load mapping in such a way where we need to map source to target based on condition that source member should exist in target otherwise all sou…
-
Failure in executing integration with "OWP_Incremental Process Data and Synchronize Definition" ruleSummary: I have executed an incremental file-based integration but whenever I am executing this integration by adding the rule in business rule section, it is showing er…
-
In Data Integration what is the difference between Target Period Year and Target Year?Summary: In Data Management/Data Integration, what is the difference between Target Period Year and Target Year in Period Mappings? Content (please ensure you mask any c…
-
Is new incremental file application mandatory if file has new columnsSummary: I have created an executed an incremental file adapatar based integration, now suppose I have new columns added in my file, do I have to create a new incrementa…
-
How to map missing values in integration in EPBCSSummary: I want to execute an integration wherein if the "Union" column is "APS" or "Unaffiliated" for example, then the "Salary Grade" field for it will be blank. I was…Suravi 47 views 10 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform