Last updated on JULY 07, 2017
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
***Checked for relevance on 5-JUN-2015***
Checked for relevance on 08-JAN-2014
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms