MDM Operational Dashboard Zones Return Server Error (Doc ID 2771547.1)

Last updated on SEPTEMBER 19, 2022

Applies to:

Symptoms

On : 2.3.0.2.0 version, Environment

MDM Operational Dashboard Zones return Server Error

When the MDM Operational Dashboard Portal is viewed, 2 zones (Incomplete IMDs by Status & Incomplete IMDs Trend) are returning the following error:

ERROR
------------
"The server has encountered a problem. Please contact your system administrator."

The cause of the errors on the two Zones are because the Snapshot Details of the Statistics Snapshot for the Incomplete IMDs have rows that do not have descriptions.
Suspect that due to this, the UI Map is not being rendered properly. The code that captures the Statistics Snapshot includes the following query that is causing this:

select trunc(IMDC.CRE_DTTM) as "DATE",
IMDC.BO_STATUS_CD as "TYPE",
count(IMDC.INIT_MSRMT_DATA_ID) as "CNT",
(select DESCR
from F1_BUS_OBJ_STATUS_L
where /*BUS_OBJ_CD = IMDC.BUS_OBJ_CD
and */BO_STATUS_CD = IMDC.BO_STATUS_CD
and LANGUAGE_CD = :LANGUAGE
and rownum = 1) as "DESCR"
from D1_IMD_CTRL IMDC
/* IMDC.CRE_DTTM > trunc(.EndDate) - .TrendDays */
where IMDC.CRE_DTTM between trunc(:EndDate) - :TrendDays and trunc(:EndDate) + 1
group by trunc(IMDC.CRE_DTTM), IMDC.BO_STATUS_CD
order by "DATE" asc, "CNT" desc

Running this in SQL Developer returns no descriptions for some of the records

It looks like this is happening because the part of the SQL that retrieves the description is not filtering by the BO Code (it has been commented-out in the base script).
So it is possible to retrieve the description from other BOs that have the same status.

BOs that reference Parent BOs do not have descriptions on their Language Table which is why what’s being retrieved is blank, which we believe is causing the error being returned in the zone.

Changes

Cause

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