My Oracle Support Banner

Not able to Define a Criteria when a DATE Data Type Column Is NULL in the queue selection criteria (Doc ID 2712946.1)

Last updated on SEPTEMBER 23, 2020

Applies to:

Oracle Financial Services Lending and Leasing - Version 14.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Not able to criteria in queue selection when DATE is NULL. 

In Queues > Customer Sevice > Selection Criteria Screen.

Add a criteria: PDC END DATE IS NULL.


ERROR
-----------------------
Message from Alert log:
OFSLL Error Msg : Incorrect Value for Datatype DATE
Ora Error Code : 1858
Ora Error Msg : ORA-01858: a non-numeric character was found where a numeric was expected
Context : Incorrect Value for Datatype DATE
Context : Error in : uquprc_el_100_02.check_type2operator

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

1. Queues > Customer Sevice > Selection Criteria Screen.
Add a criteria: PDC END DATE IS NULL.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users not able to add a NULL criteria for data type DATE in queue selection

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.