search cancel

Unable to mask the Computed columns


Article ID: 105815


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


I am trying to mask the Computed column in Siebel application, using fast Data Masker 4.4, but it is throwing an error.


Component: TDMFDM


The product is functioning as designed. This is a restriction for both SQL Server and Oracle, since "Computed" columns cannot be updated or inserted into, as they are "computed' by the server.

For more information, and as an example, see the following Oracle documentation:

Please note, you can mask any of the "real" columns that are used by the "computed" column, which would effectively mask the value, but we cannot update the "computed" columns themselves. Using the Oracle documentation as an example, masking "salary", "comm1", and "comm2" would ensure that the "salary1" and "salary2" values were effectively masked.

If you have questions or need additional information, please check with your DBA.