FND USER Table Alert - Oracle EBS
Hi,
We've a common user account which is being used from two different ends.
As per the security requirements, we've created an alert to notify us whenever a person logs into the account from both of our ends.
I'm giving the query below which we've configured. In this alert, we're able to get the last logged on date. Is it possible to find the CORE ID of the person who logged in through the account?
Here, we have a column named LAST_UPDATED_BY. This is returning a numerical value. We need it in the form of CORE ID.
SELECT USER_NAME, to_char (LAST_UPDATE_DATE,'DD-MON-RRRR HH24:MI:SS'), LAST_UPDATED_BY