Search/Match Truncates Names To 17 Characters And Is Looking For An Equal Condition Not Like
(Doc ID 2928426.1)
Last updated on FEBRUARY 15, 2023
Applies to:PeopleSoft Enterprise CS Recruiting and Admissions - Version 9.2 and later
Information in this document applies to any platform.
When an applicant has a name longer than 17 characters and the search/match runs, it truncates the name to 17 characters and is looking for an equal condition on the last and first name, not a like condition.
The issue can be reproduced at will with the following steps:
1. Create a name that is over 17 characters long, making sure it is a name that already exist in the database
2. Run the search/match process
3. Note the name is truncated to 17 characters and no match is found as it is looking for an equal, not a like.
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