I am maintaining a repository of the code snippets/templates/queries, that I feel useful for whoever is working on Fusion BI – Adhoc reporting.
Logged in user details
The user information is stored in the following tables:
FND_GLOBAL – contains the logged in user details such as user guid, user name etc..
PER_USERS – contains the person details and their corresponding user login details such as user guid, user name etc…
Listing 1:
select FND_GLOBAL.USER_GUID, FND_GLOBAL.USER_NAME from dual;
Listing 2:
SELECT U.USER_ID FROM PER_USERS U WHERE U.USER_GUID=FND_GLOBAL.USER_GUID;