Exception Error Encountered Trying to Approve the Timecard
(Doc ID 1414066.1)
Last updated on DECEMBER 03, 2019
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.
When attempting to access a email Notification in order to approve/reject/view a Timecard
the following error occurs.
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
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
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