You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Tables involved in Removing a User ID

2 replies [Last post]
Aarthi_Peoplesoft's picture
Joined: 01/27/2011
Posts: 5

I need to find out all the tables that will be affected when a deletion of User ID happens in peoplesoft
I know there are 2 ways these are done in Peoplesoft
1. Via Security - Delete user profiles
2. Via Security - Purge inactive user profiles
(The second, involves a AE and we can find the related tables there)
I have also planned to do a "find definition referrnece" for the file - OPRID in app designer.
Are there any other ways in which we can find the tables.
If someone could help me with list of tables involved also, it would help me a lot.

Thank you

Ashar's picture
User offline. Last seen 4 years 13 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: Tables involved in Removing a User ID

turn on the trace when you delete user profile that way you can find out all tables.
Just finding definition references for OPRID is not gonna help as there are other fields like ROLEUSER etc.

Lepa's picture
User offline. Last seen 1 year 32 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Tables involved in Removing a User ID

I used trace to get all tables involved in creating a user profile before so yes, Ashar is spot on. I'm no longer at work so I will try to find the list of tables IF i still have them!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog