Skip to main content
Solved

Get User Account Creation Date

  • June 16, 2022
  • 1 reply
  • 314 views

Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 92 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?

Best answer by Ruchira

Hi,

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

1 reply

Forum|alt.badge.img+13
  • Hero (Partner)
  • 135 replies
  • Answer
  • June 16, 2022

Hi,

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