Data Integration
Discussion List
-
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 26 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 9 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 31 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 64 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 25 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 26 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 57 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 35 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 27 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 67 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 54 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 164 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 54 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 18 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform