Cannot Delete Obsolete Alert Distribution Lists (Doc ID 1558611.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Alert - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

You cannot delete obsolete distribution lists in Oracle Alert.


When trying to delete an error message says "You cannot delete a distribution list that is used by an action" but the form References (Distribution List > Tools > References) does not show anything.

The lists were attached to an action in the past but you are using other lists for the actions.

The lists appear in alr_actions with enabled_flag = 'N' and with end_date_active filled in.

Cause

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