Getting Error "PLS-00302: component 'UNDO_DELETE_OBJECT' must be declared" While Applying FA Patch (Doc ID 1962365.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Assets - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

 When applying an FA patch that includes fauobsbkn1.sql, the following error occurs.

adpatch.log :
-----------------------------------------------------------------
AutoPatch warning:
 Product Data File
 /global/oracle/XXXXXX/apps/apps_st/appl/admin/zfaprod.txt
 does not exist for product "zfa".
This product is registered in the database but the
above file does not exist in APPL_TOP.  The product
will be ignored without error.


AutoPatch warning:
 Product Data File
 /global/oracle/XXXXXX/apps/apps_st/appl/admin/zsaprod.txt
 does not exist for product "zsa".
This product is registered in the database but the
above file does not exist in APPL_TOP.  The product
will be ignored without error.


AutoPatch warning:
 Product Data File
 /global/oracle/XXXXXX/apps/apps_st/appl/admin/jtsprod.txt
 does not exist for product "jts".
This product is registered in the database but the
above file does not exist in APPL_TOP.  The product
will be ignored without error.



adwork001.log :
-----------------------------------------------------------------
sqlplus -s APPS/***** @/global/oracle/XXXXXX/apps/apps_st/appl/fa/12.0.0/patch/115/sql/fauobsbkn1.sql
   AD_OBSOLETE_PRODUCTS.undo_delete_object
                        *
ERROR at line 3:
ORA-06550: line 3, column 25:
PLS-00302: component 'UNDO_DELETE_OBJECT' must be declared
ORA-06550: line 3, column 4:
PL/SQL: Statement ignored

Cause

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 hundreds of Community platforms