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 OCTOBER 04, 2021

Applies to:

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

Symptoms

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.

EXPECTED BEHAVIOR
-----------------------
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.

STEPS
-----------------------
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"

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


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