How to identify User id creation date

[puppy]

Hi All,

I want to get the user id details from F0092 based on the user id creation date.

Say for example, need to get the user list as on 1/1/2016

But user id creation date is available in F0092.

Please help me to find out.

Thanks in advance.

Puppy.

 

[Larry_Jones]

Short answer - SYS910.F9312
Filter the F9312 with below condition
SHUSER = User ID
SHEVTYP = 10 - Add User to F0092
SHEVSTAT= 01 - Success

SHUPMJ Field gives you the User ID creation Date.

Long Answer - Oracle Document 645674.1

 

[puppy]

Hi Larry,

Noted with Thanks.

If user id is disabled and we enable it again,I think this UPMJ will be updated.

Thanks & Regards,
Puppy.