When Would a PICKLIST_INFO_UPD_TR Record Have No Corresponding JOBS Record?
(Doc ID 558278.1)
Last updated on MARCH 14, 2025
Applies to:
Oracle Utilities Network Management System - Version 1.7.1.1 to 1.10.0.5 [Release 1.7 to 1.10]Oracle Network Management for Utilities - DMS - Version 1.7.1.1 and later
Information in this document applies to any platform.
Symptoms
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);
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |