My Oracle Support Banner

ORA-02303: Cannot Drop Or Replace A Type With Type Or Table Dependents - Faintyp.sql Received When Applying Patch (Doc ID 2867812.1)

Last updated on MAY 06, 2022

Applies to:

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

Symptoms

When applying patch 31817501:12.2.0 Consolidated patch for EBS System Schema Migration via ADOP, the patch fails with the following error:

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.  Attempt to apply patch 31817501:12.2.0 Consolidated patch for EBS System Schema Migration using ADOP

2.  This error will occur during the Apply Phase (ADOP phase=apply)

3.  Review patch log file to see specific error

For information on how to use ADOP, and the phases involved, see E-Business Suite - ADOP Basic Usage Training Videos [VIDEO] (Doc ID 2103131.1)


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
References


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