My Oracle Support Banner

On Alerts Form, Receiving Error APP-ALR-04104: SQL Error ORA-01400: Cannot Insert Null Into (alr.alr_alert_inputs.name) (Doc ID 2962019.1)

Last updated on SEPTEMBER 29, 2023

Applies to:

Oracle Alert - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When updating or creating an Oracle Alert, receive the error:

APP-ALR-04104: SQL error ORA-01400: cannot insert NULL into ("ALR"."ALR_ALERT_INPUTS"."NAME") occurred while performing he following: Inserting new alert inputs (STMT=INSERT into alr_alert_inputs(application_id, alert_id, name, last_update_date, last_updated_by, creation_date, created_by, start_date_active, enabled_flag, title, data_type) VALUES (:0,:1,:2,sysdate,:3,sysdate,'Y',"5,'C'))


STEPS
-----------------------

Using Alert Manager responsibility
Navigate - Alert / define [ALRALERT.fmb]
Query Alert name



Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.