Ordered Item Change Is Reversed When Saving SO Line With Materialized View For Items LOV =Yes (Doc ID 2010285.1)

Last updated on JANUARY 11, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Entry

ACTUAL BEHAVIOR
---------------
Find that when profile option OM:Use Materialized View For Items LOV is set to 'YES', user is unable
to change ordered item on sales order line .

Issue happens when OM: Use Materialized View for Items LOV (Honors Item Orderability Rules) = Yes
User enters a sales order line for an Ordered item A and saves (same issue happens if line is not
saved yet). It is in Entered status. Later user realizes the Ordered item is wrong and replaces it with
another Ordered item B. Line is Saved. but the ordered item is reverted back to item A after saving.

EXPECTED BEHAVIOR
-----------------------
Expect the ordered item should be changed before Booking.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Set the profile option OM:Use Materialized View For Items LOV set to YES
2. Order management super user
3. Enter order header and lines information
4. Enter item A on Line and Save .
5. User realizes a mistake on item and wants to change it…
6.User Overwrites Item number from A to another value e.g. B and Tabs out
7.Ordered item is displayed as B and upon saving the ordered items reverts back to original item A

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