Expected Close Date for Opportunities ( s_opty . sum_effective_dt ). Has anyone updated it through *

Hi there.

The business asked us to mass update the Expected Close Date for a list of opportunities (and dates).

a) I can easily make it through SQL directly in the database.
( update s_opty set last_upd = sysdate, last_upd_by = XXX , sum_effective_dt = YYY, where row_id = ZZZ )

Are you aware of any data integrity issues?

- Should anything else be recalculated or updated at the same time?
- Does this e.g. have any impact to any sort of expected revenue?

There is a validation that the Expected Close Date must be in the future.

- Would anything wrong happen if I adjust this to a past date?