Event Alerts Fail With APP-ALR-04110: Oracle Alert Found An Invalid Number Of Bind Variables In The SQL Statement (Doc ID 948037.1)

Last updated on JUNE 08, 2017

Applies to:

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

Symptoms

Periodic alerts are woking fine. After Oracle Alerts are configured using sendmail feature, but none of the event alerts seem to work.

When an event alert is triggered, no Email is send to the user. There is no entry in the /var/log/maillog file. No concurrent request being submitted too.

Tried to test the setup with, Diagnostics #3 - Event Alert. The concurrent request completes normally but no e-mail was sent.
After adding the ORG ID in the installations tab of Alert Details, the program ALR_DISTRIBUTION_LISTS (Check Event Alert) errors with:

APP-ALR-04110: Oracle Alert found an invalid number of bind variables in the SQL Statement:
              select ... from ALR_DISTRIBUTION_LISTS where rowid=':0'
APP-ALR-04106: Please correct the user-defined SQL statement for this alert.


Steps To Reproduce:
Trigger any event alert.

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