How To Register Workflow Locations With a Net Service Name (SQL*Net) In OWB (Doc ID 1679354.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2 and later
Information in this document applies to any platform.

Goal

The OWB Design Center (OWB Client) user interface does not support creating Process Flow locations that are registered with a Net Service Name (SQL*Net, TNS)

Trying to test such a process flow location in the OWB Design Center fails with:

As a supported workaround, users can use the wb_rt_reset_location package to register the process flow location with a Net Service Name. How to do this is explained below in this document.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms