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
-
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… -
How to connect to OCI Services (Ex: OCI Queues)Summary: We would like to configure OCI Queues as a data source in OCI DI. Only option to use "Generic REST" as data source. Generic REST is limited to Basic Auth or OAu…
-
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 …
-
Performing selecting query in DB2 adaptor using OIC is erroring out.Summary: Performing selecting query in DB2 adaptor using OIC is erroring out. Performing an operation on a table. operation = select query is giving below Error Message …
-
Is there any way to call multiple Load Plans from different servers and agents one after another?Summary: Is there any way to call multiple Load Plans from different servers and agents one after another? Content (required): We are having a requirement like to call m… -
BICC - Does BICC have the abiity to identify purged data?Summary: We'd like to incorporate BICC for data extraction where possible but I have not seen that BICC can handle purged data. For example, if there is a cancelled work…
-
Using ODI and ADW as source can we generate Parquet file as outputSummary: Using ODI and ADW as source can we generate Parquet file as output ,if yes any support document on same. -
How to integrate Kafka with ODI 12c Market Place and bring data to ADW DBSummary: We have a new requirement where we need to integrate Kafka to ODI 12c Market Place. Content (required): I went through this document where it is mentioned how t…
-
ODI CS to ODI MP migration pathSummary: We have a customer on ODI CS, who are looking to migrate to ODI Market Place (since ODI CS is being sunsetted). Seeking advice on the best approach to migrate f… -
ODI source connection supportSummary: We are trying to check if ODI supports connectivity to the oracle sources listed below - 1.CPQ 2.Oracle Field Service(OFS) 3.Global Trade Management. Looking fo…
-
Real time replication of data from FusionSummary: Is there any solution/product available that allows replication of data from Fusion ERP using Golden Gate Services? Content (required): Version (include the ver…
-
Fusion Middleware (FMW) 12c updateSummary: Customer will receive their 22A update with 22B in May 2022, including the Fusion Middleware (FMW) 12c update. Content (required): Will there be any potential i… -
ODI Salesforce integrations are very slow, looking for performance enhancement possibilitesSummary: We have an integration setup using ODI, which extracts data from Salesforce. While it works fine, the processes take a long time to run. We created equivalent p…
-
How to retrieve deleted records from Salesforce through ODISummary: We have integrations in ODI which connects to Salesforce(using JDBC), and, extracts data to load into ADW. However, the deleted records on Salesforce are not be…
-
Setting prune time for a PVO extraction using Fusion BICCCSummary: We need to extract Fusion PVO data using BICCC job. We will be creating a job in Fusion BIACM and trigger that job from ODI and load data into ADW. We have a re… -
Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only … -
Improve productivity with Oracle Cloud Infrastructure Data Integration’s latest release - Nov 5 2021New blog about OCI Data Integration’s newly released: https://blogs.oracle.com/cloud-infrastructure/post/new-oci-data-integration-release-adds-support-for-hierarchical-d…
-
Fast-track data discovery with new release of Oracle Cloud Infrastructure Data CatalogContent We’re excited to announce a new release of Oracle Cloud Infrastructure (OCI) Data Catalog. In this release, we accelerate the cataloging of your data by automati…
-
How to upload files to UCM with encryption in OIC and also submit Load interface file for Import forSummary Any idea for encryption / decryption steps, that needs to be followed in the OIC?
-
How to download Import Projects Report from Fusion using OICSummary How to download Import Projects Report from Fusion using OICContent Hi Folks, I have created FBDI Integration and its callback for Projects (PPM Interface) using…
-
Purge Logs in ODI from marketplaceSummary Purge Logs in ODI from marketplaceContent Hi, Do we have odiPurgeLog Utility in ODI marketplace. Can you please confirm whether ODI marketplace has all the featu…
-
API end-points for AccountsSummary Are there REST APIs available to get Account Groups, Account Segment values and Account Combinations?Content I am investigating REST APIs for Oracle Financials C…
-
ODI RCU repository creation in ATPSummary How to create odi repositories in ATPContent Hi Team, I want to create ODI repository schemas in ATP DB , But it is not allowing with Admin user as it needs SYS … -
Audit logs for ODI instance in OCISummary Audit logs for ODI instance in OCIContent Hi Team, I have created a ODI VM in compute node by using marketplace odi image, I am able to login from my machine usi…
-
ATP repository connection in ODI CSSummary How to connect ATP repository in ODI CSContent Hi Team, I have provisioned ODI MP Image with ATP to store the repository, but when I launch the odi studio and co…
-
ODI-Read files from SFTP ServerSummary ODI-Read files from SFTP ServerContent Hi , We want to read the files from SFTP server and process in ODI. Is there any way we can read the file content directly…
-
Load Pending Worker through HDLSummary Load Pending Worker through HDLContent Hi All, Can anyone send me the sample HDL dat file to upload pending worker in Fusion? Thanks, Ankur Version Fusion R13 -
Any sample HDL data on Goal AlignmentSummary Any sample HDL data on Goal AlignmentContent Can anyone please provide sample HDL data on goal alignment
-
Import Questions via HDLSummary Import Questions via HDLContent Hi, Can someone please help on how to upload Questions (For Questionnaire) through HDL in Fusion? Regards, Vivek R S -
Request a sample script to import data into ERP CLOUD from On-Premise EBSSummary Request a sample script to import data into ERP CLOUD from On-Premise EBSContent Hi, Could you provide a very simple script or store procedure to show how to cal…