Absence Fast formula error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Absence Fast formula error

edited Nov 22, 2019 7:23AM in Workforce Management 20 comments

Summary

Absence Accrual Formula - LEGAL_EMPLOYER_ID

Content

Here is my Absence Accrual Formula .

Code is below.

DEFAULT for ANC_ABS_TYP_NAME IS ' '
DEFAULT for LEGAL_EMPLOYER_ID IS 2323
 
 
INPUTS ARE IV_END_DATE(date), IV_START_DATE(date)
 
/*start checking annual type */
IF (ANC_ABS_TYP_NAME='Annual Leave')THEN
(
 
/*diffrence between end and start days */
 l_no_of_days = DAYS_BETWEEN(IV_END_DATE,IV_START_DATE)
 
/* compare legal entities */
 
/***************/
 if (
LEGAL_EMPLOYER_ID = 55555
)
then
 
       IF (l_no_of_days < 0.5) THEN
       (
          VALID='N'
          ERROR_MESSAGE = 'Absence Duration Cannot be less than 0.5 days'     
       )
      
       IF (l_no_of_days > 16) THEN

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!