My Oracle Support Banner

hxctcutil.pkb is Invalid After Applying Patch 20447986 (Doc ID 2021726.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Time and Labor - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

After application of Patch 20447986 on Development instance several invalids were observed.

ERROR
-----------------------
SQL> alter package HXC_APPROVAL_WF_PKG compile body;


Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY HXC_APPROVAL_WF_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3316/9 PL/SQL: Statement ignored

3316/33 PLS-00306: wrong number or types of arguments in call to 'GET_ASSIGNMENT_PERIODS'


SQL> alter package HXC_TIMECARD_UTILITIES compile body;


Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY HXC_TIMECARD_UTILITIES:



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

 

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!


In this Document
Symptoms
Cause
Solution
References


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