My Oracle Support Banner

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 OCTOBER 19, 2023

Applies to:

Oracle Fusion Absence Management Cloud Service - Version and later
Information in this document applies to any platform.


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?

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


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

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