3) APP-ALR-04108: SQL error ORA-01455: Converting column overflows integer datatype occurred while executing the user-defined SQL statement for this alert (STMT=select 12345678901 from dual)

APP-ALR-04108: SQL error ORA-01455: Converting column overflows integer datatype occurred while executing the user-defined SQL statement for this alert (STMT=select  12345678901 from dual)

 

Solution:  In Alert define window in select statement box it will accept only 10 digits columns to retrieve. So here I am retrieving 11 digits so when click on run this error occurred.

Action:  always display columns which are less than 11digits values.

Or If you want to display huge amounts then you should use to_char(amount)

so it will convert into character then it will allow more than 11 digits.