My Oracle Support Banner

FAパッチを適用中に "PLS-00302: component 'UNDO_DELETE_OBJECT' must be declared" エラーが発生 (Doc ID 2018174.1)

Last updated on JUNE 08, 2015

適用範囲:

Oracle Assets - バージョン 12.1 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

 fauobsbkn1.sqlを含むFAのパッチを適用した際に、下記エラーが発生します。

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

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.