My Oracle Support Banner

Updates to Customer Item Number are not changed in the ORDERED_ITEM column of the OE_ORDER_LINES_ALL table (Doc ID 1147275.1)

Last updated on DECEMBER 09, 2022

Applies to:

Oracle Order Management - Version to [Release 11.5.10]
Oracle Shipping Execution - Version to [Release 11.5.10]
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders


Find when the customer item number is updated after the sales order is created, the change is not reflected in the ORDERED_ITEM column of the OE_ORDER_LINES_ALL table.

Expect the update to be made in the ORDERED_ITEM column of the OE_ORDER_LINES_ALL table. The change is reflected in the application on the sales order form.

The issue can be reproduced at will with the following steps:

1) Create a sales order 123456 with customer item number "A"
2) Go to update the customer item number from "A" to "B"
3) Go back to sales order 123456 and you will see the sales order line show customer item number "B" instead
4) But when we look back to the table "oe_order_lines_all" we can find the value in the "ordered_item" column is equal to "A"


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.