All Alert Requests Error Out And Show Bad Select Statements

(Doc ID 1174735.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle Alert - Version to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 14-Dec-2012***


On Oracle Applications after recently migrating data and/or upgrading then submitting any alert request (Ex. Purge Alert and Action Set Checks) it fails with the following error.

Program was terminated by signal 11

Can also see:
APP-ALR-04140: Oracle Alert was passed an unknown datatype.

The issue can be reproduced at will with the following steps:
1- Login to Oracle Applications.
2- Go to (Alert Manager --> Request --> Check)
Application --> Alert
Alert --> Purge Alert and Action Set Checks
Submit Request
3- Then go to View Request to see the failed concurrent request and in the log file the above error message reported.

Open Alert Definition (Alert --> Define), see Select statement as unreadable like:
S E L E C T .....


Upgrade and / or migrate data using Export / Import, OATM, DataPump from one instance to another.


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