Login  Register

How to find out custome users in EBS

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

How to find out custome users in EBS

VinodN
102 posts
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
| More
Print post
Permalink

Re: How to find out custome users in EBS

ErmanArslansOracleBlog
Administrator
5727 posts
 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
| More
Print post
Permalink

Re: How to find out custome users in EBS

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

Re: How to find out custome users in EBS

ErmanArslansOracleBlog
Administrator
5727 posts
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.