5Setting Up Additional Integrations

Setting Up Contractor Integration

This topic describes how to import and activate integration settings that enable you to validate contractor information against data from the contractor licensing body.

Oracle provides pre-built integrations with specific contractor licensing bodies. To set up this integration, download the integration files from My Oracle Support and then import them into Oracle Autonomous Integration Cloud (OIC). To use an integration after you set it up, use the Contractor License Options page. For more information, see Setting Up Contractor License Options.

To set up contractor integration:

  1. Go to My Oracle Support (MOS) and access Doc ID 2672514.1.

  2. Follow the instructions on the MOS page, and save the .iar integration file for your contractor licensing body.

  3. Access the main console in OIC.

  4. Click Integrations in the left frame.

  5. Click the Import button at the top of the Integrations page.

  6. Select the integration file for your licensing body, then click the Import button.

  7. Click Connections in the left frame.

  8. Test the Generic REST Trigger connection:

    1. Access the detail page for the Generic REST Trigger connection.

    2. Click the Test button.

    3. When the test is 100% complete, click Save and then Close.

  9. Test the integration for the imported licensing body:

    1. Access the detail page for the licensing body connection.

    2. Click the Test button.

    3. When the test is 100% complete, click Save and then Close.

  10. Click Integrations in the left frame to return to the Integrations page.

  11. Turn on the activation switch for the new licensing body integration.

  12. In the Activate Integration window that appears, click the Activate button.

Setting Up a Proxy Role and User for Integrated Voice Response

Set up a proxy user in the Oracle Security Console to give your Integrated Voice Response (IVR) system access to PSCR.

The IVR system accesses permit information via REST, using the proxy user credentials. During a call, a public user provides the IVR system with both a permit number and their personal IVR code. The IVR system sends that code along with any request to access the permit information in the PSCR system. PSCR verifies that the code matches the IVR code that’s stored in the permit owner’s account. If the code matches, the request is honored.

In this procedure you will use the Security Console to:

  1. Create a custom role for the IVR access.

  2. Assign a delivered duty role to the custom role.

  3. Create the IVR proxy user.

  4. Assign the custom IVR role to the IVR proxy user.

For more information about using the Security Console, see: Using the Security Console.

Creating the IVR Custom Role

To create the PSC IVR Proxy User role:

  1. Navigate to the Security Console.

    To navigate to the Security Console, you have these options:

    • In Functional Setup Manager, click the task: Create Integrated Voice Response Proxy User.

    • Click Setup and Maintenance on the Agency Springboard, and on the Fusion Applications home page, select Navigator > Tools > Security Console.

  2. Select the Roles tab.

  3. Click Create Role.

  4. On the Create Role: Basic Information page enter the following:

    Page Element


    Role Name

    PSC IVR Proxy User

    Role Code


    Role Category

    Financials — Job Roles

  5. Click the Role Hierarchy step, and add the following duty role: PSC Interactive Voice Recognition Proxy User (ORA_PSC_IVR_PROXY_USER_DUTY).

  6. Click the Summary step and click Save and Close.

Creating the IVR User

To create the IVR proxy user:

  1. In the Security Console, click the Users tab.

  2. On the User Accounts page, click Add User Account.

  3. On the Add User Account page in the User Information section, enter a Last Name and User Name of your choice.

    Note: The name given for the proxy user should be generic, such as IVR Proxy User.
  4. Enter a Password of your choice and confirm it.

  5. Click Add Role for the Roles grid, and assign this role to your proxy user:

    • Role Name: PSC IVR Proxy User


  6. Click Save and Close.

Setting Up Oracle Search Cloud Service

This topic describes how to enable Oracle Search Cloud Service (OSCS) for use with Public Sector Compliance and Regulation 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.

Search Cloud Service parcel criteria

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 Compliance and Regulation 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 Profile Options in Oracle Applications Cloud: 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.