My Oracle Support Banner

R12.2 AP: OIE: Patch Fails on apwcobjt.sql due to OIE_GUEST_ATTENDEE_REC (Doc ID 2371164.1)

Last updated on JUNE 26, 2019

Applies to:

Oracle Internet Expenses - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

A patch delivering apwcobjt.sql 120.3.12020000.3  fails with the following error in the adworker log:

 

 AD Worker error:
The following ORACLE error:

ORA-02303: cannot drop or replace a type with type or table dependents

occurred while executing the SQL statement:

CREATE OR REPLACE TYPE OIE_GUEST_ATTENDEE_REC IS OBJECT ( guest_name
VARCHAR2 ( 240 ) , guest_type VARCHAR2 ( 30 ) , guest_employer VARCHAR2 (
80 ) , guest_employer_address VARCHAR2 ( 240 ) , guest_title VARCHAR2 (
240 ) , guest_tax_id VARCHAR2 ( 30 ) )

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.