1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Sub ordinate Detials in HRMS

Discussion in 'Oracle HRMS & Payroll' started by vamsioracle, May 21, 2009.

  1. vamsioracle

    vamsioracle Forum Expert

    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    140
    Hi


    Is it possible to get all the subordinate details in the hierarchy for an employee.

    Suppose X is th manager for A,B,C and D, where can i capture the details of subordnates, if i have only the X details.


    thanks in advance
    Vamsi
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Hi vamsi,

    i am not sure i follow your question very well. I assume you are talking about the position heirarchy. You enter the subordinate details for any position heirarchy from the position heirarchy window. It is located at Hrms Manager Responsibility-->Work Structure-->Position-->Heirarchy.

    In the Block below you can enter all the subordinate details.
     
  3. vamsioracle

    vamsioracle Forum Expert

    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    140
    Hi

    I got the answer. Actually i want all the people who report to a manager.I will enter the supervisor id and i want all the people who report to this supervisor

    I used this query

    select person_id from per_all_assignments_f where supervisor_id = :pARAM


    thanks a lot
    vamsi
     
  4. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    oops.. sorry i had completely misunderstood u. I thought you wanted to know how to enter the subordinate details in a position heirarchy! :(