Data Integration
Discussion List
-
Budgetary control integration from EPM to ERP unexpected behaviorHello team, We are running into some difficulties while configuring Budgetary Control integration between EPM and ERP. As far as I understand, to be able to see the Budg…
-
EPMAT-1:EPMFDM-ERROR: 'periodName' parameter format is invalid.Summary: Content (please ensure you mask any confidential information): Hi all, As specified in the Oracle Documentation,I'm trying to use the periodName parameter in EP…
-
Scheduling job for cross application data mapsHi, With the recent support for cross data maps push to remote application, I am not able to see such data pushes under Data Maps in Jobs scheduler. Is there any securit…Loganathan Nachimuthu 41 views 4 comments 0 points Most recent by Loganathan Nachimuthu EPM Platform and Freeform
-
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…
-
DM NZP: How to keep zero values and ignore blank valuesHello, During data integration, if I define NZP in import format, as expected it disabled zero suppression, meaning all zero values are imported from source. This also f…Vijay Mahantesh-Oracle 11 views 4 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Data File rename in EPMDear Experts, We are moving file from SFTP to EPM application using REST API. As a next step we want to rename those files once it got moved to EPM overview. Is there an…
-
Rest API queriesSummary: 1.Oracle recommendation on the most efficient way to export files via Rest API. We are planning to use Pipeline to export data (job setup to export data) - then…Muruges89 21 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data Exchange Quick Mode Import Failing due to unknow membersHi, I am loading data using Quick Mode, but the job is failing due to unknown members. Since there are a large number of unknowns (around 5,000 records), it's not feasib…MohanJ 11 views 4 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
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…
-
Planning data exchange power user with Administrator role cannot run integrationSummary: Content (please ensure you mask any confidential information): Hi all We have applied to the Power user the new Integration role of Administrator so we can run …
-
Linking Source Documents in Cell text – Transferring and Using Document URLs from Source SystemsSummary: We’re currently exploring a scenario where, in addition to transferring numerical data from our source systems, we also transfer hyperlinks pointing to the unde…Bjoern Schumacher 11 views 1 comment 0 points Most recent by Bjoern Schumacher EPM Platform and Freeform
-
How to export data from TPROCESSLOG table data managementIm trying to create a process with sql qurey on maintenances tables (Like TPROCESSLOG, TPARTITION and others) to export data to a file . This is to get process details h…
-
How Does Data Integration Order Columns for Load?Summary: How does Data Integration order the columns for load? Content (please ensure you mask any confidential information): We are integrating some data from an on pre…
-
Creating Integration in EPM to extract data to FDISummary: We are trying to following this Doc: to load data from EPM into FDI. However, when our EPM user goes to create an integration (Step 1), they are also asked to c…Sera Hager 22 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
How to update time zone on email sent by no.reply@epm.oraclecloud.comwe have built pipelines which sends email on completion, but the emails it sends is showing different time(GMT) though we changed user preference for service account tha…
-
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 21 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 1 view 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?"
-
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 61 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 21 views 1 comment 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform