Getting An Incorrect Messages When Trying To Add A Employee To The Project Team - In Cases When PERSONAL_DATA Table Shows that Multiple Employees Have Similar Names. - Message (13160,66) (Doc ID 2318509.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

On :  9.2 version, Project Team

Getting a PeopleCode Error when trying to add a resource to the project  

We are getting a PeopleCode error when trying to add a resource to a Project. The resource we are trying to add has two rows in the Person data table and the FieldChange code is failing when tab out the "Resource Name" field. Please review attached document for the error message details.

ERROR
-----------------------
Message 1:

"More than one resource has been found with the name entered. (13160,66)

More than one resource was found with the entered name. An employee ID has been chosen by the system. Please use the prompt on the ID Number field to ensure that the correct ID was chosen."


An then Error

GetField: Field 'PROJ_TEAM_2_WRK.ID_NUMBER' not found in scroll level 0. (2,155) PROJECT_TEAM.TeamLibrary.OnExecute  Name:GetEmployeeID  PCPC:16023  Statement:227
Called from:QUICK_ADD_WRK.GEN_RESOURCE.FieldChange  Statement:4

The specified field was not found in the indicated scroll level.  This may occur with various PeopleCode built-in functions that specify a "scroll context" via a series of records and a field name.

Review the PeopleCode that is generating the message and the page definition and correct as appropriate."

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Make sure couple of employee have the same name.

In demo
 select NAME, count(*) from PS_PERSONAL_DATA group by name

Following have count > 2

Baker,John
Bridges,Nash
Carson,John
Dickenson,Emily
Gardner,Anita
James,Anton
James,Sarah
Madison,James
Monroe,Theresa
Reynolds,Frank
Robson,Paul
Roth,Calvin
Silvers,Ruth
Smith,Cheri

2. Make sure Resource Management module is turned on for the system
3. Create a new Project and then go to project team and try adding any one of these, the above message will appear. Please note that when entering the resource use "John Baker" for the Name "Baker,John"

Cause

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