1. Integrating Service Logistics with Field Service
  2. Install and Configure the Recipe

Install and Configure the Recipe

Install the recipe on your Oracle integration instance to deploy and configure the integration and associated resources.

To install and configure the recipe:
  1. From the Oracle Integration home page, in the Use a recipe/accelerator section, click View all.
  2. Find this recipe by searching for Service Logistics, then click Get.
  3. Verify the confirmation message that says the recipe was successfully installed, and that the recipe card shows In use.
  4. Click Configure on the recipe to configure its resources.
  5. The project workspace opens, displaying all the recipe resources.
Note:

Starting with the 24B release, all the integrations are recipes in the Projects feature of OIC Gen 3, which is available if you're moving from OIC Gen 2 to OIC Gen 3.

Configure the Connections

Configure the following resources before you activate and run the recipe.

Configure the Service Logistics ERP Cloud REST Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Properties

    Enter your Fusion instance URL for ERP Cloud Host for example, https://myinstance.fusionapps.com/.
    Enable two way SSL for outbound connections (Optional) Select No.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Basic Authentication selected.
    Username Enter the FA username.
    Password Enter the password for the user.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click the Go back icon.

Configure the Service Logistics Fusion REST Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Connection Type Leave REST API Base URL selected.
    Connection URL

    Enter your Fusion instance URL, for example, https://myinstance.fusionapps.com/.
    Enable two way SSL for outbound connections (Optional) Select No.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Basic Authentication selected.
    Username Enter the FA username.
    Password Enter the password for the user.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click the Go back icon.

Configure the Service Logistics Locations SOAP Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Properties

    Enter the FA WSDL URL for example, https://fusionapps:443/crmService/FoundationPartiesLocationService?WSDL.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Basic Authentication selected.
    Username Enter the FA username.
    Password Enter the password for the user.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click the Go back icon.

Configure the Service Logistics OFSC Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Properties Enter Field Service Cloud API URL.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Basic Authentication selected.
    Username

    Enter the username that you defined as client id on OFSC for application connection.
    Password Enter the client secret from OFSC.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click the Go back icon.

Configure the Service Logistics OFSC REST Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Connection Type Leave REST API Base URL selected.
    Connection URL

    Enter your Field Service instance rest URL, for example, https://myinstance.fusionapps.com/rest/ofsccode.
    Enable two way SSL for outbound connections (Optional) Select No.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Basic Authentication selected.
    Username

    Enter the username that you defined as client id on OFSC for application connection.
    Password Enter the client secret from OFSC.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click the Go back icon.

Configure the Service Logistics Technicians SOAP Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Properties

    Enter the FA WSDL URL for example https://fusionapps:443/crmService/FoundationPartiesPersonService?WSDL.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave Basic Authentication selected.
    Username Enter the FA username.
    Password Enter the password for the user.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click the Go back icon.

Configure the Service Logistics Order Parts Lookup

When creating a transfer order or purchase requisition, the preparer and deliver-to requester information is required. These attributes are mapped in the integration within the CreateSupplyRequestLine node and the parts are stored in a lookup.

To configure this functionality you must update the SL_UTILITY_LKP lookup for the Preparer Person Id code.

The values correspond to the person_id of the user who's allowed to create transfer orders in the Fusion application. This is typically retrieved from the PER_PERSON_NAMES_F table.

Here's an example query:

  • SELECT person_id

  • FROM fusion.per_person_names_f

  • WHERE first_name = 'Marsha' AND last_name = 'Brent';

In the lookup, you'll need to provide the person_id that you've retrieved from the query.

Set Up the Secure Integration Between Customer-specific Instances

Oracle Integration syncs Service Logistics field service technicians, stocking locations, inventory balances, and the product catalog with Field Service. The following tasks must be performed to set up the secure integration between customer-specific instances.

  1. Create the Oracle Integration User.
  2. Import the Oracle Integration flows:
    1. Navigate to Integration Store homepage.

    2. Click Browse Store.

    3. Enter Service Logistics in the Search field.

    4. Click Get to start installing the recipe.

  3. Specify connection URL and credentials for all Service Logistics connections.
  4. After all connections are defined, activate the Service Logistics integrations.

Verify Integration Synchronization

Follow the steps listed below to verify the synchronization.

In Service Logistics:

  1. Open the Manage Field Service Technicians UI.
  2. Add a new person as a field service technician and assign a stocking location to the user.
  3. In Oracle Integration, search for the Service Logistics Technicians integration and select Submit Now. If the integration completes successfully, sign in to Oracle Field Service and verify that the technician is available.

Set Up Password Policies for Integration Users

You can set up password policies if you’d like to limit the number of days that a user’s password will work. Expiration days can be set for up to 9999 days.

To set up password policies for integration users:

  1. Sign in as a system administrator.
  2. Open the Security Console page.
  3. Create a new user category.
  4. Edit the password policy for the new user category.
  5. Add the integration user to the new user category.

Related Topics