My Oracle Support Banner

API5072 Error When Deploying an Oracle Warehouse Builder (OWB) Process Flow to Two Different Workflow Schemas Installed On The Same Database Instance (Doc ID 445067.1)

Last updated on MARCH 05, 2024

Applies to:

Oracle Warehouse Builder - Version 10.2 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Attempting to deploy an OWB Process Flow  fails with the  following:

Changes

A second WorkFlow schema has been installed in the database instance.

This can be reproduced with :

1. Install two workflow schemas (owf_mgr and owf_mgr1) in the same database instance where the OWB repository and target schema reside.
2. Define two Control Center configurations - one for OWF_MGR and the other for OWF_MGR1.
3. You are able to successfully deploy the process flow the first time using both Control Center configuration
4. But then on-wards deploying process flow using one Control Center configuration works. However when trying to deploy the same process flow using the other Control Center configuration the above error is raised.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.