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