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

Component : DB Independent Database Interface -

Solution : https://service.sap.com/sap/support/notes/12663 (SAP Service marketplace login required)

Summary :
During the payment run in SAP program SAPLF005, an update termination may occur with ORA60 or SQL0913 (DB2/400) during a SELECT FOR UPDATE on the logical table BSEG (cluster RFBLG). This happens because one document contains items for different vendors, causing parallel processes to lock entire cluster records and potentially leading to a deadlock, which is logged in the syslog (SM21). Recommendations include organizing documents to contain items for one vendor to reduce cluster records and improve performance, or temporarily using a single update process at the cost of performance.

Key words :
additional key words ora060, symptom key word, logical table bseg, ora00060 f110 sapf110, update termination occurs, entire cluster records, cluster records, cluster rfblg, update processes, update run

Related Notes :

145647F110: Performance and deadlocks in payment program