Data Integration
Discussion List
-
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 4 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
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…
-
Data Integration Pipeline feature in ARCSSummary: Availability of Data Integration pipeline feature for ARCS Content (required): Currently the data integration pipeline feature is not available in ARCS. Any ide…
-
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…
-
Process Monitor Report Customized as per Client Requirement from Data ManagementSummary: Process Monitor Report Customized as per Client Requirement from Data Management: Business Requirement : User have 2 categories Actual_JD and Actual_AM where so…KinjalK 15 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 20 views 6 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
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 Export to File from EPBCS pulls in Amount for Source Period in Data ExchangeSummary: Hi All, I am trying to do a data export to file from EPBCS in data exchange. I have the export working in FCCS correctly for actual data and need to create the …Karla McMillan IBM 12 views 0 comments 0 points Started by Karla McMillan IBM 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?"
-
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 …
-
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 65 views 9 comments 0 points Most recent by Ramaguru B 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…
-
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 23 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 PatriciaS-Support-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 42 views 7 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
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 …
-
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…