My Oracle Support Banner

Validations on Custom Date Field errors out (Doc ID 2574044.1)

Last updated on AUGUST 07, 2019

Applies to:

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

Symptoms

On : 11.13.19.01.0 version, Opportunities

Bug on custom date field


They have two custom date fields – Project Start Date & Project End Date
They have build a simple field validation on Project end date to make sure that at any point project end date should not be less than Project Start date

They implemented this 2 years back and was working fine till now.


The behavior now is, when Project end date is one day less than project start date, no error messages are displayed (but should have displayed the message here), but when the end date is = start date or if the project end date is less than 2 days and further, error is displayed.




ERROR
-----------------------

Project End date should not be prior to Project Start Date



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Opportunity>edit opportunity
2. Summary sub tab>When Project End Date = Project Start Date, Error message is displayed
(Expected)
3. Screen shot 3: When End date is 2 days less or more, Error message is displayed (–expected.)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
The behavior now is, when Project end date is one day less than project start date, no error messages are displayed (but should have displayed the message here), but when the end date is = start date or if the project end date is less than 2 days and further, error is displayed.

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
Cause
Solution
References


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