My Oracle Support Banner

QP Bulk Loader Program Is Allowing Continuous Pricebreak Even If Profile Option Set To NO (Doc ID 2576751.1)

Last updated on AUGUST 28, 2019

Applies to:

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



QP:Bulk Import of Price List program is allowing continuous price break even if profile option QP: Continuous Price Breaks is set to NO
and passing interface table Continuous price break flags as N. We have performed the below steps with ‘CONTINUOUS_PRICE_BREAK_FLAG’ column
value as NULL,Y,N for different set of price list records into interface table(qp_interface_list_lines). But, both profile and any column values does not restrict the non-continuous price records.


For pricing and Adjustments module, we have QP: Continuous Price Breaks profile value as No at site level.
It's not allowing non continuous price break in the application and throwing the error as overlapping price breaks when we trying to create the overlapping price break records manually.

We are expecting the same validation though interface and QP bulk import also. But, It did not happen.


The issue can be reproduced at will with the following steps:
1. Load QP%INTERFACE% tables
2. Run QP: Bulk Import of Price Lists




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.