12.2 Upgrade Makes Package Body OKC_REP_UTIL_GSI_PVT Invalid

(Doc ID 2341438.1)

Last updated on DECEMBER 21, 2017

Applies to:

Oracle Service Contracts - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Patch Application Issues

After upgrading to 12.2, package bodyOKC_REP_UTIL_GSI_PVT becomes invalid.


ERROR
-----------------------
SQL> alter PACKAGE OKC_REP_UTIL_GSI_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY OKC_REP_UTIL_GSI_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4182/21 PL/SQL: Statement ignored
4182/21 PLS-00306: wrong number or types of arguments in call to
  'VALIDATE_PARTY_CONTACT'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms