My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2023

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.