How to Add User-Defined Attributes to Items

You can create user-defined attributes that can be used in the program product rules to determine the price or discount. You must set it up as an item extensible attributes in an item class to represent details about the item.

Create an Attribute Group and Attributes

With roles allowing access, in the Setup and Maintenance work area, go to:
- Offering: Product Management
- Functional Area: Items
- Task: Manage Item Attribute Groups and Attributes
In the Manage Attribute Groups page, from the Actions drop-down button, click Create to create an attribute group.

In the Create Attribute Group page, enter the details for the following fields:

Field	Description
Display Name	Enter a display name for the attribute group. For example, Item Color.
Internal Name	Enter an internal reference name. For example, Item Color Specification.
API Name	Automatically populated, edit if required.
Behavior	Select Single Row from the list.

On the Context Usages tab, select Create from the Actions drop-down list.
Select Item from the Name list as the context usage. Click Save. This creates the attributes group with context usage as Item.
In the Edit Attributes page, in the Attributes section, click Create from the Actions drop-down button.

In the Create Attribute page, enter the details for the following required fields:

Field	Description
Display Name	Enter a display name for the attribute. For example, Color.
Internal Name	Enter an internal reference name. For example, Product Color.
API Name	Automatically populated, edit if required.
Data Type	Select the data type of the attribute. For example, for color select Character.
Table Column	Automatically populated, edit if required.

Select a Value Set from the list, or create one by clicking Create Value Set.

If you're creating a value set, in the Create Value Set page, enter the details for the following fields:
1. Enter a code for your value set. For example, PRODUCT_COLOR.
2. Enter a description to for the value set. For example, Value set for product colors.
3. Select Product Model from the Module list.
4. Select a Validation Type. You must select Independent or Format Only for each item extensible attribute that you plan to use with Pricing.
5. Select the data type of your value set from the Value Data Type list. You must select either Number or Character for the data type. Other data types aren't supported.
6. In the Definition section, enter the required details and save.
7. Click Manage Values to add the values for the value set.
8. In the Manage Values page, Click Create from the Actions drop-down button.
9. Add the values you want for your value set. For example, different product colors like blue, red, and so on.
10. Click Save and Close to navigate back to the Create Attributes page.
In the Create Attributes page, the Display Properties are now populated. You can edit this if required.
1. Prompt: The prompt for your attribute. For example, Color.
2. Display Type: How the values should be displayed. For example, List of Values.
Click Save and Close. The attribute for the attribute group is saved, and you're now on the Edit Attribute Group page. You can create more attributes for this group if required. Note down the flexfield code and save.

Add the Attribute Group to an Item Class

With roles allowing access, in the Setup and Maintenance work area, go to:
- Offering: Product Management
- Functional Area: Items
- Task: Manage Item Classes
In the Manage Item Classes page, select the Item Class under which you want to add the attribute group and its attributes as extensible attributes. You can select the Root Item Class to add the attribute group to all the item classes.
In the Edit Item Class page, click Pages and Attribute Groups tab. On the Attribute Groups subtab, from the Actions drop-down button, click Select and Add.
Select your attribute group and click Apply, then click OK. Click Save to save the updates to the item class.
Navigate to the Pages subtab. Select Pricing Item Attributes. If it's not available, add it. See the Add Your Attribute Group to An Item Class section in the Add Your Own Attributes to Items in Pricing topic from the Pricing Administration guide.
In the Attributes Group: Pricing Item Attributes section, click Select and Add from the Actions drop-down button. Select your attribute group. Click Apply, then OK. Click Save to save the updates to the item class.
Navigate to the Functional Item Pages subtab and ensure that the following is available:
- Functional Area: Pricing
- Usage: Pricing
- Item page: Pricing Item Attributes

The attribute group is added to the item classes.

Deploy the Item Extensible Flexfield

After associating the attribute groups to the item classes, you must deploy the extensible flexfield.

With roles allowing access, in the Setup and Maintenance work area, go to:
- Offering: Product Management
- Functional Area: Items
- Task: Deploy Item Extensible Flexfields
Search for your flexfield code. Select it and click Deploy Flexfield.
After successful deployment, you must sign out and sign back in to view the EFF configuration on the item.

Edit the Pricing Matrix Class

You must now add the item attribute to the Pricing Matrix Class.

With roles allowing access, from the Navigator, select Pricing Administration. In the Overview page, open the Tasks panel and select Manage Matrix Classes.
In the Manage Matrix Classes pages, select Channel Program Eligibility.
In the Edit Matrix Classes page, click Add Row from the Actions drop-down list. This creates a new dimension to Channel Program Eligibility.
In the Name field, enter a name for your dimension. For example, Color.
In the Source Code Name field, enter a code concatenated with the operator abbreviation. The supported operator abbreviations are E for equal to, NE for not equal to, EGT for greater than or equal to, and ELT for less than or equal to. For example, COLOR_E.
In the Comparison field, choose the comparison operator. For example, =.
From the Compare to Attribute drop-down list, select one of the following. You must select the same data type that you specified when you set up the attribute on the Manage Item Attribute Groups and Attributes page. If the data types don't match, then the eligibility rules won't work correctly.
- itemExtensibleAttribute.VarcharValue
- itemExtensibleAttribute.NumberValue
Leave the Required check box deselected. Select the Allow Null and Null Is Wildcard check boxes.
From the Domain list, select:
- Domain Type: Item Extensible Attribute
- Data Type: Select the same data type that you specified when you set up the attribute on the Manage Item Attribute Groups and Attributes page
- Attribute: Select the attribute you created in the Manage Item Attribute Groups and Attributes page.
- Attribute Group Identifier: ItemExtensibleAttribute.AttributeGroupCode (default value)
- Attribute Identifier: ItemExtensibleAttribute.AttributeCode (default value)
Leave the Default Value field blank as it's not used. Click OK.
Click Save.

Update Channel Lookup

In the Setup and Maintenance work area, go to:
- Offering: Order Management/Procurement
- Functional Area: Channel Revenue Management/Supplier Incentives
- Task: Manage Channel Lookups
Search for the extensible lookup: ORA_ CJM_ITEM_LEVEL and add a new lookup code.
In the Lookup Code field, enter the same name as the Source Code Name used for Channel Program Eligibility matrix class (without the concatenated operator). For example, if the Source Code Name in the matrix class is COLOR_E, then enter COLOR as the lookup code.
Enter values for the remaining fields and click Save.

Note: For more information about creating extensible flexfields, see User Defined Attribute Groups and Attributes (Extensible Flexfields-EFFs) Setup White Paper (Doc ID 1992317.1) on My Oracle Support at https://support.oracle.com.