My Oracle Support Banner

ARGUS Advanced Condition (AC) Is Not Querying All The Expected Cases As Per Defined Criteria for Family ID which is Null (Doc ID 2047451.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Argus Safety - Version 7.0.2 and later
Information in this document applies to any platform.


When using an Advanced Condition (AC) Argus query is not displaying all the cases as expected per the defined criteria
Using the AC to query all cases where the Product Name = 'ABCD'

When viewing the generated SQL, all cases must have the same Family_ID.

Some cases with the Product Name = 'ABCD' are returned using the AC.

Looking at these cases in the CASE_PRODUCT table the Family ID is Null.

How is the CASE_PRODUCT.FAMILY_ID field populated?


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.