Filtering by aggregated fields built as calculated fields not working in BAM 12.2.1
Last updated on NOVEMBER 16, 2016
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
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