Error using Eng_Eco_PUB.Process_Eco API to Update Revision Via a Change Order
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
Within the Log Error Procedure . . .
Entity Index: 1
Error Level: 3
Error Status: E
Other Status: E
Other Message: ENG_RIT_EXS_SEV_ERROR
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