How to Add Validation Based on Customer Counts to Event Details Completion Fields (Doc ID 2155657.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 and later
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 and later
Information in this document applies to any platform.

Goal

How can we add validation rules to Event Details(picklist) to catch these two situations --

1) If type_om = 'Primary' and jobs.user_cust_out = 0 then display a message "Type should be NONE when Corrected # Cust Out is zero"

2) If type_om = 'Service' and jobs.user_cust_out <> 1 then display a message "Customer Count should be 1 when Type = Service"
 

Solution

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 hundreds of Community platforms