My Oracle Support Banner

In SSHR When Hire a Future Dated Applicant, Error Occurs - oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found (Doc ID 2086709.1)

Last updated on JULY 07, 2020

Applies to:

Oracle Self-Service Human Resources - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.
hrutlmss.pkb
hrutlmss.pkh

Symptoms

On:   12.1 HRMS RUP6 version, Hire, CWK Placement, Appl Hire

When attempting to hire a future dated applicant, the following error occurs.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.HR_UTIL_MISC_SS", line 2360
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:722)


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

1. Manager Self-Service responsibility
2. Applicant Hire and Rehire
3. On the Search page, enter the Applicant's Last Name and in Effective Date field enter a Future Date (Example, the applicant record has a Start Date of 01-DEC-2015, so entered Effective Date as "02-DEC-2015")
4. Click on Go button.
5. In the search results table, select the person record and click on Hire.and the 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.