Data Integration
Discussion List
-
EPM Integration Agent: Connection Timed outHi Everyone, We are currently facing an issue at the client side with the EPM integration Agent. When attempting to connect to the cloud we are getting the "connection t… -
"ODMC" (oracle demand management cloud) to EPM integration feasibilitySummary: We are trying to integrate from "ODMC" (oracle demand management cloud) to EPM. But we are not seeing direct integration feasibility let us know any feasibility…
-
OAuth POST method not workingWe are doing App to App integration in EPM. We are using OAuth 2.0 Client Credentials for Authentication. We have created Confidential APP and are able to get access tok…
-
Data is getting loaded partiallyWhen loading data to freeform BSO cube through file based integration, partial data is getting loaded. For one our dimension, example member name is LVMH TEST and in the…
-
Data Integration-Global Periods error for RuntimeError: The Current Process Status '' is InvalidUsing a groovy rule to trigger a dataload rule that exports data to file. Rule prompts for scenario, version, entity. Start/End Year on Scenario drives periods to cycle …
-
Failing Drill-through from GL on pod 1 to pod 2Summary: Hello, I'm having an issue with the drill-through. Although I was able to successfully implement a drill-through from the GL to pod 1, my new drill-through is f…Zut Alors 22 views 3 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Is it possible to decrypt a PGP encrypted file available in EPBCS data exchange inbox?Summary: We are getting PGP encrypted employee data file from Workday. It is placed in SFTP folder. We plan on using the OIC to load that encrypted file to EPBCS inbox f…Ravinder Singh-63390 3 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Custom entity variable in pipelineSummary: We have the requirement to trigger the pipeline in FCCS in 2 times, once for a subset of entities, once for all a couple days later. Instead of copying the pipe…Pieter-Jan Vandendriessche 22 views 6 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
Can we load data if period and year are in rows and columns"This is the file format, and I want to load the data into the respective year and period. Could anyone please assist me with this?"
-
Java Version for EPM Agent and DriversSummary: I am trying to find out how the EPM Agent assigns the JAVA_HOME variable and if it will require a higher version of Java after the TLS 1.3 update, as well as wh…
-
Issue with Data Management MigrationSummary: I am receiving the below error when trying to migrate an Application from Test to Production Content (please ensure you mask any confidential information): I am…Matthew Gregory-137392 63 views 9 comments 0 points Most recent by Ramaguru B EPM Platform and Freeform
-
Drill Through between EPM Cloud: Planning to FCCS using Smartview Drill through optionSummary: Content (please ensure you mask any confidential information): Hi all We have an integration set up EPM Cloud and ERP and that works fine, but now we want to us… -
Add "Is Like" Mappings to Data Maps for Cross Application DataSummary: We are trying to simplify our export process from our Planning application to our Essbase application. Currently, we use data integrations to create export file…
-
Oracle-provided Google Cloud adapter available to facilitate direct interaction with GCPIs there an Oracle-provided Google Cloud adapter available to facilitate direct interaction with GCP services? Alternatively, is it necessary to purchase Oracle Integrat…SuneelKanthala 22 views 1 comment 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Data Exchange SecuritySummary: Need the ability to set up location security for a user to be able to run certain integrations, but then only view others. Content (please ensure you mask any c…Matthew Gregory-137392 13 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Can we use OTBI Reports to integrate the ERP application with EPM?Summary: Can we use OTBI Reports to integrate the ERP application with EPM instead of BI publisher to load the data from ERP to EPM Content (please ensure you mask any c…Santiago Belaus 24 views 5 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
How to export Period and Years dimension values from PBCS to ADB (EPM Integration Agent)Summary: Hi, I'm trying to create an integration in order to write back data from PBCS to ADB using the following procedure: https://docs.oracle.com/en/cloud/saas/enterp…
-
Configure EPMAgent to work with HTTPSSummary: Configure EPMAgent to work with HTTPS Content (please ensure you mask any confidential information): Currently the EPMAgent in the Cluster is connecting to the …Shantan Kumar-Oracle 31 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
How do you obtain last modified date for a data integration within data exchange within Freeform?We only see the last executed date within the data exchange screen and we our audit report does not pickup any modifications we made to the data integration. Looking to …C Vincent 15 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Does anybody have been able to create an extract for HCM Open requisitions to load into Workforce?Summary: We are in need to extract HCM Open Requisitions for EPM Workforce Planning. Content: We were able to connect to HCM and able to run the 8 predefined extracts: A…Marco Antonio Rossodivita 61 views 5 comments 0 points Most recent by Patricia-S-Oracle Recruiting, Opportunity Marketplace
-
Set Administration Mode in PipelineSummary: Set Administration Mode in a Pipeline fails Content (please ensure you mask any confidential information): Has anyone been able to set up an Administration Mode… -
Data Sign Flip based on Account attributeSummary: Hi, I'm writing a SQL map in Accounts to flip the sign of data being imported based on value of an account attribute. If the value for the attribute says 'Flip'…Neha_R 43 views 7 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Collision detected between two members from the same dimensionDear Experts, We are trying to load data into ASO cube using file based integration. Getting below error message at export stage. Collision detected between two members … -
Can we export data from EPM Planning in Parquet file format?We are working on exporting a large dataset from the EPM Planning application and loading it into a data lakehouse. The process would be significantly faster if we could… -
Request for Single REST API to Extract Fusion Project data for EPBCS IntegrationSummary: Dear Community, We are currently working on integrating Fusion Project Portfolio Management (PPM) data with EPBCS. Please note that due to application design co…
-
source expression transformation after CONCATHello, Currently, we have a client who is migrating from HFM to FCC, and they used to rely on FDMEE scripts to transform data during the import process Now, in Data Exch…
-
Issues with $START_PERIODKEY[YYYY]$: giving wrong yearSummary: I've implemented an integration, where I'm trying to leverage $START_PERIODKEY[YYYY]$ unfortunately for Dec-20 it gives me year 2021 but I would have expected 2…User_2025-02-03-23-55-06-250 152 views 3 comments 0 points Most recent by Neil Rachh EPM Platform and Freeform -
Oracle EPM: Encrypting Data exchange/integration connectionsDoes Data exchange support a custom password encryption methodology for updating EPM cloud based connections? If not, is there a way to rather use Security wallets for a…
-
Access Asset Description in writeback outbound integrationSummary: Hi, I have created a writeback outbound integration to write data from the OEP_CPX cube to a table in the On premise database with the help of EPM Integration A…Anoop Vengalil 51 views 7 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Loading Dates to ASO Cube Through Data ExchangeSummary: We are trying to load dates directly to an ASO cube through Data Management and they do not seem to be getting loaded. Content (please ensure you mask any confi…