Question

Absence Limit Generation error - ORA-20124: Error.NULLVALUE: Field [ABS_LIMIT_DIMENSION] is mandatory for Absence Limit Value and requires a value

  • 10 July 2023
  • 2 replies
  • 191 views

Userlevel 3
Badge +7

Hello Everyone,

I am trying to set absence limits for employees and am getting the error message 

ORA-20124: Error.NULLVALUE: Field [ABS_LIMIT_DIMENSION] is mandatory for Absence Limit Value and requires a value.

when I use the “generate limit” button in the “absence limit log” page (and also the “absence limit year” page.

I believe I have set up the absence limit definition, limit definition details, and limit value details correctly, as shown in the screen shots below - but I must be missing something.

These are the settings for the absence type

 

this is one of the employee file records

 

I am getting the same error for a contractor type employee and a permanent type employee.

If anyone is able to assist, I would be very grateful.

Many thanks in advance - Dave

 

IFS Cloud 22R2.5


2 replies

Userlevel 3
Badge +7

Hi - thanks for looking - this issue has now been resolved.

I was trying to create absence limits for a time period where there was no employment or assignment.
By ensuring all the dates matched up, I was able to generate the limits.

Cheers

Dave

Userlevel 3
Badge +7

Another possible reason for this error is where an employment type  limit value setting (details) has not been defined for the absence type.
 

 

Reply