When Trying To Open Timecard Approval Notification, Get Error "ORA-06502: PL/SQL: Numeric Or Value Error ORA-06512: At "APPS.HXC_TIME_CATEGORY_UTILS_PKG" (Doc ID 1085812.1)

Last updated on JULY 15, 2016

Applies to:

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

Symptoms

When manager attempts to open approval notification for some timecards, the following error occurs.

 

(ConfigUIBean.java:328) at oracle.apps.hxc.selfservice.timecard.webui.TimecardCO.processRequest(TimecardCO.java:540) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
...etc...
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error ORA-06512:
at "APPS.HXC_TIME_CATEGORY_UTILS_PKG", line 4566 ORA-06512:
at "APPS.HXC_INLINE_NOTIF_UTILS_PKG", line 134 ORA-06512:
at "APPS.HXC_INLINE_NOTIF_UTILS_PKG", line 702 ORA-06512:
at line 2 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
...etc...

 
Error Page


You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Worklist Timecard Approval responsibility
2. Select 'Advanced Worklist'
3. Select the timecard notification and click 'Open' button


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the affected timecards cannot be approved.

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