Upgrade R12.2.4 On 12c Fails With ORA-06598: insufficient INHERIT PRIVILEGES privilege (Doc ID 1946915.1)

Last updated on DECEMBER 18, 2015

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On E-Business Suite (EBS) 12.2,
when attempting to apply RUP 12.2.4,
the following error occurs:

ATTENTION: All workers either have failed or are waiting:

  FAILED: file OE_SCHEDULE_LINES_TEMP.sql on worker 5.
  FAILED: file OE_ORDERORG_GTT.sql on worker 6.
  FAILED: file OE_CC_TEMP.sql on worker 8.

 

An error from the worker log file:

sqlplus -s APPS/***** @/u01/apps/oracle/SBX2/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/apps/oracle/SBX2/fs1/EBSapps/appl/ont/12.0.0/patch/115/sql/OE_SCHEDULE_LINES_TEMP.sql &un_ont'
Connected.

PL/SQL procedure successfully completed.

DECLARE
*
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 33

 


The issue can be reproduced at will with the following steps:
1. Apply RUP12.2.4

The issue has the following business impact:
Due to this issue, users cannot apply RUP12.2.4.

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