DELETE FROM cmn_application_preference WHERE preference_name = 'x_validator_definition_oid';
INSERT INTO cmn_application_preference (id, preference_name, preference_value, class_name, description) VALUES (nextval('cmn_application_preference_id_seq'), 'x_validator_definition_oid_suffix', '3.', 'java.lang.String', 'Cross validators oid suffix.');

UPDATE xval_cross_validator SET oid=((SELECT preference_value from cmn_application_preference where preference_name = 'root_oid')||(SELECT preference_value FROM cmn_application_preference WHERE preference_name LIKE 'x_validator_definition_oid_suffix'))|| id WHERE oid LIKE '%null%';
