My Oracle Support Banner

API ENG_ECO_PUB.PROCESS_ECO Does Not Return if the ECO Is Open in Edit Mode (Doc ID 2233406.1)

Last updated on MAY 12, 2020

Applies to:

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


Actual Behavior
If the Engineering Change Orders form (ENGFDECN) is open with pending unsaved changes, then calls using the ENG_ECO_PUB.PROCESS_ECO API will wait and not complete until the Engineering Change Orders form is closed.
Once the form is closed, the API completes successfully.

Expected Behavior
The api should return with a message that the ECO is locked by another user/session instead of awaiting the form to be closed.

Steps to Reproduce

  1. Query an ECO in the Engineering Change Orders form (ENGFDECN)
  2. Change the description but do not save the change
  3. Run the ENG_ECO_PUB.PROCESS_ECO API from a SQL*Plus session
  4. The API will not complete until the Engineering Change Order form is closed
    Note the API completes successfully after the form is closed.


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

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