Getting Error "PLS-00302: component 'UNDO_DELETE_OBJECT' must be declared" While Applying FA Patch
(Doc ID 1962365.1)
Last updated on JUNE 27, 2023
Applies to:
Oracle Assets - Version 12.1 and laterInformation 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
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
| Symptoms |
| Cause |
| Solution |
| References |