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 AUGUST 29, 2023
Applies to:
Oracle Assets - Version 12.2.9 and laterInformation 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 |