From Ian Pun – SQL script to clear the OHIP Error Code 30 showing up on INVOICE REPORTS for the Dec 1/2022 virtual visit (for OSPs):
ALTER TABLE `oscar_15`.`radetail` ADD `error_code_backup` char(2) NOT NULL DEFAULT '';
update radetail set error_code_backup = error_code where error_code = "30" and error_code_backup = "" and (service_code = "K300A" or service_code="K301A") ;
update radetail set error_code = "" where error_code_backup = "30";