Invalid Package Body CSI_PARTY_RELATIONSHIPS_PVT after Patch 25687656:R12.EAM.C
(Doc ID 2334491.1)
Last updated on JULY 14, 2020
Applies to:
Oracle Installed Base - Version 12.2.5 and laterInformation in this document applies to any platform.
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
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
Goal |
Solution |
References |