Skip to main content

My Custom Event is not working. Can anyone help with this issue please?

I have the custom attribute ‘Date’ to be:

NVL(lora1app.PROJECT_MISC_PROCUREMENT_API.Calculate_Required_Date(lora1app.ACTIVITY_API.Get_Early_Finish(lora1app.ACTIVITY_API.Get_Early_Finish(&PROJECT_ID), ACTIVITY_SEQ,OFFSET)))

and I want it to trigger an error when a past date is entered in the date field. I currently have this in the Event and I set the Event Action but it is not triggering the error.

Event.

 

Event Action

Main Screen where the Error is to display.

 

I would try having the check process in the Event Action code, instead of embedding it in the Custom Attribute. I’m not sure if the NVL is the correct format, but anyways you want to compare whatever value was entered into the specific Required Date field.

IF (value) < sysdate THEN

Error_sys…

ELSE

NULL;

END IF;

Terms & ConditionsCookie settings