My Oracle Support Banner

Package Body CSD_00_UPGRADE Will Not Compile After Upgrade To 11.5.10.2 (Doc ID 396158.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Depot Repair - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
CSD_00_UPGRADE
csd00drls.pls

Symptoms

Cannot recompile Package Body CSD_00_UPGRADE after the 11.5.10.2 upgrade.  It shows the following error:

Warning: Package Body altered with compilation errors.

Errors for PACKAGE BODY CSD_00_UPGRADE:

LINE/COL ERROR
-------- -----------------------------------------------------------
221/10 PL/SQL: SQL Statement ignored
229/13 PL/SQL: ORA-00904: "NEW_INCIDENT_ID": invalid identifier


Steps
From user APPS:
SQL> alter package CSD_00_UPGRADE compile body;

Changes

Applied <Patch 3480000>

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.