Able to create Two primary assignments (Doc ID 2151673.1)

Last updated on MARCH 19, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Customer is able to create 2 primary active assignments for the same person


EXPECTED BEHAVIOR
-----------------------
Correct functionality is to get error APP-PAY-07122. when attempting the step customer is doing.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applicant.Ex-Employee XXXXXX
2. Datetrack to 15-FEB-2016 - Create Placement> Contingent Worker
3. Save
4. Update .... (CWK # XXXXXXX)
5. Query XXXXXX - Person Type now Contingent Worker.Applicant.Ex-Employee
6. Datetrack to 20-FEB-2016
7. Others > End Employment
8. Reverse Termination (12-FEB-2016) > OK
9. Query person again... there are now 2 records for the employee



SELECT *
FROM per_all_assignment_f
WHERE person_id = XXXXX
AND primary_flag = 'Y'
AND trunc (sysdate) BETWEEN effective_start_date AND effective_end_date;

Changes

 None

Cause

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