My Oracle Support Banner

Updates to Advanced Condition from User Interface (UI) sets the CFG_ADV_COND.WHERE_CLAUSE value to Null (Doc ID 3027110.1)

Last updated on JANUARY 08, 2025

Applies to:

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

Symptoms

If any advanced condition (AC) is updated via the User Interface (UI), the WHERE_CLAUSE column under the CFG_ADV_COND table is set to NULL for the corresponding query sets which involve the advanced condition being updated. For example, one AC is used in 10 Query Sets and when that AC is updated from the front end, the WHERE_CLAUSE of those 10 query sets becomes null in the CFG_ADV_COND table.


This behavior shouldn't impact other areas of the application using the same AC (For example: Reporting Rules, Aggregate Reports)  since WHERE_CLAUSE gets auto populated during run time.


Cause

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
Symptoms
Cause
Solution
References


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