Advanced Pricing - Attribute Management

I have got a requirement which forced me to learn about the Attribute management in Oracle Advanced Pricing.

There is Qualifier context for Item Name and Item Category. Our issue was, we had two different set of items in the same category and the intention is to apply the modifier to one set of items and not to the other.

But the good thing is the naming convention differenciates the item types. i.e one set of item has '_L' in its name.

For example PR and PR_L. PR belongs to one set and PR_L belongs to the other.
For any attribute mapping, you should be sure under which context you have create the new attribute, and obviously in this case it has to be Qualifier Attribute.

So Create a new Qualifier Context,
Oracle Advanced Pricing --> Set Up --> Attribute Management --> Context and Attributes.


Context :
Type : Qualifier Context
Code : User Defined Value
Attribute :
Code : Qualifier Attribute Code
Name : Qualifier Attribute Name
Column Mapped : Select the available Attribute Column.
Valueset : If you want the user to restrict the values to be entered.

Now the Attribute is ready and now comes the attribute Mapping.
Oracle Advanced Pricing --> Set Up --> Attribute Management --> Attribute Linking and Mapping.
Pricing Transaction Entity : Order Fulfillment
Context Type : Qualifier Context
Select the context that you have created in the above steps --> Link Attributes.
Select the Level ( Line or Header or Both), The attribute Mapping method is : Attribute Mapping.

Once you have selected the Attribute Mapping, the Attribute Mapping button is enabled.Click on it.

Select your Application name and request type.
I am concentration on OM, as my pricing call will be made from there.
Select the User Source Type as PL/SQL API and User Value string as the call to your custom package.

In my case, XXX_RETRIEVE_ITEM.GET_BASE_ITEM(OE_ORDER_PUB.G_LINE.ordered_item)
Peseudo Code for XXX_RETRIEVE_ITEM.GET_BASE_ITEM(OE_ORDER_PUB.G_LINE.ordered_item)
If (OE_ORDER_PUB.G_LINE.ordered_item has '_L' in its name )
RETURN 'FALSE'
ELSE
RETURN 'TRUE'

The very mandatory and important step after all this is, running the Build Attribute Mapping concurrent program.

So all my new Qualifier is ready to use now.

To make sure that the modifier is getting applied only to the non '_L' item, I have to define qualifier like this