My Oracle Support Banner

How to Fully Install Advanced Pricing and/or Determine if Pricing is Basic Pricing or Advanced Pricing (Doc ID 412663.1)

Last updated on JUNE 21, 2023

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 has 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.
For example, Oracle Purchasing integration with pricing requires Advanced Pricing (full install).

One may run the following SQL script to determine if one has pricing installed and if so whether it is Basic Pricing or Advanced Pricing:






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
 1. Verify That Pricing is Licensed
 Note: If Advanced Pricing is not licensed, see step 1 above, then one may need to  apply the latest OM/SCM patchset.
 * Optional Actions After Application of Patchset
 Apply the latest Recommended Patch(s) (Applicable for Release: 12.1 or higher).
 Apply the latest Cumulative Patch (Applicable to Releases 11.5.10 & 12.0)
 2. Confirm Advanced Pricing is  installed.
 3. How to Convert Advanced Pricing to Basic Pricing (aka Shared Pricing)

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.