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!

Oracle Hrms functional issue

Discussion in 'Oracle HRMS & Payroll' started by ram_rao, Apr 19, 2013.

  1. ram_rao

    ram_rao Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi all

    i need help on the create new element 'Annual leave plan adjustment element'.
    previously the value is stored in the 'Annual leave plan full time carried over' element,now values is need to store in new element.

    now i have create new element by place of old element and need to use this element in effected programs.

    Please let me know any one what is the steps to resolve this.

    Regards
    Bhupathi
     
  2. kishvishnu

    kishvishnu Guest

    Hi Bhupati,

    As far as I understand ur issue, you can rename that old element. That would automatically reflect for all the attached employees/wherever.

    This is only when u don't need the old element again.

    Let me know if u have any other thoughts..

    Regards
    Vishnu
     
  3. ram_rao

    ram_rao Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Thanks for your reply,

    I don't want to delete old element,just instead of old element i am creating new element and store the data.

    Regards
    Bhupathi
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Oh instead of old element (XX) you want to replace it with some other new element (YY) to the employee? Please correct me if I understood wrongly.
     
  5. ram_rao

    ram_rao Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi Bharat G

    As-is :
    User used this carry over element to store the annual leave adjustment as temporary solution since annual leave adjustment doesn't exists in the system.

    To-be :
    User would like to create a new element to store this information. User can inputted any value for this element. This is additional leave that employee will entitled to take over the year. This may effects the new accrual annual leave count. Also, it may effect the report with this annual leave count information. Please review what programs need to modify with the new element.

    Regards
    Bhupathi
     
  6. rsamlal

    rsamlal Active Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    65
    What exactly is preventing you from creating new element?
    regards
    Rishi Samlal
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Bhupathi,

    Can you reply on this.
     
  8. ram_rao

    ram_rao Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi

    Actually my requirement:

    Upto now leave adjustment are storing in 'Annual Leave Plan Full Time Carried Over'
    now i have to create new element 'Annual Leave Plan Adjustment' .once create this element leave adjustment will store in this element ,meanwhile i have to change the code where this element will effect..

    1.I have to create new element:Annual Leave Plan Adjustment
    2.and created accrual plan : Annual Leave Plan Adjustment1 and attached above new element in net calculation.

    But while i develop query :

    pay_element_types_f pet,
    pay_element_entries_f pee,
    per_all_assignments_f pa,
    pay_accrual_plans pap
    where pee.assignment_id = p_assignment_id
    and pet.element_name in ('Annual Leave Plan Full Time',
    'Annual Leave Plan Part Time',
    'Annual Leave Plan Contract Temp',
    'Annual Leave Plan Adjustment') --- added by bhupathi on 22-4-2013 for leave adjustment
    and pet.element_Type_id = pee.element_type_id
    and pa.assignment_id = pee.assignment_id
    and pap.accrual_plan_element_type_id = pet.element_type_id

    i am not getting data if i remove last join(bold font) in the query i am getting the data.

    this is my issue,i think let me know have any mistake in creation of accrual plan and element link.

    Regards
    bhupathi