Data Integration
Discussion List
-
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 21 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 11 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
-
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…
-
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 41 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 154 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…
-
Error while copying integrationDoes anyone knows what is this error? Error while copying integration:
-
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…
-
Building Reports Against the Data Integration SchemaThe Administering Data Integration documentation has a section that provides details of the data integration tables to help build reports. Here is the link to the sectio…ppant ppant 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Unlock by Location does not work in CLOUDSummary: I'm unable to unlock a single location once a period is locked. Steps are as follows: 1) In DM, under Application Settings, choose Target Application and then L…Debbie Schwind 1 view 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
What hampers performance of DLR (data load rule in data exchange)Summary: What hampers performance of DLR (data load rule in data exchange), there are only 6 rows of data.. but it takes 30 mins to push the data Content (please ensure …Subhojyoti Chakraborty 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data Integration can only select first 6 target Plan typesSummary: We have a Freeform application with 8 Plan Types. When creating a new data integration to load from a file we can only see the first 6 of them in the target Cub…
-
EPM Agent SQL parametersWe have this source query which is working well (see below), but we need to add a bit to update the period value. For example, if the EPM period (~Period~) is 02 then @P…
-
Data Management Mapping question - when two different categories of mapping for the same dimensionI need to set up a Data Management Load rule to transfer data from CPX to FIN cube in a custom Planning application. The source of the mapping must vary based on whether…Partha Sikdar 11 views 3 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
1remove restricted characters within data integration for attributesSummary: Current data integration Edit Source Expression functionality is limited with regards to Restricted Character handling Content (please ensure you mask any confi…
-
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 75 views 1 comment 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
groovy rule to track changed data to get entities loaded via data management in FCCSSummary: Requirement: We are currently looking to optimize our data load process and are looking for a way to track which entities have actually loaded to the applicatio…Amarnath_Kothapalli 21 views 3 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Looking for a way to use Azure service principal for connecting to EPMSummary: Hi, Looking for a way to use the Oracle EPM API through azure service principal instead of service account for authentication purpose? Found the below blog but …Tushant Pandey 1 view 1 comment 0 points Most recent by Abhinav Jain-Oracle EPM Platform and Freeform
-
Please advise on how to extract Data Management Workbench data before Logic Group logics are appliedSummary: We have a process to extract Data Management workbench data (using SQL query) for all the locations for any specific period. Our process is working fine. Genera…