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 APRIL 16, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms