0 Replies Latest reply on Nov 18, 2019 1:48 AM by Benny Gong-Oracle

    Oracle error -20160: ORA-20160: Oracle error -4091 in SUBMIT: others when create an alert on fnd_logins

    Benny Gong-Oracle

      got Oracle error -20160: ORA-20160: Oracle error -4091 in SUBMIT: others issue after created an alert on fnd_logins

       

      ora-04091 error was not exist when modified the alert as below

       

       

      pragma autonomous_transaction

      commit;

       

      but the Check Event Alert ( ALECTC ) request was not submitted.

       

       

      1.Is it avaiable to change the alert to autonomous_transaction trigger?How to fix the ora-04091 error is not?

      2.How to trace this kind of issue?

       

      By the way,I have reviewed all the defination of the alert and all are fine.