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.
When applying patch 31817501:12.2.0 Consolidated patch for EBS System Schema Migration via ADOP, the patch fails with the following error:
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
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)
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