My Oracle Support Banner

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 later
Autonomous Database on Shared Infrastructure - Version N/A and later
Autonomous Database Dedicated - Version NA and later
Information in this document applies to any platform.


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:




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
 1.- Change the database instance parameter
 2.- Modify your code

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