Why API Eng_Eco_PUB.Process_Eco Allows Leaves Trailing Spaces When ECO Is Created?
Last updated on NOVEMBER 30, 2016
Applies to:Oracle Engineering - Version 12.2.4 and later
Information in this document applies to any platform.
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.
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.
1. Call change order API.
2. Query change order.
3. Attempt to cancel.
4. Receive error.
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.
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