The Number of Distinct Variants for the same Genomic Query Changes in Result summary

(Doc ID 2155314.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Healthcare Translational Research - Version 3.1 and later
Information in this document applies to any platform.


On Oracle Healthcare Translational Research (TRC) 3.1 version,

The display of distinct variants for the Genomic Query are different for the same query in the Result summary if the query is executed in different days.
When the Genomic Query is executed the Result summary shows different DISTINCT VARIANTS COUNT even though the number of rows are the same.

It would be expected that the distinct variants for Genomic Query should not change when the query is executed during different days.

The issue can be reproduced with the following steps:
1. From Cohort Explorer, go to "Genomic Query" / "Variant Search" subtab;
2. Perform a Query after the following criteria:
  - Expand 'Variant Location'
  - Ad-hoc List: PIK3CA
  - in Gene Region: within Start to End;
  - Assembly Version: GRCh37
  - DNA Reference Version: ENSEMBL_RELEASE75
3. Submit the query.


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