Global Payroll and Absence Management - PSFT (MOSC)

MOSC Banner

Consume all leave balances in one application error when below the credit balance

Hi,

I would like to request your assistance to customize the formula for the leave that should consume all leave balances in one application, if the user applied below the credit balance it would be an error.


Please see the provided formula below:

IF ABSENCE_ATTENDANCE_TYPE_ID = 64 AND TO_NUMBER(duration) > TO_NUMBER(l_Maternity_balance) THEN

        (

         duration = 'FAILED'

         invalid_msg = 'Your Maternity Leave Balance is ' +l_Maternity_balance + ' Days, Please apply less than or equl to the same!!'

return duration, invalid_msg

        )


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center