Managing Negative Leave Balances in Oracle EBS R12.1.3 HCM

Tom GilpinOracle, Technical TipsLeave a Comment

Managing Negative Leave Balances in Oracle EBS R12.1.3 HCM

The Challenge

Managers of Oracle E-Business Suite HCM applications may wish to implement a business rule that prohibits employees from taking leave that exceeds their balance (ie result in a negative leave balance).  Until now, E-Business Suite has not provided an easy way to implement that business rule, rather, users needed to write custom code for the ‘BG_ABSENCE_DURATION’ fast formula.  For many users these seemed overly complicated.

The Solution

Beginning with E-Business Suite R12.1.3, following the simple steps below, Oracle has provided a profile option that can be set to prevent employees from taking leave that exceeds their balance.

  • Authenticate to the application, and select the responsibility ‘System Administrator’.
  • In the Navigator, select ‘Profile’ then ‘System’.

 

responsibilities

 

navigator

  • In the ‘Find System Profile Values’ form, enter ‘HR: Allow Absence Negative Balance’ in the ‘Profile’ field, then click the ‘Find’ button.
  • In the resulting ‘System Profile Values’ form, enter the appropriate value at the ‘Site’ level.

 

find profiles

 

profile value

  • If the value is entered as ‘Yes’, existing behavior continues.  If the value is entered as ‘No’, workers who submit leave beyond their balance will get a message that their leave balance is negative and they cannot apply for leave.
  • Save the transaction.

 

The Result

With this set up, E-Business Suite users can now manage negative leave balance rules simply via a profile option.

Leave a Reply

Your email address will not be published. Required fields are marked *