My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2022

Applies to:

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


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


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 onwards 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.


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

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