My Oracle Support Banner

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

Last updated on JUNE 25, 2022

Applies to:

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

Symptoms

On : 11.13.22.04.0 version, Analytics

ACTUAL BEHAVIOR
---------------
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

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

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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