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 MAY 04, 2018

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.

Goal

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:

SELECT decode(fpi.status, 'I', 'Advanced Pricing',
                          'S', 'Basic Pricing',
                          'N', 'Pricing is Not Installed', fpi.status) "Installed Status”
FROM fnd_application_vl fav, fnd_product_installations fpi
WHERE fav.application_id = fpi.application_id
AND fpi.application_id = '661';

 

 

 

 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.