Search Logic Profile Options for Client List of Values in Global Human Resources
You can use the logic CONTAINS to create the client list of values. This returns results containing the characters you enter.
Optionally, for individual list of values, you can change this logic to STARTS
WITH, to return results that start with the search characters you enter.
For example, when you search for a person with the
name John Smith while using the logic CONTAINS, you can search by 'jo' or 'sm' or 'th'. When you use the logic STARTS WITH, your search must start with 'j'.
Use the logic STARTS WITH when your list contains thousands of values (more than 15,000 records)
to improve the search performance. Or, if you don't partition your
data by set ID.
You can use these profile options to change the search logic for a client LOV in Global Human Resources.
|
Object |
Profile Option Code |
|---|---|
|
Address Attributes |
PER_LOV_SEARCH_ADDRESSES_STARTSWITH (Site level value is delivered as Y) |
|
Bargaining Unit |
PER_LOV_SEARCH_BARGAININGUNITS_STARTSWITH |
|
Business Unit |
PER_LOV_SEARCH_BUSINESSUNITS_STARTSWITH |
|
Collective Agreement |
PER_LOV_SEARCH_COLLECTIVEAGREEMENTS_STARTSWITH |
|
Country (including Phone Country Code) |
PER_LOV_SEARCH_HCMCOUNTRIES_STARTSWITH |
|
Department |
PER_LOV_SEARCH_DEPARTMENTS_STARTSWITH |
| Department Trees | PER_LOV_SEARCH_DEPARTMENTTREENODES_STARTSWITH |
|
Document Type |
PER_LOV_SEARCH_HRDOCUMENTTYPES_STARTSWITH |
|
Cost Center |
PER_LOV_SEARCH_HCM_COSTCENTER_STARTSWITH |
|
Grade |
PER_LOV_SEARCH_GRADES_STARTSWITH |
|
Grade Ladder |
PER_LOV_SEARCH_GRADELADDERS_STARTSWITH |
| HCM Trees | PER_LOV_SEARCH_HCMTREES_STARTSWITH |
|
Job |
PER_LOV_SEARCH_JOBS_STARTSWITH |
| Job Families | PER_LOV_SEARCH_JOBFAMILIES_STARTSWITH |
|
Legal Employer |
PER_LOV_SEARCH_LEGALEMPLOYERS_STARTSWITH |
|
Location |
PER_LOV_SEARCH_LOCATIONS_STARTSWITH |
| Organization Trees | PER_LOV_SEARCH_ORGANIZATIONTREENODES_STARTSWITH |
|
Person (Worker, Manager, Employee) |
PER_LOV_SEARCH_WORKERS_STARTSWITH |
|
Position |
PER_LOV_SEARCH_POSITIONS_STARTSWITH |
| Position Trees | PER_LOV_SEARCH_POSITIONTREENODES_STARTSWITH |
|
Roles |
PER_LOV_SEARCH_ROLES_STARTSWITH |
| Sets | ORA_PER_LOV_SEARCH_HCM_SETS_STARTSWITH |
|
Union |
PER_LOV_SEARCH_UNIONS_STARTSWITH |
|
User Accounts |
PER_LOV_SEARCH_USERACCOUNTS_STARTSWITH |
|
User Roles |
PER_LOV_SEARCH_USERROLES_STARTSWITH |