Oracle SQL error while sending notifications

Steps to reproduce:

1. add trigger action with problem notification
2. configure media for addressee
3. generate problem event

Result:

1. action failed with error message "No media defined for user."
   
2. error in server log file

    10297:20200421:155448.713 [Z3005] query failed: [-1] ORA-00905: missing keyword [select mtm.subject,mtm.message,mt.mediatypeid from media_type mt left join (select mediatypeid,subject,message from media_type_message where eventsource=0 and recovery=0) as mtm on mt.mediatypeid=mtm.mediatypeid join (select distinct mediatypeid from media where userid=1) as m on mt.mediatypeid=m.mediatypeid]