My Oracle Support Banner

Ordered Item is Not Available Under "OM: Use Materialized View for Items LOV" Yes (Doc ID 2676226.1)

Last updated on JUNE 17, 2020

Applies to:

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

Symptoms

Problem Statement
When attempting to enter Ordered Item in order line, No Items in the Ordered Item LOV and the following error occurs,
when using "OM: Use Materialized View for Items LOV (Honors Item Orderability Rules)" to "Yes" at site level.

Error
FRM-40212 ORDERED_ITEM_DSP

Steps to Reproduce

  1. "OM: Use Materialized View for Items LOV (Honors Item Orderability Rules)" to "Yes" at site level.
  2. Run the "Refresh Order Management Materialized Views"
  3. Enter Ordered Item in Order Line

Changes

 

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
Changes
Cause
Solution
References


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