Solved

Get User Account Creation Date

+9

How can we get a User account creation date out of IFS?

It’s not available on either the FND_USER or ORACLE_ACCOUNT views.

I can see there are OBJID and OBJVERSION columns on the FND_USER view, but that only records the newest version.

What is the table or view to query to get the original account creation date?

Best answer by Ruchira

Hi,

sys.dba_users should be the view you’re looking for

Did this topic help you find an answer to your question?

+13

Hi,

sys.dba_users should be the view you’re looking for

Cheers, Ruchira

1 reply