Employee Supervisor Table

in Oracle E-Business Suite & Oracle Fusion Applications; Hi, what table to check if employee's supervisor has been changed? Is it posible to create an event alert to ...
+ Post Reply + Post New Topic
Results 1 to 7 of 7
  1. #1
    chester04 is offline Member
    Points: 880, Level: 15
    Join Date
    09 Feb 2011
    Posts
    30
    Points
    880

    Employee Supervisor Table

    Hi,

    what table to check if employee's supervisor has been changed?
    Is it posible to create an event alert to send email notification when there is a change in employee supervisor? any reference document?

    Thanks


  2. #2
    Amy
    Amy is offline Junior Member
    Points: 310, Level: 6
    Join Date
    03 Mar 2011
    Posts
    12
    Points
    310

    Re: Employee Supervisor Table

    Hi,

    I guess a trigger can be set up for the particular field ; so that whenver there is a change in value it triggers a notification e-mail to the interested parties for further action.

    Thanks,
    Amy

  3. #3
    zangafa is offline Junior Member
    Points: 120, Level: 2
    Join Date
    19 Jul 2011
    Posts
    10
    Points
    120

    Re: Employee Supervisor Table

    Per_all_assignments_f and the column name is supervisor_id that column = person_id in table per_all_people_f

  4. #4
    zangafa is offline Junior Member
    Points: 120, Level: 2
    Join Date
    19 Jul 2011
    Posts
    10
    Points
    120

    Re: Employee Supervisor Table

    and if you want keep tracing that happen on the SUPERVISOR changes enable the audit on PER_ALL_ASSIGNMENTS_F

  5. #5
    Bharat's Avatar
    Bharat is offline Forum Guru
    Points: 27,160, Level: 97
    Join Date
    26 Dec 2011
    Location
    Vijayawada, India
    Posts
    1,453
    Points
    27,160

    Re: Employee Supervisor Table

    please have a look into the document below for audit trails in Oracle HRMS.

    Document
    Regards,
    Bharat G.

  6. #6
    sameer_srk is offline Junior Member
    Points: 50, Level: 1
    Join Date
    04 Oct 2012
    Posts
    1
    Points
    50

    Re: Employee Supervisor Table

    Hi
    Yes trigger can be written, But its not recommended because all hrms table is date track (i hope u understand Date track Modes in HR)
    You can use this query below and change it to compare the supervisor change......... i have done this for grade changes.

    select asg1.assignment_number,
    case
    when asg1.grade_id <> asg2.grade_id then
    asg1.grade_id
    else
    null
    end only_changed_grade
    from per_all_assignments_f asg1,
    per_all_assignments_f asg2
    where asg1.assignment_id = asg2.assignment_id
    --and asg1.person_id = 202
    and asg1.grade_id is not null
    and asg1.effective_start_date between to_date('01-MAR-2013') and to_date('31-MAR-2013')
    and asg1.effective_start_date-1 between asg2.effective_start_date and asg2.effective_end_date

  7. #7
    Bharat's Avatar
    Bharat is offline Forum Guru
    Points: 27,160, Level: 97
    Join Date
    26 Dec 2011
    Location
    Vijayawada, India
    Posts
    1,453
    Points
    27,160

    Re: Employee Supervisor Table

    In how many scenarios does the query works? I mean when we assign new grade value to it or to update the existing value or changing the old value to empty?
    Regards,
    Bharat G.

Other Solutions
  1. how to find employee names per organization
    By nestor in forum Oracle HRMS & Payroll
    Replies: 4
    Last Post: 03-11-2013, 10:41 AM
  2. Replies: 5
    Last Post: 07-19-2011, 01:40 PM
  3. Add employee in expense report
    By chester04 in forum Oracle SCM & Manufacturing
    Replies: 1
    Last Post: 05-24-2011, 05:46 AM
  4. Employee updation not happening in case of wrong employee ID assignment to Supplier
    By bk_mathew in forum Oracle E-Business Suite & Oracle Fusion Applications
    Replies: 3
    Last Post: 11-26-2010, 02:52 AM