My Oracle Support Banner

OTBI Report Issue- Not Equal Filter Also Filters Out Null Values (Doc ID 2879317.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Oracle Fusion CX Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Analytics

OTBI report issue- Filter on leads extension attribute is not giving right output

Customer has a OTBI report on Marketing - CRM Leads.
When he adds a 'not in' filter on any column e.g. ("Marketing - CRM Leads"."Lead Extension"."Extension Attribute LOV 047") <> 'MARKETING'), it also excludes any null values for that column along with MARKETING

Adding a explicit filter such as this is working to give expected results :
AND (("Lead Extension"."Extension Attribute LOV 047" IS NULL) OR (DESCRIPTOR_IDOF("Marketing - CRM Leads"."Lead Extension"."Extension Attribute LOV 047") <> 'MARKETING')))

Customer wants to know why Null rows are excluded when filtering

Null rows should not be excluded when filtering out a particular value

The issue can be reproduced at will with the following steps:
1. Create report with simple filter with not in filter to exclude a value
2. Results show that output also excludes null rows




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.