Solution : https://service.sap.com/sap/support/notes/352049 (SAP Service marketplace login required)
Summary :
When executing the automatic payment program SAPSQL_ARRAY_INSERT_DUPREC error occurs, affecting postings within SAP-IS-PS. This error surfaces while creating posting orders, and similarly, during reversal and clearing transactions in FI involving G/L accounts with open item management. Key associated transactions include FB08, FB1S, and FBRA. Root cause is traced to data inconsistencies in FI tables BSIS or BSAS, prompted by IS-PS integration. Implementing program corrections as prescribed, alongside running correction report RFINDEX, will address these issues. Consult SAP for detailed implementation guidance.
Key words :
additional key words sapsql_array_insert_duprec, runtime error sapsql_array_insert_duprec occurs, system generates posting orders, termination sapsql_array_insert_duprec occurs, reset cleared items, open item management, data inconsistencies result, correction report rfindex, automatic payment program, payment program proper
Related Notes :
| 427546 | Important notes for FI-FM and PSM-FM |
| 195515 | Installing ZFINDEX |