Data redaction with regex in Oracle
Thanks to @mustaccio's question got me thinking about datatype issues. 

NVarchar2 seems to be the issue in this problem. 

Creating a copy of the column in varchar2 fixed the issue. Data redaction on varchar2 is working as expected.