Alert based on current date - Workforce Compensation

Hi everyone,

we are facing an issue regarding the workforce compensation plan. A client of us has asked to set an alert for a specific component that is based on the current date. Specifically we should use two column: the first one to write the date of validation of the component, while the second column that we should use should display the current date.

We used a FF to extract the sysdate:

DEFAULT FOR PER_SYS_DATE_TIME IS '1951/01/01'

ld_date = TRUNC(get_sysdate())
RETURN ld_date

Anyway when we tried to set the alert it seems that for the condition we cannot use a value of date that is displayed in a userdefined column (in this case the "current date", so we cannot se the alert and save it.