API Eng_Eco_Pub.Process_Eco to Update ECO is Failing with Error "You cannot update or delete revised item..."

(Doc ID 1639569.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle Engineering - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

As part of one of the requirements, you need to update MRP_Active flag for ECOs based on certain conditions. As part of POC, tried to execute a sample script with API "eng_eco_pub.process_eco" for a sample ECO and item associated to it. But API is running into error with below mentioned error message.

ERROR

You cannot update or delete revised item 12345 since it does not exist on ECO XYZ-001. An error occured while processing business object XYZ-001 in organization M1. Please check the data in this business object and re-run the import process.


STEPS

The issue can be reproduced at will with the following steps:

  1. Created a script that call API "eng_eco_pub.process_eco" in order to update MRP_Active flag for ECOs based on certain conditions
  2. API is going in error

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms