API ENG_ECO_PUB.PROCESS_ECO Does Not Return if the ECO Is Open in Edit Mode
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.
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.
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
- Query an ECO in the Engineering Change Orders form (ENGFDECN)
- Change the description but do not save the change
- Run the ENG_ECO_PUB.PROCESS_ECO API from a SQL*Plus session
- The API will not complete until the Engineering Change Order form is closed
Note the API completes successfully after the form is closed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms