EM13c : ORA-00932 + JBO-27122 Error Reports On OEM Incident Manager Page After Firefox Update To 98 (Doc ID 2858838.1)

Last updated on JUNE 07, 2022

Applies to:

Symptoms

After upgrading of Firefox to newest version (98.1.0) we get following error in Enterprise Manager (EM) Cloud Control 13.4, accessing the Incident Manager Page.

ORA-00932: inconsistent datatypes: expected PLSQL INDEX TABLE got CHAR
JBO-27122: SQL error during statement preparation. Statement: WITH events
AS (SELECT * FROM ( SELECT tgt.target_name, tgt.target_type, seq.severity,
seq.target_guid, seq.event_class, seq.cat_bit_set, seq.last_updated_date,
seq.source_obj_type, seq.source_obj_id, seq.incident_id, seq.event_seq_id,
seq.open_status, seq.closed_date, seq.is_auto_close, seq.is_adr_aware,
seq.curr_evt_instance_id, seq.event_name, seq.event_key, seq.incident_num,
ev_rca.correlation_state, ev_rca.is_cause, ev_rca.is_symptom FROM
em_event_sequences PARTITION(OPEN) seq, em_event_rca_state ev_rca ,
((SELECT t.target_guid, t.target_name, t.target_type, t.host_name FROM
mgmt_targets t, em_global_target_properties g_tgt_props WHERE t.target_guid
= g_tgt_props.target_guid (+) AND (g_tgt_props.lifecycle_status IN (SELECT
* FROM TABLE(CAST(:bTargetLifecycleStatus AS SMP_EMD_STRING_ARRAY)))) AND
(t.target_name LIKE :bTargetName) AND (t.target_type IN (SELECT * FROM
TABLE(CAST(:bTargetType AS SMP_EMD_STRING_ARRAY)))))) tgt
WHERE(seq.open_status = 1) AND(seq.closed_date = to_date('20991231000000',
'YYYYMMDDHH24MISS')) AND (seq.event_seq_id = ev_rca.event_seq_id(+) ) AND
(seq.curr_evt_instance_id = ev_rca.event_instance_id (+)) AND
(seq.open_status = 1) AND (seq.closed_date = to_date('20991231000000',
'YYYYMMDDHH24MISS')) AND seq.target_guid = tgt.target_guid AND
(seq.last_updated_date >= (add_months(sys_extract_utc(systimestamp), -1)))
ORDER BY last_updated_date DESC) WHERE rownum

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.