My Oracle Support Banner

How Splitting a Line Which Uses Block Pricing Shows An Incorrect Price (Doc ID 1507149.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.


If we are using Block pricing for 0-250 Quantity = 0$,
then 251 -99999 as 2$, then while creating order for a quantity of 300,
the list price and unit selling price(USP) is showing as .333 and calculating total as 100$.

But Business requirement is it should create two lines for the same item.
Business requirement is if order will be booked for 300 Quantities,
then 1st for same item should be of Quantity 250 with 0$ for the list price and USP,
then 2nd line with same Quantity with Quantity as 50 with list price  and USP as 2$ each,
making total as 100$.

If one manually splits the line which is for quantity of 300 with unit selling price = .333
using Actions > Split line for quantities 250 and 50, then the unit price is not as expected.
Line with quantity 250 has list price = 0$.
Line with quantity 50 has list price = 0$
Expected behavior:
Since I am splitting one order line, the list price and unit selling price(USP) of the original
should be maintained in all the split lines.

A valid scenario could be that the lines had to be split because they needed
to be sourced from different warehouses, but the customer is buying that
quantity for the block price. But in the present behavior he would be paying
twice the block price for no reason of his.

How can this be accomplished?



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.