Search code examples
sqloracle-databaseoracle11gdatamodel

Report that only displays employees directly reporting to the manager running the report

Hello I'm running Obi 11g and I'm creating a dashboard for managers and I'm having difficulty finding a way to create a report for the dashboard that shows only the employees directly reporting to the manager running the dashboard / report.

I've done a little research and I'm guessing this is going to be done by session variables? but i'm not sure how. If there was a way I can pull the executing user's username I could just say employee.username = session.username and then run the query accordingly but is there a way to this? Any help would be appreciated greatly. Thanks.

Solution

  • I found what I was looking for

    SELECT fnd_global.user_name FROM DUAL

    This posts the username instead of the schema.