Task Number Validation

Content

The business wants the system to reject any values in the task number field outside of Chars A-Z, a-z, 0-9 and spaces. We want to build this control to avoid data failure issues in other outbound interfaces. I'm not sure page composer will support such personalisations so I attempted to do this validation via a DFF. See attached file.

I'm using this syntax in the Where box. [Table = PJF_PROJ_ELELMENTS_B]

object_type          = 'PJF_TASKS'

AND      element_type        IN ('FIN_EXEC', 'FINANCIAL')

AND NOT regexp_like (:{SEGMENT.ELEMENT_NUMBER}, '[^A-Za-z0-9 ]')

When attempting save the value set I receive this error