API PROCESS_ECO Returns X_RETURN_STATUS S Even If A Sub Structure Returns E (Doc ID 2043871.1)

Last updated on AUGUST 13, 2015

Applies to:

Oracle Engineering - Version 12.1.1 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

If the API (Applications Program Interface) call ENG_ECO_PUP.PROCESS_ECO is used with in invalid TRANSACTION_TYPE (e. g. "INVALID" instead of CREATE, UPDATE or DELETE) for a revised item component, the overall X_RETURN_STATUS is returned as "S" (=success), even though the sub structure for the component contains an "E" and the correct error message:
<>

See the following output after Calling Eng_Eco_PUB.Process_Eco API with below note:

Calling Eng_Eco_PUB.Process_Eco API
x_eco_rec.eco_name:150811_010
x_eco_rec.org_code:V1
=======================================================
Return Status: S
Return Status 1:E
=======================================================

PL/SQL procedure successfully completed.

SQL>
Commit complete.


#################################################################################################################################################
Note:
This output shows that the overall "return status" returns with S while the underlying return status for the revised item component returns an E.

#################################################################################################################################################


EXPECTED BEHAVIOR
-----------------------
The overall X_RETURN_STATUS should be returned as an "E" as well.

How to Fix this discrepancy issue?
 

Solution

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