Select sys_user from hr profile record

Anisse Mahtat
Tera Contributor

Hi, I have a list of HR profile but i want to find these profiles in my sys_user table with a script. Can you explain how to do? 

Thanks

1 ACCEPTED SOLUTION

Musab Rasheed
Tera Sage
Tera Sage

Hello,

In HR profile table there is 'User' field which points to User profile.

MusabRasheed_0-1668606291999.png

 

Please hit like and mark my response as correct if that helps
Regards,
Musab

View solution in original post

2 REPLIES 2

Musab Rasheed
Tera Sage
Tera Sage

Hello,

In HR profile table there is 'User' field which points to User profile.

MusabRasheed_0-1668606291999.png

 

Please hit like and mark my response as correct if that helps
Regards,
Musab

Thanks mister