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!

BG Absence Formula

Discussion in 'Oracle HRMS & Payroll' started by Badawy, Nov 12, 2012.

  1. Badawy

    Badawy Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Dear all ,

    please advice me how to write condition in ( bg absence formula ) to return HH:MM format on duration , how i can define hours on bg abence formula , my bg formula not allowed me to return hours and min in duration , just numbers , for ex when i creat new absence which his unit is hours from 11/11/2012 08:15 to 11/11/2012 12:00 , it returned 3.75 on duration , i want to able it to return 03:45 in duration .

    is there anyone can help me ??
     
  2. sivaramakrishna.d

    sivaramakrishna.d Active Member

    Messages:
    61
    Likes Received:
    6
    Trophy Points:
    160
    Dear Badawy,

    Can you send the code of your BG_ABSENCE_DURATION fast formula and functions used in fast formula to return the duration.
    i guess it is customised and duration calculation is wrong.

    Siva Ram
     
  3. diwaapps@gmail.com

    diwaapps@gmail.com Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    75
  4. UdayRaj Singh

    UdayRaj Singh Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    85
    Location:
    Australia
  5. ahmed.gouda

    ahmed.gouda Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Dears;
    i need to prevent user from using the previous year accrual balance.
    Example: 2016 balance carried over into 2017 and i need to close the period of 2016 at the middle JANUARY of next year to prevent employee from requesting vacation from 2016 Balance (15-12-2016 to 20-12-2016) for example.
    Employee forgot to submit his 2016 vacation and if he created and approved it will deduct normally from 2016 balance.