Two Active Primary Assignment Records At The Same Point In Time In Table PER_ALL_ASSIGNMENTS_F

(Doc ID 2198110.1)

Last updated on OCTOBER 12, 2017

Applies to:

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


On 12.1+ Production with PER and PAY fully installed with US legislation installed for PER and PAY.

When rehiring the employee 'prior to the Final Process Date'
Primary Terminate Assignment record is not end dating and creating a new
non-Primary Terminate Assignment record
which leaves two primary assignment records open during the same time period.

Customer is having this issue using both Assignment form and when using api

peempapi.pkb version 120.8.12010000.11

Form is PERWSHRG.fmb version 120.37.12010000.33

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

1. HR responsibility

2. People >
Enter and Maintain >
People screen >
Others button >
select End Employment >
Terminate screen >
Terminate employee >

Rehire employee prior to Final Process Date.
Find two Active Primary Assignment records at the same point in time.


Periods of Service details (PER_PERIODS_OF_SERVICE)

Period Busi-
of ness Accepted Actual Final
Service Group Date Termination Termination Process
id id Start Date Date Date
------- ------- ----------- ----------- ----------- -----------
780000 99 06-APR-2016 12-APR-2016 12-OCT-2016


Periods of Placement details (PER_PERIODS_OF_PLACEMENT)

Period Last
of Standard Actual Final
Placement Date Process Termination Process
id Start Date Date Date
--------- ----------- ----------- ----------- -----------
8000 18-JAN-2012 17-FEB-2015 17-FEB-2015 17-FEB-2015
610000 10-MAY-2016


Assignment details (PER_ALL_ASSIGNMENTS_F)
AsgID AsgNumber Eff-Start Eff-End Pri AsgSequence AsgType(AsgStatusTypeID) AsgStatus
---------- ---------- ---------- --- ----------- ---------- ----------------- -------------- -----------------
50000 380949 18-JAN-2012 17-FEB-2015 Yes 1 Contingent (2097) Active Contingent Assignment

160000 306977 06-APR-2016 12-OCT-2016 Yes 1 Employee (2096) Terminate Assignment

170000 380949-2 10-MAY-2016 31-DEC-4712 Yes 2 Contingent (2097) Active Contingent Assignment


Person was terminated with FINAL_PROCESS_DATE = 12-OCT-2016

Person was rehired as a Contingent Worker on 10-MAY-2016 five months prior to the FINAL_PROCESS_DATE.


When the person was rehired prior to FINAL_PROCESS_DATE, 


there now exists two active Primary Assignments for time period 10-MAY-2016 12-OCT-2016
and this is never allowed.





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