ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US F378C4172D108303E0532801CA0A72A3 select decode(vdae.message_type,1,'Unknown',2,'Incident_Error',3,'Error',4,'Warning',5,'Notification',6,'Trace',vdae.message_type) message_type_desc, decode(vdae.message_level,1,'Critical',2,'Severe',8,'Important',16,'Normal',vdae.message_level) message_level_desc, xxen_util.module_type(vdae.module_id) module_type, xxen_util.module_name(vdae.module_id) module_name, vdae.* from v$diag_alert_ext vdae where 1=1 order by vdae.record_id Y US DBA Alert Log V$DIAG_ALERT_EXT shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB). You could schedule it, for example, in incremental mode to send an email with errors that occured since the last scheduled report run. Enginatics 1=1 1 5 1=1 vdae.message_text like '%'||:message_text_includes||'%' Char US Message Text includes 2 7 1=1 vdae.message_type=decode(:message_type,'Unknown',1,'Incident_Error',2,'Error',3,'Warning',4,'Notification',5,'Trace',6,:message_type) LOV custom Y select decode(vdae.message_type,1,'Unknown',2,'Incident_Error',3,'Error',4,'Warning',5,'Notification',6,'Trace',vdae.message_type) value, count(*) description from v$diag_alert_ext vdae group by vdae.message_type order by count(*) desc US Message Type 3 8 1=1 vdae.message_level=decode(:message_level,'Critical',1,'Severe',2,'Important',8,'Normal',16,:message_level) LOV custom Y select decode(vdae.message_level,1,'Critical',2,'Severe',8,'Important',16,'Normal',vdae.message_level) value, count(*) description from v$diag_alert_ext vdae group by vdae.message_level order by count(*) desc US Message Level 4 10 1=1 vdae.originating_timestamp>=sysdate-:history_days Number 30 US History Days 5 15 1=1 vdae.originating_timestamp>=:date_from Date sysdate-:$flex$.history_days US Date From 6 17 1=1 ( vdae.message_text like 'Exception%' or vdae.message_text like '%ORA-%' and vdae.message_text not like 'Non critical error ORA-48913%' and vdae.message_text not like '%Result = ORA-31%' and vdae.message_text not in (' Result = ORA-0'||chr(10),' Result = ORA-30') ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Exceptions and ORA-% only 7 20 1=1 vdae.originating_timestamp>= ( select fcr0.actual_start_date from fnd_concurrent_requests fcr, fnd_concurrent_requests fcr0 where fcr.request_id=fnd_global.conc_request_id and fcr.parent_request_id=fcr0.request_id ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Incremental Mode :$flex$.history_days History Days Date From Default ENGINATICS 4 CLIENT_ID 16 DETAILED_LOCATION 17 DOWNSTREAM_COMP_ID 18 ERROR_INSTANCE_ID 20 FILENAME 15 HOST_ADDRESS 14 HOST_ID 12 MESSAGE_ARGUMENTS 11 MESSAGE_GROUP 10 MESSAGE_ID 22 MESSAGE_LEVEL 3 MESSAGE_LEVEL_DESC 9 MESSAGE_TEXT 21 MESSAGE_TYPE 2 MESSAGE_TYPE_DESC 7 MODULE_ID 6 MODULE_NAME 5 MODULE_TYPE 1 ORIGINATING_TIMESTAMP 19 PROBLEM_KEY 8 PROCESS_ID 23 RECORD_ID 13 SUPPLEMENTAL_ATTRIBUTES S Site Default