Solved

Get User Account Creation Date

  • 16 June 2022
  • 1 reply
  • 148 views

Userlevel 5
Badge +9
  • Sidekick (Customer)
  • 87 replies

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?

icon

Best answer by Ruchira 16 June 2022, 09:54

View original

1 reply

Userlevel 5
Badge +12

Hi,

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

Reply