BI Publisher (MOSC)

MOSC Banner

BI Publisher: Using XDO_USER_NAME in query for LOV

edited Oct 14, 2014 4:35PM in BI Publisher (MOSC) 2 commentsAnswered ✓

I have a report parameter, supervisor, based on a List of Values.  The query to populate the LOV includes a reference to xdo_user_name to get the person who is logged in.

However when I run the report I get this error :

"Parameter name: supervisor Missing IN or OUT parameter at index:: 1; Data source: hrDS; Query: select distinct PPF.FULL_NAME,PPF.PERSON_ID FROM PER ...."

When I hard code a user name such as 'JAMALM' instead of xdo_user_name,  the report runs fine.  Can I not use a system variable such as xdo_user_name in a query for LOV ?  If I can't then is there a workaround ?

Tagged:

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