Home » Applications » Oracle Fusion Apps & E-Business Suite » Query About An employee (Query About An employee)
Query About An employee [message #416909] Wed, 05 August 2009 01:57 Go to next message
anasser
Messages: 8
Registered: July 2009
Junior Member
Hi All
when i query in Toad about an regular employee for example 11040 ,the result from the query it is two record why

thank you

[Updated on: Wed, 05 August 2009 02:06]

Report message to a moderator

Re: Query About An employee [message #416912 is a reply to message #416909] Wed, 05 August 2009 02:07 Go to previous messageGo to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
Hi,

Can you post your query and its output please.

Best Regards,
Monika
Re: Query About An employee [message #416914 is a reply to message #416909] Wed, 05 August 2009 02:26 Go to previous messageGo to next message
anasser
Messages: 8
Registered: July 2009
Junior Member
SELECT * FROM per_people_f
WHERE employee_number='111111'


and the result it is too long

Re: Query About An employee [message #416915 is a reply to message #416914] Wed, 05 August 2009 02:27 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Soooo... Which one is it.

Too long or two records?

Is the problem with 111111 or with 11040?
Re: Query About An employee [message #416916 is a reply to message #416915] Wed, 05 August 2009 02:31 Go to previous messageGo to next message
anasser
Messages: 8
Registered: July 2009
Junior Member
ThomasG wrote on Wed, 05 August 2009 02:27
Soooo... Which one is it.

Too long or two records?

Is the problem with 111111 or with 11040?



this was answer for monika

what ever employee the result is two record

Re: Query About An employee [message #416927 is a reply to message #416916] Wed, 05 August 2009 03:52 Go to previous messageGo to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
Hi,

Can you post the output also you can export it as xls sheet and then attach it while replying.

Anyways it is possible that for a particular employee number you can have more then one row in per_all_people_f screen as after creating if you update the employee detail in UPDATE date-track mode then you will get more than one record as it maintains the history also..

Best Regards,
Monika
Re: Query About An employee [message #417174 is a reply to message #416927] Thu, 06 August 2009 06:42 Go to previous messageGo to next message
suman.g
Messages: 88
Registered: June 2009
Member
Hi Anasser,

Have you checked the data properly??
Have you tried running the same query in other tools like SQL Plus or SQL Developer??
Run and check if it's still giving 2 rows for each records.

Regards,
Suman
Re: Query About An employee [message #417188 is a reply to message #416916] Thu, 06 August 2009 07:22 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I'm not an HRMS expert. But this is what I analyzed by looking at the data in my instance.

I THINK employee_number is not unique here.
It seems it is unique for business_group_id. Please cross check.

Moreover per person_id also, you can have many rows, as whenever you change any thing related to that employee,
it seems it is creating a new row in this table with new start_date, end_date and object_version_number.

By
Vamsi
Re: Query About An employee [message #417191 is a reply to message #417188] Thu, 06 August 2009 07:46 Go to previous message
suman.g
Messages: 88
Registered: June 2009
Member
Yes Vamsi Sir, you are correct.
We can have more than one Employees with same Employee number.
If we update any field like email address,employement,org id etc of Employee then also it creates new row with latest values.

@Anasser:
If person_id is different then these are two different employees with same Employee number (their name may also same).
Else you compare the values of each column for both records if person_id is same. Some changes in the values should be there.

Regards,
Suman
Previous Topic: Not able to find changes done in PO-Purchasing
Next Topic: Can you please let me know how to close shipping transaction exception using API
Goto Forum:
  


Current Time: Thu Dec 08 00:33:30 CST 2016

Total time taken to generate the page: 0.11026 seconds