OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Query About An employee (Query About An employee)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query About An employee [message #416909]

Wed, 05 August 2009 01:57

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

monikabhakuni
Messages: 110
Registered: September 2008
Location: India

Senior Member

Hi,

Can you post your query and its output please.

Best Regards,
Monika

Report message to a moderator

Re: Query About An employee [message #416914 is a reply to message #416909]

Wed, 05 August 2009 02:26

anasser
Messages: 8
Registered: July 2009

Junior Member

SELECT * FROM per_people_f
WHERE employee_number='111111'

and the result it is too long

Report message to a moderator

Re: Query About An employee [message #416915 is a reply to message #416914]

Wed, 05 August 2009 02:27

ThomasG
Messages: 3211
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?

Report message to a moderator

Re: Query About An employee [message #416916 is a reply to message #416915]

Wed, 05 August 2009 02:31

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

Report message to a moderator

Re: Query About An employee [message #416927 is a reply to message #416916]

Wed, 05 August 2009 03:52

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

Report message to a moderator

Re: Query About An employee [message #417174 is a reply to message #416927]

Thu, 06 August 2009 06:42

suman.g
Messages: 89
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

Report message to a moderator

Re: Query About An employee [message #417188 is a reply to message #416916]

Thu, 06 August 2009 07:22

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: Query About An employee [message #417191 is a reply to message #417188]

Thu, 06 August 2009 07:46

suman.g
Messages: 89
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 08:52:35 CDT 2024