My Oracle Support Banner

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.

Symptoms


 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.




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


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