My Oracle Support Banner

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

Last updated on MARCH 31, 2017

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 DAAX2I (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:

Application of <Patch 20447986> and attempt to recompile shows invalids and renders customer unable to use instance and process OTL Timecards properly.

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.