My Oracle Support Banner

Error In DB Adapter When Importing A Database Table For Merge Operation (Doc ID 2621739.1)

Last updated on JANUARY 06, 2020

Applies to:

Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.


When importing a table using the Database Adapter endpoint for a merge (insert or update) operation, there isn't an option to define the Primary key.

This contradicts the current 'What You See on the Manage Tables Page' section of the Database Adapter documentation, located at:
According to the documentation, the Primary Key field can be defined in the endpoint using the displayed chart that:
  "Appears when you select tables without a primary key defined. Select the virtual primary key for the table."


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.