New Invalid Objects After Applying the Patch 20797719 (Doc ID 2005358.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

After applying the one-off patch:20797719, there are new following invalid objects.

====
OWNER   OBJECT_NAME   OBJECT_TYPE       STATUS
--------   ----------------   - ----------------    -----------
APPS       PER_ADD_INS    PACKAGE BODY    INVALID
APPS       PER_ADD_UPD   PACKAGE BODY    INVALID
====

ERROR
-----------------------

SQL> show errors
Errors for PACKAGE BODY APPS.PER_ADD_INS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
334/2    PL/SQL: Statement ignored
334/20   PLS-00306: wrong number or types of arguments in call to
        'ADDRESS2GEOMETRY'

SQL> show errors
Errors for PACKAGE BODY APPS.PER_ADD_UPD:

LINE/COL ERROR
-------- -----------------------------------------------------------------
215/2    PL/SQL: Statement ignored
215/20   PLS-00306: wrong number or types of arguments in call to
         'ADDRESS2GEOMETRY

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Apply the <Patch:20797719>

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