We have tried using FormatFPE1 – with the option to mask as a number. However, where the column is defined as VARCHAR2, it ends up failing, unable to parse the data element as soon as it encounters a “character” which is often the case with varchar2 columns. There are varchar2 columns defined to house any source of identification in lieu of SSNs or tax IDs… and often times there are DLs and other state IDs also included, often time there are global system assigned IDs as part of values which contains Alphabetic characters.
Can you suggest to us a correct solution? If we use FormatEncrypt function, it masks all numbers differently and all Varchar2 differently. What we need in our masking function is that if the value is numeric, then whether the data type is Number or VARCHAR2, it would process it as numeric. If the data type is varchar2, and it contains non-numeric characters, it would treat them as such and if any special characters are there, it would leave them alone.
Kindly suggest a solution urgently, as we aren’t able to progress in our masking with FormatFPE1 (I had 40 plus job failure in 2 days).
Release : 4.10
The recommended masking function is FORMATFPE1EXT. This function provides more flexibility than the FormatFPE1 function. Below is a short summary of the FormatFPE1Ext parameters.