...
update c_invoice
set dateinvoiced = '2016-08-15 00:00:00'
where dateinvoiced = '2016-08-17 00:00:00' and docstatus = 'DR'
2. Atualizar datas de emissão na nota fiscal
begin transaction;
alter database c_invoice disable trigger all;
update c_invoice
set dateinvoiced = to_date('06/11/2018', 'DD/MM/YYYY')
where dateinvoiced >= to_date('01/11/2018', 'DD/MM/YYYY') AND dateinvoiced < to_date('01/12/2018', 'DD/MM/YYYY')
and issotrx = 'Y'
and ad_org_id = '540F865E2D6E401F98B7922AADA93EB3'
and coalesce(trim(documentno),'') <> ''
;
alter database c_invoice enable trigger all;
commit;