API ENG_ECO_PUB.PROCESS_ECO Does Not Return if the ECO Is Open in Edit Mode

(Doc ID 2233406.1)

Last updated on FEBRUARY 14, 2017

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.

Symptoms

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.

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