My Oracle Support Banner

Package bodies CSD_REPAIRS_PKG and CSD_REPAIRS_PVT are invalid. (Doc ID 2818382.1)

Last updated on OCTOBER 31, 2021

Applies to:

Oracle Depot Repair - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Package bodies CSD_REPAIRS_PKG and CSD_REPAIRS_PVT are invalid after upgrade to 12.2.8 or higher.

When attempting to manually compile the package bodies the following errors occur:

Alter package CSD_REPAIRS_PKG compile body;
Warning: Package Body altered with compilation errors.

Errors for PACKAGE BODY CSD_REPAIRS_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
184/4 PL/SQL: SQL Statement ignored
336/11 PL/SQL: ORA-00904: "RETURN_ATTRIBUTE60": invalid identifier
674/5 PL/SQL: SQL Statement ignored
822/75 PL/SQL: ORA-00904: "RETURN_ATTRIBUTE60": invalid identifier

Alter package CSD_REPAIRS_PVT compile body;
Warning: Package Body altered with compilation errors.

Errors for PACKAGE BODY CSD_REPAIRS_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
823/3 PL/SQL: SQL Statement ignored
945/10 PL/SQL: ORA-00904: "RETURN_ATTRIBUTE60": invalid identifier
7614/13 PL/SQL: Statement ignored
7614/81 PLS-00302: component 'RETURN_ATTRIBUTE31' must be declared
7620/13 PL/SQL: Statement ignored
7620/81 PLS-00302: component 'RETURN_ATTRIBUTE32' must be declared
7626/13 PL/SQL: Statement ignored
7626/81 PLS-00302: component 'RETURN_ATTRIBUTE33' must be declared
7632/13 PL/SQL: Statement ignored
7632/81 PLS-00302: component 'RETURN_ATTRIBUTE34' must be declared
7638/13 PL/SQL: Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
7638/81 PLS-00302: component 'RETURN_ATTRIBUTE35' must be declared
7644/13 PL/SQL: Statement ignored
7644/81 PLS-00302: component 'RETURN_ATTRIBUTE36' must be declared
7650/13 PL/SQL: Statement ignored
7650/81 PLS-00302: component 'RETURN_ATTRIBUTE37' must be declared
7656/13 PL/SQL: Statement ignored
7656/81 PLS-00302: component 'RETURN_ATTRIBUTE38' must be declared
7662/13 PL/SQL: Statement ignored
7662/81 PLS-00302: component 'RETURN_ATTRIBUTE39' must be declared

Changes

Upgrade to EBS version 12.2.8 or higher.

The definition for the table CSD_REPAIRS is not correct. The table has only 30 columns for RETURN_ATTRIBUTES when there are now 60 columns available in the packages.
Apply a Depot Repair Patch with $CSD_TOP/patch/115/odf/csdcsd1.odfversion 120.53.12020000.18 or higher.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.