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