To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Data Integration
Discussion List
-
How to generate authentication token to pull the source files via API service calls using ODI12c ?Summary: Is there a way to generate and pass the authentication token dynamically for each file for the Restful API calls? Content (required): We need to pull json files… -
How can we import Master and Work repository with code components when present in multiple folders?Summary: Master and Work repository with code components present in multiple folders, how can we import to new instance in single go? Content (required): We have receive… -
Is on-prem ODI 12.2.1.3 needs to be upgraded to latest version 12.2.1.4 before migrating to Cloud?Summary: Hi Team, Customer is planning to migrate entire DWH to Oracle cloud. Currently we are using ODI 12.2.1.3 & Oracle 19c DB in an on-prem environment. I need to un…
-
Error while trying to delete ODI foldersSummary: An error was thrown while trying to delete some folders from ODI MP repository. It was thrown on both manual deletion and deletion via SDK. The folders have map… -
Hi team, we are planning to integrate Oracle golden gate using peoplesoft source systemSummary: we are planning to integrate Oracle golden gate using people-soft as source system for a customer to fetch the delta data. Content (required): We are planning t…
-
Pipeline with Conditional LogicSummary: Wondering if anyone has been able to achieve conditional logic inside of a Pipeline? Our goal is to create an ad-hoc execution of various different data loads t… -
Pass JSON as a startup parameter to ODI scenarioSummary: Hi team, We have a requirement to generate a JSON request in ODI, pass it to an API and log the same request details in a database table. We created an ODI proc…
-
recommendation for the VM of the ODI on Market PlaceSummary: Dear All Do you have any recommendation for the VM of the ODI on Market Place, please ? OCPUs, RAM, Disk etc. Content (required): Recommendation for the VM of t… -
Pass Url-encoded parameters when creating OIC REST ConnectionContent Hello, I am trying to access my client environment from OIC which requires an access token first. I am able to retrieve the access token from Postman successfull… -
New release of Oracle Cloud Infrastructure Data Integration adds connectivity to Oracle Fusion AppliContent New blog about OCI Data Integration’s newly released connectivity to Oracle Fusion Applications: https://blogs.oracle.com/cloud-infrastructure/load-and-transform…
-
JNPE error with Reusable Mapping ComponentSummary: Mappings having reusable mapping components throw a fatal validation error: JNPE at ReusableMappingComponent.findrmcattributeforsignatureattribute. Please check…
-
DB link feature works between On-Prem Oracle DB to Oracle ADW?Summary: We need to create a DB link between On-Prem database and Cloud (ADW) database, is there any specific steps we need to taken care before doing this? Or Could you…
-
How to change server time in ODI Market place.Summary: Hi we have ODI Market Place and the time zone is UTC, How to make it to UTC + 3. Content (required): Hi we have ODI Market Place and the time zone is UTC, How t…
-
Loading Data in FBDI Template file using ODISummary: Loading Data in FBDI Template file using ODI Content (required): Hi, Customer wants to load data into FBDI template file using ODI. Source is staging table (Ora…
-
Connecting Oracle Golden Gate Cloud Instance to Oracle Fusion Cloud(ERP/HCM) DATABASESummary: Data Replication from Oracle Fusion Cloud(ERP/HCM) DATABASE to Oracle Autonomous Data Warehouse Content (required): How can we leverage Oracle Cloud Golden Gate… -
Improve productivity with Oracle Cloud Infrastructure Data Integration’s latest releaseContent New blog about OCI Data Integration’s newly released: https://blogs.oracle.com/cloud-infrastructure/post/improve-productivity-with-oci-data-integrations-latest-r…
-
New Oracle Cloud Infrastructure Data Integration release adds pipelines and orchestrationContent We're excited to announce a new release of Oracle Cloud Infrastructure Data Integration. This release adds new transformations, connectors, and two of the most h…
-
ODI Marketplace PricingSummary ODI Marketplace PricingContent Could you please advise how pricing for ODI Marketplace works. Is it based on number of Topology connections or message based or C…
-
While Loading assignment details through HSDL we are getting errorSummary Error: Work terms records are required when you create or update assignmentsContent Hi, We are trying to update the assignment details through HSDL we have added… -
ODI PackageSummary ODI PackageContent Hi I imported a package in to ODI 11g,while I am checking I face some issue.Please help me by checking the below Screen shot "Linked objects a…
-
Moving ODI objectsSummary Moving ODI objectsContent Hi All, I am trying to moving interface from one project to another project in ODI 11g. Below are the my test cases I) i) I exported in…
-
Audit LogsSummary Audit LogsContent Hi All, I want retrieve ODI session/ Audit logs , is there any automation from ODI studio(ODI 11g) to generate logs Please help me to find out
-
OIC Gen3 Environment - Multiple integration failure due to internal server errorHello, we are seeing multiple OIC integration failure in our OIC gen3 environment today(8/12/25) due to internal server error with ejko cloud environment. They are all u…
-
ODI 14c - SOAP Web Service Connection IssueSummary: Hi Team, We are trying to set up ODI 14.1.2 - 250709 version on cloud . We were initially using ODI 12c on cloud. While setting up the Topology in 14 c for conn… -
IMOS - Oracle Fusion IntegrationSummary: Hello - Are you involved in (or aware of) any use case of Integation between IMOS (https://veson.com/products/imos/) and Oracle Fusion, where shipping activitie…
-
Can an EPM Agent AftExport Writeback Event Script return an error back to EPM Cloud Data Exchange?Summary: We are using EPM Integration Agent to writeback data from FCCS and PBCS integrations to an on-prem database table and then run a script in the Agent AftExport e…
-
Data encryption between HCM cloud and EPM cloud integrations using BIP ReportIs there any default data encryption used while pulling data from HCM cloud to EPM cloud using BIP Report and Data integrations?
-
Example of a BefExport.py that runs a SQL statement on an OnPremise Database before an ExportI am trying to export data from PBCS to an On-Premise Database using EPM Integration Agent. The Data Load Rule process works and it saves the data on the table. However,…
-
EPM Data exchange: unable to save data load ruleWe are facing two issues with regards to data load rules in data exchange (data load rule between to EPM environments/applications): We are not able so adjust and save e…
-
Is there a historical data store or PVO for Person Email Address?Summary: PVO for Person Email Address is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Email …