All Alert Requests Error Out And Show Bad Select Statements
(Doc ID 1174735.1)
Last updated on DECEMBER 13, 2023
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
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
-----------------------
/ap/appl/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
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 |