Setting Up Oracle Search Cloud Service

This topic describes how to enable Oracle Search Cloud Service (OSCS) for use with Public Sector Licensing and Permitting offerings.

Using Search Cloud Service for the Parcel Page Overview

You can enable Search Cloud Service for the Parcel page. With Search Cloud Service enabled and the search index populated, when you click Filter By for the Parcel page, you can use an enhanced set of search criteria to run more flexible searches. Users can apply search criteria and save configured criteria for future use.

This example illustrates the search criteria displayed for the Parcel page when Search Cloud Service has been enabled and configured. Details are in the surrounding text.

Enabling Search Cloud Service

You opt in to the Search Cloud Service feature using the Functional Setup Manager.

To enable Search Cloud Service:

1. Access the Functional Setup Manager.

2. Select your Public Sector Licensing and Permitting offering.

3. Click Change Feature Opt in.

4. For System Administration, click the edit icon in the Features column.

5. Select the Enable check box for Search Cloud Service.

6. Click Done.

Configuring Security

To setup access to resources required for running jobs to populate indexes, make sure that the following role has been added to the PSC System Administrator job role (ORA_PSC_SYSTEM_ADMINISTRATOR_JOB): Application Administrator (ORA_FND_APPLICATION_ADMINISTRATOR_JOB).

Enabling Search Framework Extensions

To enable search framework extensions:

1. From the Fusion Applications homepage, navigate to Manage Applications Core Administrator Profile Values.

2. In the Profile Option Code field enter ORA_FND_SEARCH_EXT_ENABLED.

3. In the Profile Values grid, set Site to Yes.

For more information on profile values, see the Oracle Applications Cloud documentation: "Profile Options" in Implementing Applications.

Creating the Parcel Search Index

Before you can use the Oracle Search Service features, you need to create and populate the parcel index by running an Enterprise Scheduler Service job.

To populate the search index:

1. From the Fusion Applications homepage, select Navigator > Scheduled Processes.

2. Click Schedule New Process.

3. On the Schedule New Process page, search for and select this process: ESS job to create index definition and perform initial ingest to OSCS.

4. Click OK.

5. On the Process Details dialog box, for the Index Name to Reingest field, enter fa-psc-apo-parcel to create and populate the parcel index.

Note: You only need to run the job to create and load the index once. After the initial run, the Search Cloud Service recognizes when new parcels have been added to the underlying view object and updates the index as needed.

Note: If you insert data directly into parcel tables using SQL scripts, for example, then for that data to be ingested into the index, you will also need to run the following job on an as-needed basis: ESS job to run Bulk ingest to OSCS.