OAE_drop.sql leaves behind objects in APPS schema

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

The OAE_drop.sql should remove all Applications Manager created objects from the APPS schema.

However, the Procedure APPWORX_USER_PROC and Table APPWORX_PROGRAMS are left in the APPS schema after running OAE_drop.sql.

Environment

Component : APPLICATIONS MANAGER

Cause

APPWORX_PROGRAMS and APPWORX_USER_PROC contain Job Capture information

Resolution

APPWORX_PROGRAMS and APPWORX_USER_PROC contain Job Capture information. If this data is no longer needed, it can be dropped.