My Oracle Support Banner

How can one pull up a custom pricing attribute for use in a formula? (Doc ID 2377440.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Oracle Advanced Pricing - Version 12.2.5 and later
Information in this document applies to any platform.


This document explains setup consideration when creating a custom pricing attribute for use within a formula.
Especially when one does not find it within the pricing attribute List of Values (LOV).


Note: For this example the Custom Attribute is setup with
         Pricing Transaction Entity(PTE) = Order Fulfillment
         and Context type = pricing Context


1. (N)QP->Setup->Attribute Management->Attribute Linking and Mapping
    Query : PTE: Order Fulfillment Context Type:Pricing Context
2. Goto Code:PRICING ATTRIBUTE and click on Link Contexts(button)
3. Review custom attributes setup and ensure value set assigned is numeric.
    Value Set : QP: Number  (This is a seeded numeric value set).
4. Back To Previous Form
5. Go to Code:PRICING ATTRIBUTE and (B)Link Attributes
6. Review setup and ensure Attribute Mapping Method = ATTRIBUTE MAPPING
7. Click on Attribute Mapping (button)
8. Review sourcing rule for Application Name : Advanced Pricing next to Request Type:ONT
    User Source Type : PL/SQL API
    User Value String : <== Here is where we will normally find custom_package.custom_function
                                       that is being used to source the attribute.
    Also ensure that "enabled" is checked.
9. Responsibility: Oracle Pricing Manager
    Navigate to: Pricing Formula > Formula Setup
    Enter in formula name
    Enter a formula. For example nvl(1,2)
    On the first line / step of the formula enter values as follows:
      Formula Type : Pricing Attribute
      Pricing Attribute Context : Pricing Attribute
    click on Pricing Attribute list of values (LOV)
    One does not find the new custom pricing attribute listed.
    How does one determine what else is needed?




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.