Create Timecard Errors With ORA-04063: Package Body "APPS.HXC_LOCK_API" Has Errors

(Doc ID 2407198.1)

Last updated on JUNE 04, 2018

Applies to:

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

Symptoms

On : 12.2.6 HRMS RUP 9 version, in Test/Dev instance that has been upgraded from 12.2.4 to 12.2.6,

When attempting to Create a timecard,
the following error occurs.

ERROR
-----------------------
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-04063: package body "APPS.HXC_LOCK_API" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.HXC_LOCK_API"
ORA-06512: at line 2

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.hxc.selfservice.timecard.util.TimecardLockHelper.(TimecardLockHelper.java:181)
at oracle.apps.hxc.selfservice.timecard.Timecard.createTimecard(Timecard.java:3089)
at oracle.apps.hxc.selfservice.timecard.Timecard.(Timecard.java:1568)
at oracle.apps.hxc.selfservice.timecard.webui.TimecardCO.processRequest(TimecardCO.java:447)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:643)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1058)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1025)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:702)
.
.
## Detail 0 ##
java.sql.SQLException: ORA-04063: package body "APPS.HXC_LOCK_API" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.HXC_LOCK_API"
ORA-06512: at line 2

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log into the application
Responsibility - XXX OTL Time Entry
Navigation - Time-->Create Timecard

or

1. Responsibility - XXX OTL Time Entry
2. Navigation - Time-->Recent Timecards
3. Click on Create Timecard

Observe the unexpected error



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create timecards in the upgraded instance

Changes

 

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