SAP Note 12663 - Deadlock on table RFBLG during the payment run

Symptom:

Program : SAPLF005
During the payment run, an update termination occurs with ORA60 or SQL0913 (DB2/400) during SELECT FOR UPDATE on logical table BSEG (cluster RFBLG).

Cause and prerequisites

One document contains items for different vendors. The payment run is processed in parallel by several update processes. As a result, entire cluster records are locked. This may lead to a deadlock. This deadlock is logged in the syslog (SM21).

Solution

1. Organize your accounting in such a way that one document only contains items for one vendor. Another advantage is that the cluster records are reduced and can be read faster (performance improvements).

2. Alternative solution:
Change your system configuration before starting the update run and only use one update process. Because of the resulting loss in performance, this is only a temporary solution.

Additional key words

ORA060, ORA0060, ORA00060 F110 SAPF110 AS/400

Key word: ora60, SQL0913