Invoking APP_USER Intermittently Does Not Return Correct Value
(Doc ID 2805689.1)
Last updated on JULY 06, 2023
Applies to:
APEX Application Development - Version NA and laterAutonomous Database on Shared Infrastructure - Version N/A and later
Autonomous Database Dedicated - Version NA and later
Information in this document applies to any platform.
Symptoms
Using APEX in Autonomous Database or in APEX Application Development cloud service.
Invoking the substitution string APP_USER sometimes returns an incorrect value.
For example: It may return the username from the previous session.
Issue is intermittent, but has been observed to reproduce more often if user logs out and then login as another user.
Also, issue is likely to not reproduce if user hasn't login to APEX for several hours. The tests must be done as several
users in the same browser within a time window.
Code being used is similar to the following:
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
1.- Change the database instance parameter |
OR |
2.- Modify your code |
References |