Kas
13
2017

Oracle ERP Alert Nasıl Silinir?

Merhaba,

ERP içerisinde ki tanımlı alert’ler ancak etkinlik sonu verilerek disable hale getirilebiliyor. Paylaşmış olduğum script’i kullanarak sistemde tanımlı olan alert’u silebilirsiniz.

 

 

DECLARE
   CURSOR ALR
   IS
      SELECT ALERT_ID, APPLICATION_ID
        FROM ALR_ALERTS
       WHERE ALERT_ID = 107046;
BEGIN
   FOR REC IN ALR
   LOOP
      DELETE FROM ALR_ACTION_SETS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ACTIONS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ALERT_INPUTS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ACTION_SET_INPUTS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ALERT_OUTPUTS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ACTION_SET_OUTPUTS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_PERIODIC_SET_MEMBERS
            WHERE     CHILD_APPLICATION_ID = REC.APPLICATION_ID
                  AND CHILD_ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_RESPONSE_SETS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_RESPONSE_VARIABLES
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_VALID_RESPONSES
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_RESPONSE_ACTIONS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_RESPONSE_VARIABLE_VALUES
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ACTUAL_RESPONSES
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ALERT_INSTALLATIONS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ALERTS WHERE ALERT_ID = REC.ALERT_ID;                  
 
      COMMIT;
   END LOOP;
END;
Kaan Sertaç Bozatlı

Kaan Sertaç Bozatlı

1993 İstanbul doğumlu. İstanbul Aydın Üniversitesi Bilgisayar
Programcılığı bölümünde önlisans yaptı. Blog yöneticisi ve aynı
zamanda yazardır. Yaklaşık olarak 6 senedir profesyonel kariyerine
Oracle e-Business Suite Uygulama Geliştirme Teknik Danışmanı olarak
devam etmektedir. Sırasıyla Tetaş Tekstil İç ve Dış Ticaret A.Ş.,
Experteam Consulting, KKB Kredi Kayıt Bürosu(Devam) şirketlerinde
çalışmıştır.
Mail: kbozatli@gmail.com
Kaan Sertaç Bozatlı

Latest posts by Kaan Sertaç Bozatlı (see all)

İlgili Yazılar



Yorum yapın

*