There Are Some PICKLIST_INFO_UPD_TR Records That Have No JOBS Records
Last updated on JULY 05, 2016
Applies to:Oracle Utilities Network Management System - Version 126.96.36.199 to 188.8.131.52 [Release 1.7 to 1.10]
Oracle Network Management for Utilities - DMS - Version 184.108.40.206 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);
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms