My Oracle Support Banner

R12.1.1 'Ordered Item' LOV Does Not Display New Items (Doc ID 878122.1)

Last updated on JANUARY 29, 2022

Applies to:

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


-- Problem Statement:

After upgrading from 12.0.6 to 12.1.1, after a new item is created in Inventory, you cannot see the new item in the 'Ordered Item' LOV on the sales order line.  You can see items that were created prior to the upgrade.

As a work-around, you can use Actions > Advanced Item Search to find the new item.
But the regular LOV in the form does not work for any new items entered after the upgrade.

Profile: OM: Use Materialized View for Items LOV = Yes

-- Steps To Reproduce:
1.  Create the new item in Inventory
2.  Add to Price List
3.  Enter a new Sales Order
4.  Attempt to place item on sales order line.
     Click the "search" icon, item does not show up in search.


Upgraded from 12.0.6 to 12.1.1


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.