Home » Applications » Oracle Fusion Apps & E-Business Suite » LAST NAME / FIRST NAME TO BE RETRIEVED (E-Business Suite R12/ OEL 5.7)
LAST NAME / FIRST NAME TO BE RETRIEVED [message #579223] Sat, 09 March 2013 10:14 Go to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi All,

I am trying to generate report of all users (from FND_USER). This report is expected to contain the First & Last name of every user. But I am unable to get these details. I queried the PER_PEOPLE_F and PER_ALL_PEOPLE_F tables but those are blank. I am querying these tables with admin privileges.

For Information :We create the user accounts through the "User Management" responsibility" and we also fill the First/Last name during the account creation.

Regards,
Antony
Re: LAST NAME / FIRST NAME TO BE RETRIEVED [message #579244 is a reply to message #579223] Sun, 10 March 2013 06:18 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
If you join fnd_user to hz_parties on person_party_id to party_id, do person_first_name and person_last_name give you what you need?
Re: LAST NAME / FIRST NAME TO BE RETRIEVED [message #584024 is a reply to message #579223] Wed, 08 May 2013 00:47 Go to previous messageGo to next message
a_kamalraj
Messages: 18
Registered: May 2013
Location: Bangalore
Junior Member

Hi Antony,

You will get Employee 1st name and Last only when an Employee is attached against an FND_USER created from System Asministrator.
In your case check few fnd_user from front end and check Employee is assigned or not else no point in joining PER_ALL_PEOPLE_F


Cheers
Kamal
Re: LAST NAME / FIRST NAME TO BE RETRIEVED [message #588834 is a reply to message #579244] Fri, 28 June 2013 13:41 Go to previous message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Thanks this helped.
Previous Topic: Oracle GL Budget
Next Topic: Oracle Apps Query User Organization Information
Goto Forum:
  


Current Time: Thu Mar 28 17:30:19 CDT 2024