My Oracle Support Banner

How To Find Generated Scripts Like Mapping PL/SQL, Process Flow XML (XPDL), Table DDL in the OWB 11.2 Runtime Repository After Deployment (Doc ID 1595571.1)

Last updated on FEBRUARY 01, 2022

Applies to:

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

Goal

This document explains how to find the generated code of e.g. mappings (PL/SQL), process flows (XML/XPDL) and tables/views (DDL) in the OWB 11.2 runtime repository after deployment. 

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
 1. Look for script_run_begin auditId in OWBSYS.XXXX.log
 2. Retrieve the generated code from table OWBSYS.OWB$WB_RT_AUDIT_SCRIPTS


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