OUA: CF_CTRL_ZONE_OUTG IEEE Metrics Are Not Getting Calculated (Doc ID 2379251.1)

Last updated on JUNE 05, 2024

Applies to:

Goal

Oracle Utilities Analytics (OUA) 2.7.0.0.5: CF_CTRL_ZONE_OUTG IEEE Metrics are not getting calculated

The various metrics in the control zone outage fact are not getting calculated. In looking at the code, there is a join condition when populating TMP02 table that does:

So it selects all of the status values that are not in the b1_job_param_vw view. This view pulls data from the B1_JOB_PARM table, which is an NMS-specific table that is populated with the APEX admin tool. The documentation for the Event Status values in the Admin guide is:

Event Status: This holds a list of possible Event Status values. Only those whose event status value is specified in the parameters are included in the extract. Multiple values can be configured for this parameter.

We have the following status values in APEX: 0, 1, 2, 4, 7, 10, 11, 12, 13, 14, 15, 17, 18 because those are the ones we want brought in.

What is the proper use of the Event Status values in APEX, or what changes need to be made in the code so the metrics can get calculated
 

Solution

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