My Oracle Support Banner

Optional Tab Table in Dashboard Using Advanced Search Displaying Duplicate Rows When Viewed (Doc ID 2916107.1)

Last updated on DECEMBER 21, 2022

Applies to:

Oracle Agile PLM Framework - Version and later
Oracle Agile Product Collaboration - Version and later
Oracle Agile Product Portfolio Management - Version and later
Information in this document applies to any platform.


Actual Behavior

Optional tab table in the dashboard showing duplicate rows when viewed.

Expected Behavior

Optional tab table in the dashboard not to show duplicate rows when viewed.

What Is Working

The same query does not show duplicated rows if the Output Fields are kept as default.
The same issue happens with Advanced Search when the same output fields are selected.


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

  1. Log into Web Client, and go to Dashboard > Optional Tab
  2. In the Dashboard Widget, click Configure
  3. Dashboard Widget Configuration screen appears.
    Set Table Name, and select Display Type: Table, and Next
  4. Select Advanced Search, and Define Query for Change Request subclass object, and Finish.
  5. Click Next.
  6. Select Output Fields, and add "Affected Items.Item Number" and "Affected Items.Revision" fields so it will look like below, and Finish:
    Affected Items.Item Number
    Affected Items.Revision
    Cover Page.Number
    Cover Page.Description of Change
    Cover Page.Status
    Cover Page.Workflow
    Cover Page.Change Type
  7. Search Result Shows up in the Dashboard Optional Tab's Table 1
  8. Click Number field to sort. See there are duplicate rows with the same values in all of the output fields.




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.