Skip to main content
Question

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

  • July 10, 2023
  • 2 replies
  • 473 views

WyrDavidB
Hero (Partner)
Forum|alt.badge.img+9

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

WyrDavidB
Hero (Partner)
Forum|alt.badge.img+9
  • Author
  • Hero (Partner)
  • July 11, 2023

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


WyrDavidB
Hero (Partner)
Forum|alt.badge.img+9
  • Author
  • Hero (Partner)
  • January 18, 2024

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