1. Using Common Features for HCM
  2. Set Up Oracle Search for List of Values

Set Up Oracle Search for List of Values

You can set up Oracle Search for these List Of Values (LOVs).

  • Workers
  • Positions
  • Departments
  • Locations
  • Jobs

Enable Oracle Search for LOVs

To set up Oracle search for all the LOVs, first you need to enable Oracle Search profile options for LOVs.
Profile Option Code Profile Display Name Application Module Profile Level Profile Value
ORA_FND_SEARCH_EXT_ENABLED Enable/Disable Search Ext Framework Oracle Middleware Extensions for Applications Oracle Middleware Extensions for Applications Site Yes
HRC_ELASTIC_SEARCH_ENABLED HRC: Enable Elastic Search HCM Common Architecture

Search Framework

 Site Y
PER_SEARCH_LOGIN_EVENT_PUB PER: User Login Event Publication for Search Global Human Resources Security Site ATOM

Oracle Search for Workers List Of Values

Before you set up Oracle Search for workers list of values, enable the Global Search that uses Oracle Search. For details, see Enable Global Search.

Here are the steps to enable Oracle Search for workers list of values:
  1. Enable Oracle Search for LOVs as described in the first section.
  2. Set up data security for Oracle Search. For details, see Set Up Data Security for Oracle Search.
  3. Enable Oracle Search for workers LOV:
    1. Navigate to Home > Setup and Maintenance > Manage Administrator Profile Values.
    2. Search and set these profile options.
      Profile Option Code Profile Display Name Application Module Profile Level Profile Value
      ORA_PER_ORACLE_SEARCH_WORKERSLOV_ENABLED Enable Oracle Search Workers Lov Global Human Resources Personal Information Site Yes
  4. Optionally, use the HCM Experience Design Studio to configure other properties and customize your LOV. You can independently configure the search and display fields. For details, see How You Configure List of Values (LOVs).

Oracle Search for Positions List of Values

Here are the steps to enable Oracle Search for positions list of values:
  1. Enable Oracle Search for LOVs as described in the first section.
  2. Enable Oracle Search for positions LOV using these steps:
    1. Navigate to Home > Setup and Maintenance > Manage Administrator Profile Values.
    2. Search and set these profile options.
      Profile Option Code Profile Display Name Application Module Profile Level Profile Value
      ORA_PER_ORACLE_SEARCH_POSITIONSLOV_ENABLED Enable Oracle Search for Positions Lov Global Human Resources Personal Information Site Yes
  3. Run initial data ingestion using these steps:

    1. Navigate to Tools > Scheduled Processes.

    2. Run the process that's described in this table.
      Job Name Parameter Name Parameter Value
      ESS job to create index definition and perform initial ingest to OSCS Index Name to Reingest fa-hcm-position
  4. Set up data security for Oracle Search. For details, see Set Up Data Security for Oracle Search.
  5. Optionally, use the HCM Experience Design Studio to configure other properties and customize your LOV. You can independently configure the search and display fields. For details, see How You Configure List of Values (LOVs).

Oracle Search for Departments List of Values

Here are the steps to enable Oracle Search for departments list of values:
  1. Enable Oracle Search for LOVs as described in the first section.
  2. Enable Oracle Search for departments LOV using these steps:
    1. Navigate to Home > Setup and Maintenance > Manage Administrator Profile Values.
    2. Search and set these profile options.
      Profile Option Code Profile Display Name Application Module Profile Level Profile Value
      ORA_PER_ORACLE_SEARCH_DEPARTMENTSLOV_ENABLED Enable Oracle Search for Departments Lov Global Human Resources Personal Information Site Yes
  3. Run initial data ingestion using these steps:

    1. Navigate to Tools > Scheduled Processes.

    2. Run the process that's described in this table.
      Job Name Parameter Name Parameter Value
      ESS job to create index definition and perform initial ingest to OSCS Index Name to Reingest fa-hcm-organization
  4. Set up data security for Oracle Search. For details, see Set Up Data Security for Oracle Search.
  5. Optionally, use the HCM Experience Design Studio to configure other properties and customize your LOV. You can independently configure the search and display fields. For details, see How You Configure List of Values (LOVs).

Oracle Search for Locations List of Values

  1. Enable Oracle Search for LOVs as described in the first section.
  2. Enable Oracle Search for locations LOV using these steps:
    1. Navigate to Home > Setup and Maintenance > Manage Administrator Profile Values.
    2. Search and set these profile options.
      Profile Option Code Profile Display Name Application Module Profile Level Profile Value
      ORA_PER_ORACLE_SEARCH_LOCATIONSLOV_ENABLED Enable Oracle Search for Locations Lov Global Human Resources Personal Information Site Yes
  3. Run initial data ingestion using these steps:

    1. Navigate to Tools > Scheduled Processes.

    2. Run the process that's described in this table.
      Job Name Parameter Name Parameter Value
      ESS job to create index definition and perform initial ingest to OSCS Index Name to Reingest fa-hcm-location
  4. Set up data security for Oracle Search. For details, see Set Up Data Security for Oracle Search.
  5. Optionally, use the HCM Experience Design Studio to configure other properties and customize your LOV. You can independently configure the search and display fields. For details, see How You Configure List of Values (LOVs).

Oracle Search for Jobs List of Values

  1. Enable Oracle Search for LOVs as described in the first section.
  2. Enable Oracle Search for jobs LOV using these steps:
    1. Navigate to Home > Setup and Maintenance > Manage Administrator Profile Values.
    2. Search and set these profile options.
      Profile Option Code Profile Display Name Application Module Profile Level Profile Value
      ORA_PER_ORACLE_SEARCH_JOBSLOV_ENABLED Enable Oracle Search for Jobs Lov Global Human Resources Personal Information Site Yes
  3. Run initial data ingestion using these steps:

    1. Navigate to Tools > Scheduled Processes.

    2. Run the process that's described in this table.
      Job Name Parameter Name Parameter Value
      ESS job to create index definition and perform initial ingest to OSCS Index Name to Reingest fa-hcm-job
  4. Set up data security for Oracle Search. For details, see Set Up Data Security for Oracle Search.
  5. Optionally, use the HCM Experience Design Studio to configure other properties and customize your LOV. You can independently configure the search and display fields. For details, see How You Configure List of Values (LOVs).