Creating Lookups

A lookup associates values used by one application for a specific field to the values used by other applications for the same field. This provides the capability to map values across vocabularies or systems. For example, you can map country codes, city codes, currency codes, and so on.

Creating a Lookup

Create a lookup to map values between applications.

  1. On the Oracle Integration Cloud Service home page, click the Lookups diagram.
  2. Click Create.
    The Create New Lookup dialog is displayed.
  3. Enter a name and optional description for the lookup.
  4. Click Create.
The Lookup page is displayed.

Adding Adapters or Domain Names to a Lookup

Add adapters or domain names to a lookup to map values between connections.

  1. Click Domain Name 1.
    A menu with options is displayed.
  2. Select the type to create:
    • Select Adapter: This selection invokes the Select Adapter dialog for choosing the adapter to use. You can change your selection:

      • If you want to change your adapter selection, click the selected adapter type, then choose Select Different Adapter.

      • If you want to change from an adapter to a domain name, click the selected adapter type and choose Replace with Domain Name.

    • Enter Domain Name: This selection invokes a dialog for entering the domain name to use. There is a 50 character limit. You can change your selection:

      • If you want to change from a domain name to an adapter, click the domain name, then choose Replace with Adapter.

      • If you want to change the domain name, click the name, then choose Edit Domain Name.

      The adapter or domain name is displayed.

  3. Enter a value in the field below the adapter or domain name. To add more rows for additional values, click the + sign.
  4. Click Domain Name 2.
  5. Repeat Step 2 to add an adapter or domain name.
  6. Enter a value in the field below the adapter or domain name. To add more rows for additional values, click the + sign.
  7. If you want to add another column, click +.
  8. Repeat to add more adapters and domain names to the lookup.
  9. Click Save when complete.

Cloning a Lookup

You can clone a copy of an existing lookup. It is a quick way to create a new lookup with similar information. Lookups with adapters and domain names can be cloned.

  1. On the Lookups page, select Clone from the hamburger menu menu.
    The Clone Lookup dialog is displayed.
  2. Enter the lookup information.
  3. Click Clone.
  4. Click Edit to further configure your cloned connection.

Deleting a Lookup

You can delete a connection from the Lookup menu.

  1. Select Delete from the hamburger menu menu.
    The Delete Lookup dialog is displayed.
  2. Click Yes to confirm deletion.

Updating Lookups in Active Integrations

Lookups are not deployed as part of integration activation. Therefore, changes that you make to lookups already used in active integrations take effect immediately. There is no need to re-activate integrations using a changed lookup for the new lookup value to take effect.