I have a custome function that returns a varchar of TRUE or FALSE.
I have tested the function and even hardcoded with TRUE.
However when I use it in the Validation and even thought all lines return True they get pushed into the Fail table.
I have the rule Enabled and action on Fail is set to "Send To Fail"
I have printed out the data being returned and all Pass so why are they being sent to the Fail.
I call the function like this.
So I assume that if the vlaue returned is True it should go to the true table.
P2CMM01_LKP_STORAGE_LOC("Material Type(MTART)", "+STORAGE_LOCATION","+MATERIAL_NUMBER") = 'True'