Integration
Discussion List
-
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… -
Scenario dimension in free formI setup a free form application with 1 bso and 1 aso cubes enabled. During the app creating steps, I opted for Account, Entity and Period. I did not see an option for Sc… -
Workforce Utilization and Split Funded FTESummary: Hello Oracle, Can you please enlighten us on the process of integrating project data to workforce, utilization calculation as well as the split funded fte? Inte…
-
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 146 views 3 comments 0 points Most recent by Neil Rachh EPM Platform and Freeform -
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
-
Is Position Tree Code a mandatory selection in Loading Oracle HCM Cloud Metadata to EPMHello Experts, Hope you are doing well. As per the Oracle documentation it is mentioned that Position tree is needed to bring position metadata to EPM. Please confirm if…
-
When will Oracle drop support for TLS 1.2 on ERP Cloud and EPM Cloud?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Paul Skeldon-Member 53 views 6 comments 0 points Most recent by BalaR-Oracle EPM Platform and Freeform
-
Monitoring EPM Integration Agent healthSummary: Hello, I'm looking for a tool or method that proactively checks the health of the EPM Agent before running a Data Exchange integration. We use the EPM Agent to … -
Using encrypted key pair authentication to connect to Snowflake through integration agentSummary: We are trying to connect to Snowflake using a JDBC driver through integration agent. I've added the following to my .ini file: [AGENT_JDBC_CONNECTIONS] snowflak…bpepper 65 views 1 comment 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Drill through request for Exchange rates in EPBCSDrill through URL is currently not working for exchange rate when the source is NetSuite. Is it possible to drill through the fx rates from EPBCS when the source is Nets…
-
Data Exchange Workbench Source Period Dimension pull AmountSummary: Hi all, I'm encountering an issue in Workbench: the "Source Period" column is showing amounts instead of the period dimension. I've already mapped the "Dimensio…
-
EPM Data File does not show Import Format/Map and how to export this?Summary: When creating the data export to EPM Data File there is no option to upload Dim names as a CSV. Once a target app is created as EPM data file it does not allow …Narayan 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Upload file REST .out file - POSTMAN Vs Manual uploadSummary: Upload file REST .Out file - POSTMAN Vs Manual upload behaves different. POSTMAN upload of .out file is successful but when same .out file tried for manual uplo…
-
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… -
When loading 0 rows, the system indicates its an errorSummary: We have recently created a pipline for data to flow between applications. But sometimes a data load rule inside of the pipeline does not contain any data. The s…Pieter-Jan Vandendriessche 52 views 4 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Impacts of adding a new dimension to an ASO and BSO cubeSummary: We are required to add a new dimension to an ASO and BSO cube that has 5 years worth of data. On the refresh database it clears out all the existing data. What …Amrutha Muraleedharan 61 views 4 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform -
How to update consolidation operator for "Not used for Cube"Summary: We need some help to pass the correct value in the integration to update the consolidation operator as Not used for Cube. Content (please ensure you mask any co…Tabish Neyaz 61 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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, …Dinesh Chand 227 views 6 comments 2 points Most recent by Anandita Biswas-Oracle EPM Platform and Freeform -
How to connect Data Exchange Integration Agent to a Google Cloud SourceSummary: I would like to know if there is a path to connect the Integration Agent to a Google Cloud hosted database Content (please ensure you mask any confidential info…MyNameisMyName 13 views 1 comment 0 points Most recent by DavidPieczonka17 EPM Platform and Freeform
-
Data load from Autonomous DB to EPM fails through AgentSummary: When loading data from ADW to EPM the extraction step fails for the input at service name. 'unable to resolve' Content (please ensure you mask any confidential …
-
How to load multiple journal entries by using Journal Template (Downloaded from Workbench)Summary: In FCCS Instance, I am trying to load Journal Data through Data Management by using Standard Template which is downloaded from Data Load Workbench, but I'm unab…
-
Error validating mapping in data managementSummary: When creating/adjusting some mappings, I am suddenly unable to validate the mappings in data management. I get this error: "Unable to retrieve members. Either t…Pieter-Jan Vandendriessche 25 views 2 comments 0 points Most recent by Pieter-Jan Vandendriessche EPM Platform and Freeform
-
blocking of extension querySummary: Content (please ensure you mask any confidential information): Hi all I have a question about this new restriction in teh 25.04 release: 1. the mentioned link d…
-
EPM Agent Automatic Vs Manual - Neither works when run as ServiceSummary: EPM Agent automatic does not work for scheduled jobs but whereas when set as Manual it works. Is there any issue with Agent running as a service when set to Aut…
-
Simultaneous run of 2 data load rules and the 'concerning' error messageSummary: Simultaneous run of 2 data load rules and the 'concerning' error message Content (please ensure you mask any confidential information): We do have data load rul…
-
Open Batch behaves differently for PCM and EPCM, but both are under common DM and follows same URLSummary: Open Batch behaves differently for PCM and EPCM, but both are under common DM REST and follows same URL then why is this inconsistent? Content (please ensure yo…
-
25.03 Update - Data Integration Access ChangesSummary: I am seeing changes in Data Integration Access with 25.03 update in our Test environment. Content (please ensure you mask any confidential information): I am se… -
Pipeline in ARCSSummary: we wanted to understand the below things. 1. we cant see the pipeline option in data exchange in ARCS. so Pipeline is not supported in ARCS 2.If its not support…Santiago Belaus 89 views 1 comment 1 point Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Extracting the file from OCI using PythonHi All, We have a requirement where we have create a bucket and upload the file from EPM. Step 2 : From Bucket another team will extract the file using the python script…