My Oracle Support Banner

Unable to Query DateTime Fields with Is Null or Is Not Null (Doc ID 2670196.1)

Last updated on MAY 14, 2020

Applies to:

Siebel CRM - Version 20.3 and later
Information in this document applies to any platform.


On : 20.3 version, Client Functionality

Query on Date Field with IS NULL condition gives incorrect data

The issue can be reproduced at will with the following steps:

1.Go to Service Requests > All Service Requests or My Service Requests.
2.Create 2 new service request records with default fields populated.
3.Expose 'Opened' (Date Opened) and 'Closed' (Date Closed) in List Applet using Menu > Columns Displayed.
4.Click on Query and enter IS NULL in 'Date Opened' in Form applet andhit Enter.
5.Expect 0 rows returned, but 2 rows returned which is incorrect.





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.