Error using Eng_Eco_PUB.Process_Eco API to Update Revision Via a Change Order

(Doc ID 1549792.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Product Catalog - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, ECO

While trying to use the Eng_Eco_PUB.Process_Eco API to to update change orders in "Open" status, the following error occurs. The change orders are created within the application with the new item revision field set to Null. The API is then called to update the new item revision.

Query Revised Item: ORA-01403: no data found
return_status: E
Within the Log Error Procedure . . .
Scope: C
Entity Index: 1
Error Level: 3
Error Status: E
Other Status: E
Business Object: ECO
Translating and Inserting Messages . . .
Entity Id: RI
Message Count on this point : 1
Finished extracting other message . . .
Other Message generated: This record received an error status since a severe error occured in the revised item XXXXXX while checking if it exists in ECO 9999999.
Error Level = Revised Items . . .
Setting Revised operation records to E

The issue can be reproduced at will with the following steps:
1. Create an ECO via the application with new item revision as Null in Open status.
2. Use the Eng_Eco_PUB.Process_Eco API to to update change orders
3. Get the error


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