ORA-1821 occurred at line 138 of formula BG_ABSENCE_DURATION Cause: Whilst executing PL/SQL, an Orac

ORA-1821 occurred at line 138 of formula BG_ABSENCE_DURATION Cause: Whilst executing PL/SQL, an Oracle error occurred. The line number and line position, are given where available Action: Please refer to your system administrator.

Error occured when creating absence after modifying bg_absence_duration fast formular.

here is the block of code added:

if ( (to_date('29-may-2013' , 'dd-mmm-yyyy') > date_start) and

(to_date('29-may-2013' , 'dd-mmm-yyyy') < date_end ) ) then

(

duration = to_char(GET_WORKING_DAYS(date_start,date_end)-1)

)

29th may is a public holiday so we want to exclude it from leave days computation if leave days fall within the date)