Data Integration
Discussion List
-
Issue with Period Mapping in Data Management - Source-Period Column Showing Amount Instead of PeriodHello All, We are integrating data between two PBCS PODs. Our goal is to map data from the Jan-Dec periods to 'No_Month' in the target POD. To accommodate this, we have … -
Data Load Rule "Date format for date data" ignored for User Preferences date formatSummary: The "Date format for date data" setting in a Data Management integration is being ignored and the user running the integration user preference date setting take…
-
How can I use one integration across more than one scenario?Summary: Suppose I have created one integration for actual category to load data into my reporting cube from financials, but I want the same integration to be used acros…Suravi 51 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Can we increase the precision in data management data load file.Summary: We are running to load exchange rates from data management, however we came to a problem where we are trying to load 15 decimal, but it is loading only up to 6 …
-
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 14 views 2 comments 0 points Most recent by Odin Mjølsnes EPM Platform and Freeform
-
Direct integration to pull a BI report from Oracle Cloud ERP and load it to ARCS is failingI am trying to create a direct integration to pull a BI report from Oracle Cloud ERP and load it to ARCS. Extract and import steps are getting succeeded. Getting warning…
-
Invalid Credentials Error - Data Exchange (non-blocking)Summary: Since last update (25.07) we regurlary get an error in data exchange regarding credentials. Eventhough the error is there, the integrations run perfectly. I was…Pieter-Jan Vandendriessche 13 views 3 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Data Exchange how to load one cell to multiple cells in FCC ?Summary: In a data load file I have movements that needs to be loaded to both the FCCS_ClosingBalance_Input member and a specific movement member. How can I load to two … -
DELETE sql statement for on-prem databaseSummary: Has anybody found a way to run a DELETE sql statement before exporting data to an on-prem database using Data Integration? In Applications, there is field that … -
When testing strong ciphers with EPMAgent, 401 Unauthorized receivedSummary: We are in the process of testing our strong cipher set ups per the Oracle documentation here: How to Test with the Latest TLS Ciphers The documentation indicate…
-
Object Storage Large File SegmentingWe are looking to use Object Storage as a file staging zone for data extracts going to external systems that can readily retrieve files from Object Storage. To do this w… -
The substitution variable DataLoadConsolMember is not working as expected.We have two DLRs: one for overrides and one for trial balance (TB) load from ERP. First, we load the overrides data, which successfully appears in FCCS. However, when we…Avani Makwana 28 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Issue while migrating file based data source application from one environment to another.Summary: Hello, I have registered a file as data source and have created a file based integration to import data into EPM application which is working as expected in the…Neha_R 21 views 5 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
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 12 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 34 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…