Re: How to find out custome users in EBS

Posted by ErmanArslansOracleBlog on Aug 29, 2024; 11:48am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/How-to-find-out-custome-users-in-EBS-tp12645p12652.html

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.