Able to create Two primary assignments (Doc ID 2151673.1)

Last updated on AUGUST 25, 2017

Applies to:

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

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

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