My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

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


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!

In this Document
Symptoms
Changes
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.