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:

Goal

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).

Navigation:

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?

Solution

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