Update Timecard Comment Errors "You Have Encountered An Unexpected Error. Please Contact the System Administrator For Assistance"

(Doc ID 1079107.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


When attempting to update a timecard on selecting comment on the third day, the following error occurs.

You have encountered an unexpected error.  Please contact the system administrator for assistance

Java stack trace shows:
Error Page
Exception Details
..... SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-6512: at line 2

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Self Service Time Entry
2. Time Entry
3. Select timecard to update
4. Select Additional Details for line 3 and the unexpected error appears.
5. The user is allowed to return to the previous page and continue his work, but is not allowed to enter additional comments where he would like to.


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