R12.2 AP: Patch Fails on apwcobjt.sql due to OIE_GUEST_ATTENDEE_REC

(Doc ID 2371164.1)

Last updated on MARCH 09, 2018

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 ) )

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms