Fusion Absence Management: Error Received When Trying to View Employees' Absence Records via My Team: ORA-00904: "QRSLT"."EFFECTIVE_END_DATE": Invalid Identifier / ADF_FACES-60097 Server Exception Error (Doc ID 2805565.1)

Last updated on SEPTEMBER 28, 2021

Applies to:

Symptoms

Symptoms
-----------
1) What occurred?
An error is thrown for users having a custom role when clicking on Existing Absences. Users with the seeded Line Manager or Time & Labor Manager roles can access the Existing Absences without an issue.

2) Where did it occur?
PROD and DEV1

3) Has it ever worked?
Yes, prior to 21B.

4) What has changed?
Upgrade to 21C.

5) Sequence of events?
Upgrade to 21C.

6) Actual behavior?
Error message is thrown.

7) Expected behavior?
Users with the custom SC Time Manager Custom role should be able to access Existing Absences.

8) What is working?
Using the seeded Time & Labor Manager or Line Manager roles work.
 

Error message(s)
-------------
Error 1: ORA-00904: "QRSLT"."EFFECTIVE_END_DATE": invalid identifier
 

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

1) My Team > Quick Actions > Existing Absences

Cause

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