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?