My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Human Resources - Version 12.2 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.



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


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.