My Oracle Support Banner

Invalid Oracle Federal Package After Applying March Legislative 2018 (Doc ID 2396680.1)

Last updated on MAY 21, 2018

Applies to:

Oracle US Federal Human Resources - Version 12.2 HRMS RUP4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 HRMS RUP4 version, Install / Upgrade Issues

ACTUAL BEHAVIOR
---------------
Invalid Oracle Federal Package After Applying March Legislative 2018

After applying patch 27761437 (US FEDERAL HR LEGISLATIVE PATCH MARCH-2018) database package 'GHR_RETIRE_DATA_REPORT' is invalid in our Pristine Environment. Package error is 'PLS-00306: wrong number of types of arguments in call to 'LOG_MESSAGE'. Bug # 7565956 added a new IN parameter, p_person_id, to procedure log_message in package GHR_MTO_INT. This package has 5 calls to procedure log_message and the required modifications for the package object were not included in the March Legislative patch. Oracle Patch cannot be fielded to our production environment with an invalid package.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, oracle Patch cannot be fielded to our production environment with an invalid package.

Changes

 

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!


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