Use Your Own Attributes in Pricing

Add your own attribute to an item, then reference it in a pricing rule that determines the price or discount.

An item attribute describes some aspect of item. For example, assume you have been selling an item named My Favorite Shirt for five years, one of your best sellers. My Favorite Shirt already exists in the Oracle database, and it includes attributes Size, Color, and Texture. Size is an example of an item attribute.

Through market research, you learn your customers would love a shirt that allows more or less airflow through the fabric according to the ambient air temperature. So you develop a fabric that increases permeability when the air is above 50 degrees, and decreases permeability when the air is below 50 degrees. You need a new item attribute. You can create an item extensible attribute named Permeability to meet this need.

Oracle Applications uses the term extensible to describe a capability that enables you to modify Oracle Applications in a way that meets your specific requirement. An item extensible attribute is an attribute that you define to store details about an item when the details are unique to your business requirement.

You might need to calculate or adjust price according to the attributes of the item, but it might be too cumbersome to set up these calculations for each item. For example, to discount price according to product color or size, or to modify the base price according to the material, such as silver, copper, gold, diamond, Californium, and so on.

Use the Setup and Maintenance work area to define an item extensible attribute, then use a matrix class that references details about the item instead of defining the attribute for each item.

• Use the Price Sales Transaction pricing algorithm to add this logic.

• Set up and run a pricing rule on a price list or discount list according to the item attributes in a pricing matrix.

• Use an item extensible attribute in the condition column of a matrix class.

  • Use the Price List Charge Adjustment matrix class for a price list.

  • Use the Pricing Term Adjustment matrix class for a discount list.