Invalid Package Body CSI_PARTY_RELATIONSHIPS_PVT after Patch 25687656:R12.EAM.C (Doc ID 2334491.1)

Last updated on DECEMBER 07, 2017

Applies to:

Goal

After applying patch 25687656:R12.EAM.C, CSI_PARTY_RELATIONSHIPS_PVT package body is invalid.

Unable to create new assets due to this issue.

Try to compile:

SQL> alter package APPS.CSI_PARTY_RELATIONSHIPS_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY APPS.CSI_PARTY_RELATIONSHIPS_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2676/7 PL/SQL: SQL Statement ignored
2676/7 PLS-00394: wrong number of values in the INTO list of a FETCH
statement

CAUSE

----------

There is a missing parameter in csivipb.pls version: 120.17.12020000.20

Customer has the following file versions:
csiviivb.pls 120.48.12020000.41
csiviivs.pls 120.13.12020000.8

csivipb.pls 120.17.12020000.20
csivips.pls 120.2.12020000.1

csipdss.pls 120.24.12020000.15 CSI_DATASTRUCTURES_PUB

This is similar to Bug 23299768.

"INSERVICE_DATE -- Support for DPIS" parameter was introduced in version csipdss.pls 120.24.12020000.15

csivipb.pls 120.17.12020000.20 does NOT have INSERVICE_DATE -- Support for DPIS

All later versions of csivipb.pls have INSERVICE_DATE :
120.17.12020000.22
120.17.12020000.23
120.17.12020000.24

Solution

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