Extract user id, user name and user email address information who running the concurrent program.
User ID: FND_PROFILE.VALUE('USER_ID');
User Name: select user_name from fnd_user fu where user_id = FND_PROFILE.VALUE('USER_ID');
User Email Address: select PER.EMAIL_ADDRESS from fnd_user FU, PER_EMPLOYEES_CURRENT_X PER where FU.USER_ID = 1692 AND FU.EMPLOYEE_ID = PER.EMPLOYEE_ID;
|