My Oracle Support Banner

Installation Of Patch 31817501 Fails With ORA-02303: Cannot Drop Or Replace A Type With Type Or Table Dependents While Processing Faintyp.sql (Doc ID 3024635.1)

Last updated on OCTOBER 06, 2024

Applies to:

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

Symptoms

While applying patch 31817501, it fails as follows:


Error:
========
ATTENTION: All workers either have failed or are waiting:

FAILED: file faintyp.sql on worker <number>.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Current time is: <time>


Telling workers to quit...

The worker log shows:

sqlplus -s APPS/***** @/app01/oracle/EBSTST/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/app01/oracle/EBSTST/fs2/EBSapps/appl/fa/12.0.0/patch/115/sql/faintyp.sql &un_apps &pw_apps &un_apps_ne &pw_apps_ne'
Connected.

PL/SQL procedure successfully completed.

Connected.

Type created.


Type created.


PL/SQL procedure successfully completed.

Connected.
CREATE OR REPLACE TYPE GAT_message_type as object (req_id   number,
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.