R12.2: APP-ALR-04102: Internal SQL Error Occurred. (ROUTINE=load_values)

(Doc ID 1664058.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle Alert - Version 12.1.3 and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

All Alerts, even simple 'select x into &output from dual' fail with error:

ERROR
------------
ALECDC module: Check Periodic Alert
APP-ALR-04102: Internal SQL error occurred. (ROUTINE=load_values) (FILE=5069629/alr/src/util/aluprf.c) (LINE=75)
SELECTING DEFAULT USER MAIL ACCOUNT

SQL error ORA-00511: Message 511 not found; product=RDBMS; facility=ORA
occurred while performing the following: Loading profile options (STMT=SELECT
PROFILE_OPTION_NAME, PROFILE_OPTION_VALUE, PROFILE_OPTION_LONG, LONG_FLAG
FROM ALR_PROFILE_OPTIONS ORDER BY PROFILE_OPTION_NAME)

Also can see:
APP-ALR-04140: Oracle Alert was passed an unknown datatype.

Changes

 Upgrade to EBS 12.2.x or 11g database

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