My Oracle Support Banner

13563097: Unable To Update Sales Order Line On A Open Order (Doc ID 1408923.1)

Last updated on AUGUST 08, 2018

Applies to:

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

Symptoms



When attempting to update a Sales Order Line with a different Shipment Priority Code, using Order Import, the following error occurs.

Error
There is an UPDATE constraint on all columns - Error
Payment:after OE_Header_Payment_Security.Attributes
Message :You are not allowed to update Order Payment because:
Atleast one order line in the order is invoice interfaced.

Steps
The issue can be reproduced at will with the following steps:
1. There is a booked order in the system.
2. Try to update the shipment method code for an un-shipped line, and also add an additional line to the order, by adding the required data to the oe_headers_iface_table and also the oe_lines_iface_table.
3. Run Order Import, and receive the error.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.