Exception Error Encountered Trying to Approve the Timecard

(Doc ID 1414066.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

When attempting to access a email Notification in order to approve/reject/view a Timecard
the following error occurs.

System error occurred in Function record_hours_worked

When utilizing the Worklist itself from the application instead of email, the following exception error is seen:
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.HXC_PREFERENCE_EVALUATION", line 1911
ORA-06512: at "APPS.HXC_TIMECARD_PROPERTIES", line 1053
ORA-06512: at "APPS.HXC_TIMECARD_PROPERTIES", line 985
ORA-06512: at "APPS.HXC_TIMECARD_PROPERTIES", line 962
ORA-06512: at line 3


Steps
-----------------------
The issue can be reproduced sporadically with the following steps:
1. Create a Timecard and Submit it
2. Login as the Approver and navigate to Manager Self Service > Worklist
3. Click on the notification link

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