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 MARCH 14, 2022

Applies to:

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


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(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(

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




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

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