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.
SAP Knowledge Base Article - Preview