After installing the latest TDM version 4.10, we executed a masking job for a small set of tables. The ADDDAYS() doesn't seems to be working.
SOURCE DB: ORACLE
Release : 4.10
Component : Web Portal - Data Masking
Below is a quick test with 2 rows of data:
2000-01-01 (01-JAN-00)
0001-01-03 (03-JAN-01)
When using the ADDDAYS masking function to add 10 days to the two dates, we see 10 days were added as expected to the first row, which is a valid date. However, nothing was added to the second date.
Try changing the date to a valid date, such as 2000-01-01, and you should find the masking work.