Query to Extract user dump in Oracle

In EBS FND_USER table store the All the User.

Query to Extract user dump in Oracle

SELECT Fu.User_Id,
       Papf.First_Name,
       PAPF.LAST_NAME,
       Fu.User_Name,
       Fu.Start_Date,
       Fu.End_Date,
       Fu.Employee_Id,
       Fu.Email_Address
FROM APPS.Fnd_User fu, APPS.PER_ALL_PEOPLE_F PAPF WHERE Fu.Employee_Id IS NOT NULL AND Papf.Person_Id=Fu.Employee_Id;

Leave a Reply

Your email address will not be published. Required fields are marked *