Oracle Warehouse Builder Debugging Scripts

alter session set NLS_DATE_FORMAT=’DD-Mon-YYYY HH24:MI:SS’

 

select * from owbsys.ALL_RT_AUDIT_DEPLOYMENTS
order by updated_on desc

select * from owbsys.RAB_RT_AUDIT_DEPLOYMENTS
order by updated_date desc
select *
from
owf_mgr.WF_PROCESS_ACTIVITIES p,
owf_mgr.WF_ITEM_ACTIVITY_STATUSES i
where activity_status = ‘ACTIVE’
and p.instance_id = (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me  
New User Registration
*Required field