Hxctimecatupg.sql Script Failing on Upgrade (Doc ID 1634886.1)

Last updated on JULY 10, 2017

Applies to:

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

Symptoms


When attempting to run the merged driver (10124646 and 17197281) ) for a 12.1.6 to 12.2 upgrade for the first iteration,
the following errors occur.

hxctimecatupg.sql : ORA-04063: package body "APPS.HXC_TIME_CATEGORY_UTILS_PKG" has errors

hxctimecatupg.sql failed with the following error:

declare
*
ERROR at line 1:
ORA-04063: package body "APPS.HXC_TIME_CATEGORY_UTILS_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.HXC_TIME_CATEGORY_UTILS_PKG"
ORA-06512: at line 228


ERROR
-----------------------
ERROR at line 1:
ORA-04063: package body "APPS.HXC_TIME_CATEGORY_UTILS_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.HXC_TIME_CATEGORY_UTILS_PKG"
ORA-06512: at line 228




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the 12.2.upgrade driver
2. Upgrade driver fails


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