Overlapping dates for matching columns in the Rate Matrix. This issue is reproducible only on Postgres Database environment.
The Rate Matrix is allowing rows to be updated with overlapping dates, thereby causing incorrect rates to be extracted. This issue happens only on a PostgreSQL environment. This occurs when updating an existing matrix row, not when creating a new row.
Steps to Reproduce:
Expected Results: The system would throw an error because Record 1 and Record 2 dates are overlapping: ERROR REVMGR-20219:A row with this information already exists.
Actual Results: The system does not throw the error and the record is saved with the overlapping dates.
Release : 16.0.0, 16.0.1, 16.0.2
DE64880 - The system is allowing overlapping dates when modifying existing records. It does not happen on new records. If a new row is created and the Administrator enters dates that overlap, an error is presented and the new record is prevented from getting created.
Targeted Fix in Release 16.0.3