I have redacted the Number Column of a Database Table.The column contains Check Number which is ten digits. The redaction on this Check Number column is partially masked with 0 for first three digits.

When I query the column from the Database, it skips the first three digits and shows only the remaining 7 digits.If the redaction is applied with non-zero digits, it displays properly.

Again, in the UI when I try to edit and modify the last three digits of the check number field, while saving the data, it is saved with the actual redacted value itself in the table.

For Example, the value of Check Number field is 1234567890, If its partially masked with Zeros for first three digits, it displays in the UI/DB only 4567890.



If the same column is partially masked with 8 for first three digits instead of Zero, upon edit and save of the screen, the values gets saved in the database as it is.

For Example, the actual value in the column is 1234567890 and with redaction it displays as 8884567890.In the UI, I modify only the last digit of displayed value to 888456791.While saving the screen, the actual value in the table gets saved as "888456791" instead of 1234567891.



When I try to redact the NUMBER COlumn with * or # or with anyother special characters,I get an error saying "ORA-28074: The "REDACT_PARTIAL_MASKCHAR" field of the redaction parameters is not valid " while creating the policy itself.

How can this be achieved?

My Requirement is to partially Mask the First three digits of Check Number in UI.The Mask Character can be either Number or any special character.

Below is what I do to redact the first three digits of the Check Number with special character *(Asterik).


BEGIN
DBMS_REDACT.ADD_POLICY(
object_schema => 'OFSLLPOC',
object_name => 'UIX_CBC_FVW',
column_name => 'CBC_CHECK_NBR',
policy_name => 'redact_cnb_pm',
function_type => DBMS_REDACT.PARTIAL,
function_parameters=> '*,1,3',
expression => 'sys_context(''USER_RESP'',''RESP'') = ''COLLECTOR''',
enable=>true
);

END;



While compiling this policy, I get the error saying ORA-28074: The "REDACT_PARTIAL_MASKCHAR" field of the redaction parameters is not valid.



Is there anyway I can mask the number field with special character?



Since, the error came up as ORA-28074,I try creating the policy with Partial Mask of first three digits of the field. The policy is below.


BEGIN
DBMS_REDACT.ADD_POLICY(
object_schema => 'OFSLLPOC',
object_name => 'UIX_CBC_FVW',
column_name => 'CBC_CHECK_NBR',
policy_name => 'redact_cnb_pm',
function_type => DBMS_REDACT.PARTIAL,
function_parameters=> '0,1,3',
expression => 'sys_context(''USER_RESP'',''RESP'') = ''COLLECTOR''',
enable=>true
);

END;



When the actual value of Check Number is 1234567890, since I partially mask the first three digits to 0, it gets displayed in the UI as "4567890". The same is the case when I query the data from Database, as well.The output of the below query is

SELECT CBC_CHECK_NBR FROM UIX_CBC_FVW;

CBC_CHECK_NBR

--------------------------

4567890



Now, I try to update the last three digits of this masked field from UI(ADF) to 911, the data in the database gets stored as "45678911" instead of "12345678911" which is incorrect.The ADF Frame work generates update statement for UIX_CBC_FVW as "UPDATE UIX_CBC_FVW SET CBC_CHECK_NBR=:BV". Since, the masking of the digits is only possible with digits, it considers the masked value as an actual value and updates in the table.