- The loadset fails and the following errors appear in the log file:
Caused by: java.sql.SQLException: ORA-20000: ORA-20000: There were no stocking points transferred to MIPO for this scenario. Check the reject log and stg tables.
ORA-00001: unique constraint (.) violated
ORA-06512: at line 1
ORA-06512: at "SOPS_GATEWAY.PACK_LOADER_UTILITY", line 376
ORA-06512: at "SOPS_GATEWAY.PACK_CREATE_TOPOLOGY", line 3002
ORA-00001: unique constraint (SOPS_GATEWAY.ITEM_ATTRIBUTE_PK) violated
- The following two messages appear in the ERROR_LOG table in the REJECT_REASON column or in the Data Loading Errors published report:
Processing stg_item_attribute into item_attribute table ORA-00001: unique constraint (SOPS_GATEWAY.ITEM_ATTRIBUTE_PK) violated.
Calling process_item_attribute_data ORA-00001: unique constraint (.) violated
This can effect versions 6.10 and older of SAP Enterprise Inventory and Service Level Optimization (older versions also referred to as EIO or SmartOps).
Loadset Failure , KBA , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , SCM-EIS-OPS , SAP EIS - Operations , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.