CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Data in report of other user rather than the one logged on

edited Dec 10, 2018 4:02AM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered

Hello:

I'm displaying some reports in the home screen for the salespeople. Reports are gathered in a dashboard and embedded in a web applet. To get data of the currently logged user, I use the NQ_SESSION.USER_ALIAS variable. The stranger thing is that, for some users (not all and not in all cases) that variable returns other user rather than the one logged on, and so displays data not belonging to the current user.

Please, see the screenshot attached. You can see in the top the name of the logged user, and in the teletype report there is the name of another user. I’ve added a table (Usuario) that simply display the value of NQ_SESSION.USER_ALIAS, checking that the user returned is wrong.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center