My Oracle Support Banner

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

Last updated on MARCH 27, 2018

Applies to:

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

Goal


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 th 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

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

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


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