How to find out custome users in EBS

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

How to find out custome users in EBS

VinodN
Hi Erman,

I am looking for a way to find out custom users/seeded users in EBS.

Regards,
Vinod
Reply | Threaded
Open this post in threaded view
|

Re: How to find out custome users in EBS

ErmanArslansOracleBlog
Administrator
 If you have access to the EBS database, you can query the relevant tables (e.g., FND_USER)
Customer users are often named with XX prefix.
You can also use active users reports which is a concurrent program available under system administrator resp.
Reply | Threaded
Open this post in threaded view
|

Re: How to find out custome users in EBS

VinodN
By custom users I am all end users also. Such as VINOD.NAGPURE
Reply | Threaded
Open this post in threaded view
|

Re: How to find out custome users in EBS

ErmanArslansOracleBlog
Administrator
You can manually analyze the active users report or output of an FND_USER select statement.
But you also can find your own way for automatically filtering the information you need.
For instance the creation date of seeded users are older than the custom users. You can go with a such a logical filter in your query. (exceptions may be handled by you , manually while reviewing the filtered data)
USER_ID can also shed a light on that way.
the column named description can also help you on your query.

So basically find an asymmetry between the data that is stored for seed and end/customer users in FND_USERS and go with that.