ETL92: Manage Exception Error - Field does not exist -- TL_WEB_CLOCK_WK.EFFDT (Doc ID 2978965.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

Manage Exception error is triggered when Manager/Admin goes to Manage Exception page then selects an employee and drills down on the exception using the right arrow. Below error is triggered:

Error:

 
Steps to recreate:
1. Add delivered KUMISSINGOUT rule to the Rule program.
2. Select a Punch Time Reporter with no schedule assigned.
3. Time Reporting Template has Time option enabled.
4. Employee - Report Time Entry for first IN punch on 10/3/23 and Submit.
5. Employee gets out and come back in - Report Time Entry for second IN punch on 10/3/23 and Submit. Note Message triggered – The most recent punch at 9:15 am is also an IN punch.
6. Employee selects OK to save the new punch.
7. Run Time Admin for Employee.
8. Employee goes to Exception tile and drills down on the exception for 10/3/23. Employee is able to see the exception as expected.
9. Login as Manager / Administrator and navigate to Team Time > Manage Exception.
10. Manager selects the Employee on 10/3/2023 then clicks right arrow. Note: above error is triggered.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.