Symptom
In the inbound of the APO system (transaction SMQ2), there is a queue with the error "Open SQL array insert produces duplicate records in the database".
In the transaction ST22, the dump below is displayed:
Category ABAP programming error
Runtime Errors DBSQL_DUPLICATE_KEY_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program /SAPAPO/SAPLATP_UPDATE
Application Component SCM-APO-ATP-EST
...
>> INSERT /sapapo/sd_doc FROM TABLE lt_sddoc_db_ins.
Read more...
Environment
- Availability Check
- Global ATP
- Supply Chain Management
Product
SAP Advanced Planning and Optimization all versions ; SAP ERP all versions ; SAP S/4HANA all versions ; SAP Supply Chain Management all versions
Keywords
/SAPAPO/DM_ATP_UPDATE_FIELDLST, /SAPAPO/LATP_UPDATEU01, lt_atpfields, ls_doc, ls_sddoc_db, lt_sddoc_db_del[], /SAPAPO/LOC040, /SAPAPO/CIF_SL_DOC_INBOUND, /SAPAPO/SAPLDM_ATPTUBE , KBA , SCM-APO-ATP-EST , Explanation & Simulation , SCM-APO-ATP , Global Available-to-Promise , SCM-APO-INT-SLS , Sales , 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.