Appraisal Notification Error: Two Appraisals, Same Dates, Same Day Approval (Doc ID 2784354.1)

Last updated on JUNE 15, 2021

Applies to:

Goal

Error Message: Success 1 - Yes  ORA-20001: This date already exists. Please enter a new date.

The failure message on the notification appears on the notification when two appraisals for the same period are approved for the employee on the same date. Ideally there is no need to complete the two appraisals for the same period for an employee and approved on the same date. But the system does allow to do the same and the details are also getting saved to the database. However, the failure message is being reported incorrectly on the 2nd notification when both the appraisals are completed on the same day.

==

Create two appraisals via Manager Self Service  for one employee same dates
Approve both on the same date
Error: Success 1 - Yes  ORA-20001: This date already exists. Please enter a new date.

The issue is system allows them both to be created but generates an error on the notification for the second appraisal
 

Solution

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