My Oracle Support Banner

Two Active Primary Assignment Records At The Same Point In Time In Table PER_ALL_ASSIGNMENTS_F (Doc ID 2198110.1)

Last updated on JUNE 21, 2023

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


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.




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

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