My Oracle Support Banner

Error using Eng_Eco_PUB.Process_Eco API to Update Revision Via a Change Order (Doc ID 1549792.1)

Last updated on MARCH 04, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, ECO

ACTUAL BEHAVIOR
---------------
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.


ERROR
---------------
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
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

STEPS
-----------------------
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


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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