Filtering by aggregated fields built as calculated fields not working in BAM 12.2.1 (Doc ID 2203945.1)

Last updated on NOVEMBER 16, 2016

Applies to:

Oracle BAM (Business Activity Monitoring) - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms


Filtering by aggregated fields built as calculated fields is not working  

You have applied patch 24948985 which allows you to filter by aggregated fields on user view using simple fields.
For example the following filter is now possible on user view

    SUM(Amount) > 10000

Notice that Amount is regular field on the dataobject

The problem now is that if you define a calculated field which has aggregate functions, the filter on the user view using  "MyCalculatedField"  returns no results.

   MyCalculatedField > 1  

returns  "No data to display" even if there are records that match the criteria
and in the log files the following error is generated: ORA-00904: "NOOP": identificador no válido

ERROR
-----------------------
ORA-00904


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