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)
Last updated on NOVEMBER 03, 2017
Applies to:PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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.
"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."
The issue can be reproduced at will with the following steps:
1. Make sure couple of employee have the same name.
select NAME, count(*) from PS_PERSONAL_DATA group by name
Following have count > 2
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"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms