My Oracle Support Banner

Price Security At Operating Unit (OU) Allows Other OU To View And Update Price Lists (Doc ID 798908.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Advanced Pricing - Version 12.0.6 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
FORM:QPXPRDPL.FMB - Define Price Lists



On 12.0.6 in Production:

Pricing security are setting as follows:

QP: Security Control ON
Site QP: Security Default Maintain Privilege OU
Site QP: Security Default View Only Privilege OU

Best way to explain issue is via example:
Using Oracle Pricing Manager (LA_OU):
When go to create price list, uncheck Global.
Operating Unit = LA_OU.
Create the the price list.

Now give Maintain privileges on this price list to operating unit = US_OU.

Using Oracle Pricing Manager (US_OU), when you try to add a price list
line you receive:

ORA-01403: no data found in Package
QP_Validate_Price_List_Line Procedure Entity

EXPECTATION: As US_OU had MAINTAIN privileges, they should be able to add a price list line to the 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.