Problem: Attempting to delete announcements imported from old courses results in an error similar to ” ORA-01407: cannot update (“BB_BB60″.”ANNOUNCEMENTS”.”ORDER_NUM”) to NULL”.
Solution: Re-ordering the announcement before deleting it should allow it to be deleted.