My Oracle Support Banner

Invalid Objects After upgrade to 12.2.9 : CSI_ITEM_INSTANCE_VLD_PVT, CSI_CUSTIB (Doc ID 2694634.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Installed Base - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version,

CSI_CUSTIB_* and CSI_ITEM_INSTANCE_VLD_PVT objects are invalid after EBS upgrade to R12.2.9

After we upgraded EBS from R12.2.5 to R12.2.9 following Doc ID 2495027.1. There are 4 package body/objects are INVALID

( select * from dba_objects where status <> 'VALID' and object_type <> 'MATERIALIZED VIEW';):
owner object_name
APPS CSI_CUSTIB_ORDER_FULFILL_PUB
APPS CSI_CUSTIB_TXN_DETAILS
APPS CSI_CUSTIB_WIP_MERGE
APPS CSI_ITEM_INSTANCE_VLD_PVT

For example: CSI_CUSTIB_TXN_DETAILS error:
Body 27 6 PL/SQL: ORA-00942: table or view does not exist
Body 49 6 PL/SQL: ORA-00942: table or view does not exist
Body 701 12 PL/SQL: ORA-00942: table or view does not exist
Body 705 12 PL/SQL: ORA-00942: table or view does not exist
Body 718 12 PL/SQL: ORA-00942: table or view does not exist
Body 726 13 PL/SQL: ORA-00942: table or view does not exist
Body 783 15 PL/SQL: ORA-00942: table or view does not exist
Body 800 17 PLS-00364: loop index variable 'INNER_LINE_REC' use is invalid
Body 941 11 PL/SQL: ORA-00942: table or view does not exist
Body 953 13 PL/SQL: ORA-00942: table or view does not exist

Applied Patch 28560134:R12.CSI.C, and 27708552:R12.CSI.C in the system.
 

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.