Why API Eng_Eco_PUB.Process_Eco Allows Leaves Trailing Spaces When ECO Is Created?

(Doc ID 2146217.1)

Last updated on NOVEMBER 30, 2016

Applies to:

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

Symptoms

The application programmatic interface (API) to create change orders ( Eng_Eco_PUB.Process_Eco ) allows trailing spaces on the change description but the space results in errors when using the change order.
* This is a root-cause fix request to ensure the API does not leave trailing spaces.

-- Error --
FRM-40654: Record has been updated. Requery block to see change.

Expected Behavior
Expect the API to strip trailing spaces like the form does. In its current state, the change order results in errors when queried or manipulated.

Steps
1. Call change order API.
2. Query change order.
3. Attempt to cancel.
4. Receive error.

Business Impact
Causes problems when querying back the change order on the form. Receive errors attempting to make changes.
Minor impact as can remove spaces before API call.
If miss removing spaces, it causes data corruption and the change order cannot be manipulated on the form due to error about requery.

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