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.

Note:

If you change the search logic for a client list of values, the logic changes in all pages where the list of values is used.

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