2630320 - EIS MIPO pruning failure with NEW_SKU_MAP foreign key error | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2630320 - EIS MIPO pruning failure with NEW_SKU_MAP foreign key error

Symptom

User is running the mipo_pruning.sql script within SAP Enterprise Inventory and Service-Level Optimization (EIS) and it is failing with the following error found within the mipo_pruning.log.

A foreign key error was raised when restoring data into NEW_SKU_MAP
The FK related delete from  input_tab was successful
Retrying the insert back into table NEW_SKU_MAP from input_tab
DECLARE
*
ERROR at line 1:
ORA-02291: integrity constraint (SOPS_MIPO.NEW_SKU_MAP_FK3) violated - parent

key not found
ORA-06512: at "SOPS_MIPO.PACK_SCENARIO_PRUNE", line 440
ORA-02291: integrity constraint (SOPS_MIPO.NEW_SKU_MAP_FK3) violated - parent
key not found
ORA-06512: at "SOPS_MIPO.PACK_SCENARIO_PRUNE", line 953
ORA-06512: at line 74


Read more...

Environment

SAP Enterprise Inventory and Service-Level Optimization (EIS)

Product

SAP Enterprise Inventory and Service-Level Optimization all versions

Keywords

SmartOps, EIS, EIO, MIPO, PACK_SCENARIO_PRUNE, NEW_SKU_MAP, ORA-02291, ORA-06512, key, parent, foreign, prune, global , KBA , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , SCM-EIS-OPS , SAP EIS - Operations , Problem

About this page

This 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.