ECO Stuck in "In Progress" Status and Fails to Implement with Error: Failure in enimpri_implement_revised_item (eco_failed) (Doc ID 1491252.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

An Engineering Change Order (ECO) gets stuck in "In Progress" status and fails to Implement

Facts:

1) Checked that each and all the components (including the components items in the BOM's being updated win the ECO) are not engineering items. The items being implemented must be Manufacturing items or else the failure to implement is normal

Please refer to steps in:

ECO Fails to Implement With Error: Failure in enimpri_implement_revised_item (eco_failed) processing itemRevisionEntry (Doc ID 388297.1)

Note: You can check by running a query such as

select ITEM_ID, INVENTORY_ITEM_ID, ITEM_NUMBER ITEM  , ORGANIZATION_ID,  ENABLED_FLAG, INVENTORY_ITEM_FLAG, ENG_ITEM_FLAG    
from MTL_ITEM_FLEXFIELDS where ENG_ITEM_FLAG = 'Y';

and then verify against the BOMs in the ECO with the issue

2) The log of the concurrent program ENCACNC module: Engineering Change Order Implementation shows error as shown below:

===================================================================
EDR_ERES_ENABLED = N
total_items=3
item_loop=3, l_change_id=46072, organization_id=84
Failure in enimpri_implement_revised_item (eco_failed)
processing itemRevisionEntry
Rollback (revised_item_failed)processing itemRevisionEntry
Rollback (revised_item_failed)processing itemRevisionEntry
Rollback  ...
Generating Implementation failure Action Log  ...

3) The corresponding output of the Engineering Change Order Implementation program that ran shows something similar to what is shown below:

XXX Inventory Organization                                                                Report Date: 22-AUG-12 13:18:01
                                             Engineering Change Order Implementation                       Page:                  1

ORG ECO        REVISED ITEM                        ALTERNATE  MESSAGE
--- ---------- ----------------------------------- ---------- --------------------------------------------------------------------------------

XYZ EC0123    ITEM_ABC                       Implementation failed: Unable to add or change component COMPONENT_123

Cause:        Implementation attempted to add Component, COMPONENT_123, to operation &OP_SEQ_NUM, which already exists on the Bill of Material.  

Action:        Cancel this portion of the engineering

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.