Create Timecard Errors With ORA-04063: Package Body "APPS.HXC_LOCK_API" Has Errors
(Doc ID 2407198.1)
Last updated on DECEMBER 09, 2022
Applies to:
Oracle Time and Labor - Version 12.2.6 and laterInformation 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
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 |