My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2019

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


-- 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.

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.


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.