My Oracle Support Banner

Basic Filter on Line Item Grid Not Working as Expected (Doc ID 2537834.1)

Last updated on DECEMBER 14, 2019

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 18 D and later
Information in this document applies to any platform.


When an attribute is mapped as "ReadOnly Catalog" on the Line Item Grid in Jet UI, the basic keyword search is not working nor the advanced filter using an "OR" condition.

The following steps can be taken to reproduce this behavior:

  1. Login to an environment
  2. Go to Jet Responsive layout - Line Item Grid
  3. Map "Product" to "Model Name" and use the mapping Type as "ReadOnly Catalog"
  4. Save and Deploy Commerce
  5. Open a quote that has more than two line items and search for something or use the advanced search with "OR" condition (check Match Any)
  6. Observe that the search does not working/the advanced search is not returning the expected result
  7. Go back in LIG and change Mapping Type to "Normal"
  8. Go to quote and observe that the search is working fine


To view full details, 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 a vibrant support community of peers and Oracle experts.