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

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