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!

Regarding requirment

Discussion in 'Oracle HRMS & Payroll' started by raghava12, Dec 10, 2013.

  1. raghava12

    raghava12 Active Member

    Likes Received:
    Trophy Points:
    Dear All,

    Any one explain the following requirment- oT Shift migration

    1. Create2 custom table with similar structure person id (number), period_start_date (date), period_end_date (date), OT_shift_days_flat_rate (Number), OT_shift_days_perc1 (number), OT_shift_days_perc2 (number), OT_shift_days_perc3 (number). There name should be stage_table1, stage_table2

    2. There will be 2 concurrent program

    a. First concurrent process will fetch OT Shift data from stage_table1 to stage_table2.

    b. Second concurrent process will fetch OT Shift data from stage_table2 and load data into element ‘OT Pay VHSG’ in fields total_shift_flat_rate, total_shift_perc1, total_shift_perc2, total_shift_perc3 and then this element will be linked to the person for which this data you fetched from stage_table2