Qlik Replicate and Oracle source endpoint: Unique Index not showing up in Qlik Replicate GUI

[john_wang]

While working with the Oracle source endpoint the Unique Index is not displayed in the Qlik Replicate GUI console.

The source table creation SQL statement is as below:

CREATE TABLE FBI2 (ID INTEGER, NAME1 CHAR(20), NAME2 CHAR(20), NAME3 VARCHAR2(20));
CREATE UNIQUE INDEX FBI_IDX2 ON FBI2(NAME1, NAME2, NAME3 DESC);

Environment:

• Qlik Replicate All versions
• Oracle All Versions

Resolution

In the provided sample, the unique index is created as a function-based index. The DESC (default is ASC) property applied to NAME3 makes the index a function-based index (FBI). When querying the table index information, it's clear that the “SYS_NC00005$” field replaces the actual underlying field “NAME3”.

This is a limitation in the Oracle source endpoint, see Function-based indexes are not supported.

Hence the Unique Index cannot show up in the Task Setting GUI.

Internal Investigation ID(s)

Case #00168364