Error when attaching value set to Extra information type in HR
Hi,
We created a new value set with a special validation rule containing the following Validate event, containing the following code:
FND PLSQL "declare
l_value varchar2( 20 ) := :!value ;
l_valid NUMBER := 0 ;
BEGIN
select INSTR(l_value ,'@')
into l_valid
from dual;
IF (l_valid=0) THEN
fnd_message.raise_error ;
END IF ;
END;
"
When attached to the flexfield and save the record we receive the fllowing error:
Error message is : APP-FND-00952: The flexfield on this field contains a value set ([]) that uses special or pair user-exit validation. This prohibits operation in the mode that optimizes performance over a wide area network.