My Oracle Support Banner

When Would a PICKLIST_INFO_UPD_TR Record Have No Corresponding JOBS Record? (Doc ID 558278.1)

Last updated on JANUARY 21, 2022

Applies to:

Oracle Utilities Network Management System - Version to [Release 1.7 to 1.10]
Oracle Network Management for Utilities - DMS - Version and later
Information in this document applies to any platform.


Find records in PICKLIST_INFO_* tables without jobs.  When a query is run against JOBS/PICKLIST_* tables, there are records returned from the PICKLIST_INFO_* tables but (0) records are returned from the JOBS table.

The sample query should be similar to this to retrieve records:
SQL> select distinct ref_id from PICKLIST_INFO_UPD_TR where ref_id not in (select event_idx from JOBS);




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.