Periodic Oracle Alerts Fail With APP-ALR-04057 (Doc ID 1053352.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Alert - Version 12.0 to 12.1 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms



On R12
Periodic Oracle Alerts are failing with the following errors:

APP-ALR-04102: Internal SQL error occurred.
APP-ALR-04057: Oracle Alert was unable to purge history in file &FILE in routine &ROUTINE on line &LINE.
Check that all of the Oracle Alert history tables exist.

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