Effective Sequence is Not Increasing Automatically in Job Data when Additional Assignment is Created: 'Error while updating the employee's additional assignment with Empl Rcd 1. (1000,1343) ' (Doc ID 1998554.1)

Last updated on JANUARY 26, 2024

Applies to:

Symptoms

On Job Data page create an additional assignment for an employee with the Employee Record 1.

Then the Job data with the employee record 0 is terminated with the same effective date as the additional assignment date. The Additional Assignment should be terminated automatically with effective sequence 1 from Job Data page but the below error occurs:

Steps to replicate the issue:

1.  Navigate to Main Menu >> Workforce Administration >> Job Information >> Add Additional Assignment
2. Create a new assignment for an employee. The employee record is 1 for the additional assignment
3. Navigate to Main Menu >> Workforce Administration >> Job Information >> Job Data
4. Open the Job data of the above employee for employee record 0.
5. Terminate the employee with the same effective date for employee record 0.
   
   

Cause

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