Need to print the User Name on a Template; Need UserName from Global, HCM, or ASCM

Summary:

Need to print the User Name on a Template

Content (please ensure you mask any confidential information):

I am new to Oracle Fusion and FDI. I need to print the session user name in a template.

I can get the user for the current session from:

SELECT fnd_global.user_name FROM DUAL

But, that gives me the user_ID if you will: <User_ID@company.com.>

I need to find the table or varable in the session or HCM or ASCM tables that will allow me to query with the session “User_Name” and find the English friendly Display_Name: <John Smith>.