Whenever Main Appraiser Set the Vacation Rule And Appraisee Trying Submit the Objective The Error "ORA-01403: no data found" Received
(Doc ID 3047784.1)
Last updated on SEPTEMBER 17, 2024
Applies to:
Oracle Performance Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
When main Appraiser set the vacation rule and Appraisee trying to submit objective through Employee Self Service the following error occurs
ERROR
-----------------------
" You have encountered an unexpected error. please contact your system administrator for assistance"
Exception Log show the below
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.HR_WPM_NTF_UTIL", line 367
ORA-06512: at "APPS.WF_NOTIFICATION", line 4357
ORA-06512: at "APPS.WF_NOTIFICATION", line 4236
ORA-06512: at "APPS.WF_NOTIFICATION", line 3596
ORA-06512: at "APPS.WF_NOTIFICATION", line 3457
ORA-06512: at "APPS.WF_NOTIFICATION", line 4136
ORA-06512: at "APPS.WF_NOTIFICATION", line 4309
ORA-06512: at "APPS.HR_WPM_NTF_UTIL", line 299
ORA-06512: at line 1
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:998)
## Detail 0 ##
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.HR_WPM_NTF_UTIL", line 367
ORA-06512: at "APPS.WF_NOTIFICATION", line 4357
ORA-06512: at "APPS.WF_NOTIFICATION", line 4236
ORA-06512: at "APPS.WF_NOTIFICATION", line 3596
ORA-06512: at "APPS.WF_NOTIFICATION", line 3457
ORA-06512: at "APPS.WF_NOTIFICATION", line 4136
ORA-06512: at "APPS.WF_NOTIFICATION", line 4309
ORA-06512: at "APPS.HR_WPM_NTF_UTIL", line 299
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
The issue can be reproduced at will with the following steps:
1. Login to Employee Self Service
2. Navigate to Performance Management --> Set Objective
3. Click on the Set Objective Task
4. Select the necessary Objective and click on Finish
5. The error is showing as above
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 |
References |