Since upgrading to 4700, the following error messages appear within work orders:
Unexpected error occurredORA-04098: trigger HIGHWAYS.DEFECTS_ALT4 is invalid and failed re-validationORA-06512: at HIGHWAYS.MAIWO
Unexpected error occurredORA-04098: trigger HIGHWAYS.WORK_ORDERS_ALT1 is invalid and failed re-validation
There was a change to a package that may affect some existing alert triggers so they need to be dropped and recreated to overcome this. To do this through the form, navigate to Exor, Reference Data, Mail, Alert Setup and recreate the existing work order triggers by using the drop and recreate buttons.
If this doesn't work, use the following to identify the trigger name for your alert:
select halt_trigger_name, halt_description from hig_alert_types
select halt_trigger_name, halt_description
Then you can try recompiling the trigger in sqlplus as the table owner, log into sqlplus
alter trigger <insert trigger name from query above> compile;
If it displays errors PLS-00306 wrong number or types of arguments in call to CREATE_TRG_ALERT then drop the trigger in SQL*plus:
drop trigger <insert trigger name from query above>;
Once this has completed, recreate the trigger through the application as per the guidance above.
Managed Service users should contact the Support team if dropping and recreating via the forms does not work.