Mass Update Of Sourcing Documents Returns Multiple Records For The Old Person Field - Incorrect View (Doc ID 2043247.1)

Last updated on DECEMBER 01, 2015

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Mass Update of Sourcing Documents returns multiple records for the Old Person Field ,duplicate Person Records for Mass Update of Sourcing Documents due to this the below error occurred.
Error:
 The value 21369 for value set PON_SRS_OLD_PERSON occurs in more than one row in column users.user_id of table per_people_f p, fnd_user users and duplicate values are not allowed. Please choose a different value or contact your system administrator.


EXPECTED BEHAVIOR
Mass update of Sourcing Document should not return duplicate records for Old Person Field.

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

  1. Navigate to Purchasing Super user responsibility
  2. Submit a new Request "Mass Update of Sourcing Documents"
  3. Check the Old Person LOV its duplicating the users
  4. When the user is selected the above error occurs.

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