How to Fully Install Advanced Pricing and/or Determine if Pricing is Basic Pricing or Advanced Pricing

(Doc ID 412663.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.


This document will advise how to fully install Advanced Pricing.
Advanced Pricing is a separate product and a license needs to be bought
for the product before making any changes. The details below for installing
Oracle Advanced Pricing assumes that Oracle Applications, including
Oracle Order Management, have been successfully installed, and that Oracle
Advanced Pricing has been installed as Shared.

Users of basic pricing are installed as "shared" and are not licensed to use Oracle Advanced Pricing capabilities. Users who have licensed Oracle Advanced Pricing are installed as "Full." The pricing system software components examine the installation type (either full or shared) to determine the appropriate mode in which to run.

Run the following SQL script to determine if one has Basic Pricing or Advanced Pricing:

SELECT qp_util.get_qp_status FROM dual;

If the result are:
  I - This means that Advanced Pricing is fully installed and features are now available. 
 S - This means that Advanced Pricing is shared.
        Only Basic Pricing features are available. 
 N - This means that Advanced Pricing is not installed.





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 hundreds of Community platforms