My Oracle Support Banner

When Attempting To Reverse a Termination Of An Employee Using apps.hr_ex_employee_api.reverse_terminate_employee, Get Error ORA-06512: at APPS.PERALLASSIGNMENTSF_98U_DYT (Doc ID 2475509.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to reverse termination using apps.hr_ex_employee_api.reverse_terminate_employee, the following error occurs:


 
ERROR
-----------------------
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "APPS.PERALLASSIGNMENTSF_98U_DYT", line 109
ORA-04088: error during execution of trigger
"APPS.PERALLASSIGNMENTSF_98U_DYT"
ORA-06512: at 'APPS.HR_EX_EMPLOYEE_API', line 2940



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Using hr_ex_employee_api.reverse_terminate_employe

2. Test

"
begin
  apps.hr_ex_employee_api.reverse_terminate_employee
  (
  p_validate => false,
  p_person_id => person_id, --Required
  p_actual_termination_date => to_date('01-aug-2018','DD-MON-YYYY'), --Required
  p_clear_details => 'Y' --Required
  );
  end;
"

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.