ARGUS Advanced Condition (AC) Is Not Querying All The Expected Cases As Per Defined Criteria for Family ID which is Null
Last updated on DECEMBER 08, 2015
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?
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