Has anybody encrypted a column in IFS?

Didn’t encrypt. In the view level we can call custom method and return the actual value for specific users by checking permission set and for others any hard coded value like ‘XXXXXXXX’. There we have the requirement only not to show it for all users.

SELECT person_id                      person_id,
              --Pers_Api.Get_insurance_id(person_id) insurance_id,
             <cust_pkg_api>.Get_Restricted_SSN(person_id,Pers_Api.Get_insurance_id(person_id)) insurance_id,