Unable To Update Sales Order Lines Using Process Order API (Doc ID 2007250.1)

Last updated on OCTOBER 15, 2016

Applies to:

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

Symptoms

When trying to update the Sales Order lines which is shipped and awaiting invoice interface through Process Order API, it returns an error:

"The update request cannot be executed now because the source lines have at least one delivery line that is in a confirmed delivery or has been shipped."

On further analysis, found "EARLIEST_SHIP_DATE" is populated as '01-Jan-4712' on the lines.
This is an upgraded order from 11i which is populated with this date.
When trying to update any fields/DFF attributes through Sales Order form, this blanks out the "EARLIEST_SHIP_DATE" and we are able to successfully update the line using Process Order API.

 

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