Patch 24690690 Failes With Object APPS.OE_INT_RELATED_ITEMS_MV Is Invalid

(Doc ID 2401345.1)

Last updated on MAY 23, 2018

Applies to:

Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Upgrade related issues

When attempting to apply patch 24690690 ORACLE E-BUSINESS SUITE 12.2.7 RELEASE UPDATE PACK' via adop,
the following error occurs.

ERROR
-----------------------
The filelist for the Oracle Forms object to generate is:

au resource OEXOETEL.pll /d02/appldev/appl/fs1/EBSapps/appl/au/12.0.0/resource/OEXOETEL.pll

ERROR generating library "resource/OEXOETEL.plx" from input file
/d02/appldev/appl/fs1/EBSapps/appl/au/12.0.0/resource/OEXOETEL.pll

Results of library generation:
(from file /d02/appldev/appl/fs1/EBSapps/appl/au/12.0.0/resource/OEXOETEL.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on OE_REL_ITEMS:
PL/SQL ERROR 905 at line 46, column 14
object APPS.OE_INT_RELATED_ITEMS_MV is invalid
PL/SQL ERROR 0 at line 44, column 9
SQL Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. attempt to apply patch 24690690 ORACLE E-BUSINESS SUITE 12.2.7 RELEASE UPDATE PACK' via adop.

Changes

 

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