Skip to Content
0
Former Member
Dec 02, 2011 at 02:22 PM

Using Custom function in Validation

24 Views

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'