Relationship Search Returns Duplicate Rows (Doc ID 2524211.1)

Last updated on DECEMBER 04, 2019

Applies to:

Symptoms

Actual Behavior

Attempt to execute relationship Search with relationship.General Info
Attribute, it returns duplicate rows as following.

<Result> 7 rows selected
Number Text02 Number Name
12001 A A 12001-A-A
12001 12001-A-
12001 T T 12001-A-T
12001 A A 12001-A-A
12001 T T 12001-A-T
12001 A A 12001-A-A
12001 12001-A-

If execute relationship Search with relationship.page three attribute, it
returns correct rows as following.

<Result> 3 rows selected
Number Text02 Number Name
12001 T T 12001-A-T
12001 A A 12001-A-A
12001 12001-A-

Expected Behavior

relationship Search with relationship.General Info Attribute,
it should return same results of  relationship Search with relationship.page three attribute.

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

1.  Relationship Search with relationship.General Info Attribute

Cause

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