My Oracle Support Banner

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

Last updated on APRIL 17, 2023

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

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
Goal
Solution


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