My Oracle Support Banner

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

Last updated on MARCH 08, 2019

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version and later
Information in this document applies to any platform.


Oracle Utilities Analytics (OUA) 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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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