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:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |