ORA-20001, ORA-06512 Error When Reconsider Application for an Employee Applicant who has a Future Dated Termination (Doc ID 1315340.1)

Last updated on JULY 12, 2016

Applies to:

Oracle iRecruitment - Version 12.1.2 and later
Information in this document applies to any platform.


When attempting to reverse terminate an application for an employee applicant who has a future dated termination, the following error occurs:

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001:
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 607
ORA-06512: at line 1

## Detail 0 ##
java.sql.SQLException: ORA-20001:
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 607
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Login to the application and select US HRMS Manager responsibility.
2. Query for an employee and terminate on a future date (for example, terminate1 year after the system date).
3. Launch the employee site visitor page and login as the above employee as mentioned in step 2.
4. Search for a job and apply for that job.
5. Login as the recruiter of the above vacancy in which the employee applicant has applied.
6. Navigate to the vacancy tab and search for the above vacancy.
7. Navigate to the View Applicants for the vacancy page.
8. Click on the employee applicant name and navigate to the Candidate Profile - Applications tab.
9. Change the status of the Application to "Terminate Application."
10. Save the record.
11. After the employee applicant is successfully terminated, recruiter tries to reconsider the application.  Navigate to the vacancy View Applicants page, check the Rejected Applicants checkbox and click on GO button.  This will return the above employee applicant who has been terminated.
12. Select the applicant record and click on Reconsider Application button.
Go through the steps and while submitting the transaction, the application shows an error message.


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