SAP Knowledge Base Article - Preview

1846534 - Runtime error SAPSQL_ARRAY_INSERT_DUPREC at the settlement run

Symptom

The settlement run or settlement reverse run is aborted with the runtime error SAPSQL_ARRAY_INSERT_DUPREC or DBSQL_DUPLICATE_KEY_ERROR.

Dump.JPG

From the dump information, it shows that the termination has happened at the INSERT AUAA FROM TABLE AA of the function module K_SETTLEMENT_DOCUMENT_INSERT.

dump2.JPG

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • Controlling (CO)
  • SAP R/3
  • SAP R/3 Enterprise 4.7
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA
  • SAP S/4HANA Finance

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

Abrechnung, KO88, CJ88, CO88, KO8G, CJ8G, SAPLKO, settlement, SAPSQL_ARRAY_INSERT_DUPREC, AUAA dbsql_duplicate_key_error , KBA , CO-OM-OPA-F , Period-end Closing , PS-COS-PER-SE , Settlement , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.