Error when Changing GRE
I created an Oracle Alert which will notify me via e-mail when the GRE of any employee is changed in the Assignment form. During testing, I changed a random employee's GRE and chose UPDATE mode. when I clicked save, this error occurred:
ORA-20000: Unable to send mail: ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "APPS.PERALLASSIGNMENTSF_290U_DYT", line 69
ORA-04088: error during execution of trigger 'APPS.PERALLASSIGNMENTSF_290U_DYT'
ORA-06512: at "APPS.PER_ASSIGNMENTS_F_PKG", line 1480
--------------------------------------------------------------
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-20000.
I have already requested our DBA's to turn on the the workflow notification mailer, what could be the reason why these errors were encountered?