All Alert Requests Error Out And Show Bad Select Statements (Doc ID 1174735.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.
ALRALERT.fmb
***Checked for relevance on 14-Dec-2012***

Symptoms

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.

ERROR
-----------------------
/mariat1ap/mariat1appl/alr/11.5.0/bin/ALECDC
Program was terminated by signal 11

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

STEPS
-----------------------
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.

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

Changes

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

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