My Oracle Support Banner

Invalid View APPS.INL_EID_SHIPMENTS_V After Patch 8547912 Was Applied (Doc ID 2579388.1)

Last updated on AUGUST 29, 2019

Applies to:

Oracle Landed Cost Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, when attempting to compile objects,
the following error occurs.

ERROR
-----------------------
SQL > alter view APPS.INL_EID_SHIPMENTS_V compile;

Warning: View altered with compilation errors.

SQL > sho errors view APPS.INL_EID_SHIPMENTS_V;
Errors for VIEW APPS.INL_EID_SHIPMENTS_V:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-00904: "ISL_ATTRIBUTE15": invalid identifier


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Occurred after application of <Patch 8547912>

adop phase=apply apply_mode=downtime patchtop=/stage/patches patches=8547912,8547912_ESA:u8547912.drv

Once patch was successfully applied, received new invalid object (view).
Attempted to compile the view with no success:

SQL > alter view APPS.INL_EID_SHIPMENTS_V compile;

Warning: View altered with compilation errors.

SQL > sho errors view APPS.INL_EID_SHIPMENTS_V;
Errors for VIEW APPS.INL_EID_SHIPMENTS_V:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-00904: "ISL_ATTRIBUTE15": invalid identifier

We reviewed the view definition and found that there are 5 selects from different views:

OWNER OBJECT_TYPE STATUS
------------------------------ ------------------- -------
APPS VIEW VALID
APPS VIEW VALID
APPS VIEW VALID
APPS VIEW VALID
APPS VIEW VALID

All these views don't include ISL_ATTRIBUTE15 column in their definition:

select count(ISL_ATTRIBUTE15) from apps.inl_eid_shipmts_no_line_v;
select count(ISL_ATTRIBUTE15) from apps.inl_eid_shipmts_no_alloc_v;
select count(ISL_ATTRIBUTE15) from apps.inl_eid_shipmts_no_line_grp_v;
select count(ISL_ATTRIBUTE15) from apps.inl_eid_shipmts_asn_alloc_v;
select count(ISL_ATTRIBUTE15) from apps.inl_eid_shipmts_with_alloc_v;

The statements are failing with following error:

  *
ERROR at line 1:
ORA-00904: "ISL_ATTRIBUTE15": invalid identifier

Changes

 Occurred after application of <Patch 8547912>

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.