How To Verify if the Big Search for Price Lists is Enabled or Disabled (Doc ID 464624.1)

Last updated on AUGUST 23, 2016

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
FORM:QPXEVPHS.FMB - Event Phases

Goal

How to verify that the requested setup changes were in place when a new
testcase is performed when Big Select/Big Search is disabled for the price list.

The Big Search, or also known as the Big Select, is a method to instruct the
pricing engine whether or not to search for another price list other than the one entered
on the sales order line to retrieve the price for the item on the sales order line.

If it is disabled, only the price list on the sales order line will be used to acquire the price.  If the item is not present on this price list
nor ALL_ITEMS is present on this price list nor present on any secondary price lists assigned under this price list,
then an error message is returned (ITEM xxx and UOM xxx are not found on PriceList xxx).

If it is enabled and the item on the sales order line is not present on the price list assigned to the sales order line nor ALL_ITEMS is present on this price list
nor present on any secondary price lists assigned under this price list, then the pricing engine will do a big search for all price lists where this item is present
or ALL_ITEMS is present to retrieve the price.  Only if no other price list with this item (nor ALL_ITEMS) is available only
then will the error be shown (ITEM xxx and UOM xxx are not found on PriceList xxx).  If multiple price lists are returned for this item, no matter what the setup shows, price lists always use precedence to determine which price list to return. If two or more price lists for this item with the same precedence are found, this will also result in an error "(Duplicate Price List Lines ( i.e. equal precedence)" since the pricing engine cannot determine which one to use.

 


How to determine if the Big Select is Enabled:
Responsibility: Oracle Pricing Manager
Navigate to: Setup > Event Phases
Query event phase "List Line Base Price" having a sequence zero. 
The user search flag was set to "Yes" for the pricing events 'batch processing' and/or 'fetch price'.


How to Determine if the Big Select is Disabled:
Responsibility: Oracle Pricing Manager
Navigate to: Setup > Event Phases
Query event phase "List Line Base Price" having a sequence zero.
Set the user search flag to "No" for the pricing events 'batch processing' and/or 'fetch price'.





Solution

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