Different Behavior in Creating ECOs in the Engineering Change Orders form ENGFDECN and Through Standard API Eng_Eco_PUB.Process_Eco (Doc ID 1433613.1)

Last updated on APRIL 03, 2016

Applies to:

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

Symptoms

Actual behavior
--------------------
While creating an Engineering Change Order ECO through standard API Eng_Eco_PUB.Process_Eco, trying to change the Revised Component Quantity, when there is already created ECO with the same data(revised item and one Revised component) the system does not throw any error about overlapping effectivity date, like getting in the Engineering Change Orders form ENGFDECN :

Error
-------
"The Effectivity dates you have entered are overlapping with the existing dates for the component &comp_name on the bill for revised item &ITEM_NAME." and allow to save the record.

Expected behavior
-------------------
The behavior in the forms is correct:the ECO has to be unique each time , so the error you got:

Click on Save button, it will through the error "The Effecitivity dates you have entered are overlapping with the existing dates for the component &comp_name on the bill for revised item &ITEM_NAME." by poping up the error window .

and this behavior should be the same, also, if create ECO through API.

Steps to reproduce
--------------------

Creation of ECOs using oracle applications form
--------------------------------------------------------
Nav:- ENGINEERING responsibility-->ECOs-->ECOs

1. Create OPEN status ECO with atleast one revised item and one Revised component with the acd_type as 'ADD' in oracle engineering form.
2. Save it.
3. Create one more OPEN status ECO with the same revised item and same revised component used in the above.
4. Click on Save button, it will through the error "The Effecitivity dates you have entered are overlapping with the existing dates for the component &comp_name on the bill for revised item &ITEM_NAME." by poping up the error window .
5. Click on OK in the ERROR Window.

Creation of ECOs using the ECO standard API Eng_Eco_PUB..Process_Eco
------------------------------------------------------------------------------------
1. Create OPEN status ECO with at least one revised item and one Revised component with the acd_type as 'ADD' by populating the values to the required field of eco header, revised item and revised component table type variables.
2. Execute the script to create ECO. it has successfully created the eco with out giving the error shown in the form.
3. Create one more OPEN status ECO with the same revised item and same revised component used in the above and also add one more revised component which should fail to load.
4. Execute the script to create eco.
5. it has failed to load entire eco as expected but shown two error messages i.e . expected/intended error message for component 2 and the error which shown in the above step4 for component 1.

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