Unable To Select Multiple Database Schemas On OEMM 12.2.1.1 Oracle Database (Via JDBC) Bridge (Doc ID 2195668.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Enterprise Metadata Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

There are two issues related to schema selection being observed in the OEMM 12.2.1.1:

First: When creating a Oracle Database Model, when clicking in the magnifier in the Schema properties, this brings the list of schemas to be harvested. When selecting multiple schemas, the "Select" button did not became available.

Second: When entering one schema manually, and then clicking in the magnifier, it's possible to select multiple schemas and the "Select" button becomes available, but, the additional schemas do not get transferred to the bridge.

Steps to reproduce:

1.) Create a Oracle Database (via JDBC) model.

2.) In the "Schemas" parameter, click in the magnifier. The list of the schemas will show. Select one or more schemas.

3.) It's not possible to click in the "Select" button.

Or:

1.) Create a Oracle Database (via JDBC) model.

2.) In the "Schemas" parameter manually enter on schema, i.e.: SCOTT.

3.) Then click in the magnifier. The SCOTT schema will be auto-selected.

4.) Select additional schemas.

3.) Click "Select" button. The additional schemas did not get moved to the bridge "Schema" parameter.

 

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms