ALERT7777

     DB table /SCMB/ALERT7777 stores core data of alerts of type 7777 (Alert Notes Management). This alert gets created or modified when triggering inventory alerts for Delivery Control Monitor and Replenishment Planning.

     Possible places for generating alerts of type 7777 are PPF actions. In these logics all alert-relevant modifications are executed in update tasks. Besides this, there may be mass alert triggering and modification in these processes, so the likelyhood of deadlocks is very high.

To avoid the deadlock, my recommendations are as follows:

1., In Tx SPPFCADM,

application: /SCA/ICH

profile: /SCA/BOL_INVENTORY

deactivate PPF actions /SCA/BOL_INV_DCM_STOCK_CHECK and /SCA/BOL_INV_PROJSTOCK_CHECK

2., To generate inventory alerts, run reports /SCA/DCMALERTSWRITE and

/SCA/INVALERTSWRITE manually and regularly.