The Active Now option does not work properly with Time Filter Expression (Doc ID 1180955.1)

Last updated on APRIL 06, 2011

Applies to:

Oracle Application Server Integration BAM - Version: 11.1.1.2.0 and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.

Symptoms

When a report/alert consists of an entry on datetime/timestamp fields and having "Active Now" option checked, along with other entries, Active Now entry is evaluated first and the other entries are AND'ed with it.

In other words, it will always be (ACTIVENOW ENTRY) AND (REST OF THE ENTRIES)

Consider three entries in a filter like:

C1: col1 is equal to value1
C2: time_col is within the current time period current YEAR
C3: col2 is equal to value2
(C2 is entry with active now condition)


Using headers and entries if the configuration is like:

C1 AND (C2 OR C3)


It will be evaluated as C2 AND (C1 AND C3)

Other examples:
an expression like C1 OR C2 OR C3 will be evaluated as C2 AND (C1 OR C2)

Cause

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