My Oracle Support Banner

Price Book Created with Pricing Basis As "Price List" Brings in Data From Other Price Lists Too (Doc ID 2172218.1)

Last updated on AUGUST 17, 2018

Applies to:

Oracle Advanced Pricing - Version 12.2.4 and later
Information in this document applies to any platform.
OEXOEORD - Sales Order Form


On : 12.2.4 version, Price Book

Price Book created for a Price List, brings the Global price list but not the defined one, in some cases.

Running Price Book report for a Operating Unit, Order Fullfillment context, and using a specific Price List, and a Customer (Required Field).
The price book report (excel) and screen brings the information of a different price list in the lines. This is not a expected behavior.

Expect correct price book to only show data from price list assigned to pricing basis.

The issue can be reproduced at will with the following steps:

1) Create 2 price lists: one global, other not global, assigned to the OU that will be used for testing.

2) Create the Price Book
Responsibility: Oracle Pricing User > Advanced Pricing> HOME

Tab: Reports
Select the button: Create new Price Book
OU: Select one
Pricing Perspective: Order Management
Product Criteria: Price List
Price List Name: (OU Price List)

Currency: (Price List Currency)
Customer: (Any customer)
Pricing Basis: Price List
Price List Name: (the same of Product Criteria)

Format: XLS (Excel)

Run the report


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.