My Oracle Support Banner

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

Last updated on MARCH 27, 2020

Applies to:

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


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



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

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