How can one pull up a custom pricing attribute for use in a formula?
(Doc ID 2377440.1)
Last updated on MARCH 22, 2018
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!