EBS Customizations (MOSC)

MOSC Banner

FND USER Table Alert - Oracle EBS

edited Jul 11, 2019 5:05AM in EBS Customizations (MOSC) 8 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center