QPXEVPHS: OEOIMP: Importing Sales Orders Are Not Booked Because Items Are On Two Price Lists (Doc ID 465768.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Advanced Pricing - Version: 11.5.10 to 12.0.6 - Release: 11.5 to 12.0
Information in this document applies to any platform.
ConcurrentProgram:OEOIMP - Order Import
FORM:OEXOEORD.FMB - Sales Orders
Checked for relevance on 01-OCT-2010
Checked for relevance on 04-APR-2012

Symptoms

-- Problem Statement:
On 11.5.10 in Production:
Trying to import orders in a booked status. One has added the same item to
multiple price lists and these items have the same precedence. A defaulting rule
is in place that by organization defaults the price list to the sales order line from the sales order header. This defaulting rule evaluates the order source and applies the header’s price list value to the line’s price list field.

Receives error message thru Order Import that the item is on 2 different price lists
with the same precedence. The price list on the order line is not populated.

We disabled the big search for both fetch list price and batch processing. (user search flag = NO) and saved.
Retested with brand new order.
Price List defaulted fine.
However, error message (duplicate price list lines) is still shown.


ERROR
Duplicate Price List Lines ( i.e. equal precedence): STRYKER CUSTOMS, STRYKER MRC

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Run order import to bring in EDI order source.
2. Responsibility: OM Super User
3. Navigate to: Orders, Returns > Order Organizer
4. Query order created
Order did not book
Error above is shown.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot import sales orders using defaulting rules to populate the price list.
This is needed to advise the pricing engine the only price list to use; else to error if the item is not on this price list.  Does not want the pricing engine to search for other price list should the item not be present on this price list.

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