My Oracle Support Banner

SQL Generated From Advanced Condition (AC) Does Not Exclude Deleted Events (Doc ID 2509463.1)

Last updated on JULY 13, 2023

Applies to:

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

Goal

Created an Advanced Condition (AC) for Query based on Events
When using this AC through Argus the returned results excludes deleted events (Expected).

When using the generated SQL for this query (AC) the returned results includes the cases with Deleted events (Not Expected)

How to exclude Cases with Deleted Events when using SQL Query generated from (AC)?
 

Solution

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
Goal
Solution


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