OBIEE 11g - User A and User B Share Cursor Cache While Using Dashboard Prompt (Doc ID 2064152.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Symptoms

While using dashboard prompt, cursor cache is shared among users.

1. User A uses dashboard prompt " Department".
    Let say User A belong to Department = Sales and checking the data of Sales department. 

2. User A does not sign out but close the browser window with X.
    Cursor cache for Sales department is there for a while.

3. User B login and opens dashboard prompt "Department".

4. User B got the sales department instead of the department that user B belongs to.

It seems that the sales department information comes from cursor cache.
When you delete the cursor cache in advance to User B login, you don't encounter the issue.

Cause

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