When Updating Past Assignment With The Effective Date, PER_PERSON_LIST Changed (Doc ID 2557775.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Symptoms

When updating past assignment other than organization with the effective date the record in PER_PERSON_LIST has been updated according with assignment info as of the effective date, not sysdate on this employee.

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

1.  Set up two custom security profiles(static) and two responsibility as below.
   1-1.Security Profile A which can only see OrganizationA, which has assigned to Responsibility A
   1-2.Security Profile B which can only see OrganizationB, which has assigned to Responsibility B
   
   
2. One Employees has assignment history as below.
   
   
   

   Effective_start_date	Effective_end_date	Person_id	Organization(organization_id)
   2000/1/1	2019/3/31	22222	OrganizationA(99999)
   2019/4/1	4712/12/31	22222	OrganizationB(88888)

   
    
3.  Check record in PER_PERSON_LIST table
   
   

   Security_profile_id(Name)	person_id
   12345(Security Profile B)	22222

   
   
   
4. Update past assignment other than organization with selecting effective date between 2019/3/31 and 2019/3/1 by using Responsibility A
   
   
   
5. Check record in PER_PERSON_LIST table
   
   

   Security_profile_id(Name)	person_id
   98765(Security Profile A)	22222

   
   
   
   
6. Unable to find this employee by using Responsibility A
   
   
   

Cause

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