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!

Hrms absence creation table for replace by field

Discussion in 'Oracle HRMS & Payroll' started by jagadekara, Jan 15, 2016.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I am working on Event Alert regarding HRMS Absence Creation. While creating Absence, employee will give Replace By another employee. So when employee submit the absence for approval, that time we need to send an email to Replace By employee. But I am not able to find Replace By field table.

    I find one table Per_Absence_Attendances, but this will populate when the absence is approved. But we need before approval.
    when we submit the absence, hr_api_transactions and Hr_Api_Transaction_Steps tables will populate, but there is no Replace_By field in those tables.

    So kindly give me idea to get it.

    Thanks & Regards,



    Jagadekara Reddy
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Got it.

    Some body told me that it will be available in hr_api_transactions under transaction_document column.