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 18.104.22.168.0 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