Attribute Definitions

Purpose: Use the Attribute Definitions screen to review or work with attributes that you can create and apply to products and locations to control order routing.

Used for the Routing Engine module.

For more information: See Using Attribute Rules for Delivery and Pickup Orders and Using Attribute Rules for Ship-for-Pickup Orders for background.

Assigning attributes to locations or products: Use the New Location Attribute and New Product Attribute screens in Classic View to assign attributes.

Reviewing location and product attribute assignments: You can use a web service to retrieve a list of location and product attribute assignments. See the Web Services Guide on My Oracle Support (2953017.1).

How to display this screen: Select Attribute Definitions from the Modern View home screen. See the Modern View Overview for background.

Note:

Available if Use Routing Engine is selected at the Tenant screen. Only users with Attribute Definitions authority can display this screen. See Roles for more information.

Options at this screen

Option	Procedure
create a new attribute definition	Select Add from the Actions menu or select the Add icon () to open the Add Attribute Definition window. Complete each field. All fields are required. Enter the description of the attribute in the Attribute Description field. The name can include letters, numbers, spaces, and special characters. Enter the attribute code in the Attribute Code field. The attribute code can be 1 to 40 positions long, can include letters, numbers, spaces, and special characters, but all letters are set to upper case. Also, the code must be unique within the organization; however, other organizations can have the same code. Select the Attribute Type from the drop-down box, indicating how to use the attribute for filtering orders. Select the Ship for Pickup Match Type from the drop-down box, indicating whether the attribute applies to the location if it is the Originating, Pickup, or Sourcing location for an order. Select the Data Type indicating the type of data that can be defined through the attribute. Note that if you select a Data Type of list, you can delete list items while creating the attribute definition. Select OK or press enter to create the attribute definition, or select Save and Add Another to continue creating attribute definitions.
search for attribute definitions	The existing attribute definitions for your current organization are displayed. Use any combination of the fields at the top of the screen and tab through the search fields to restrict the search results to matching attribute definitions: Optionally, enter a full or partial description in the Attribute Description field. When you tab through this field, the displayed attribute definitions are limited to those whose descriptions start with your entry, but that don’t need to match completely. For example, if your entry is prod, the attribute definitions with descriptions starting with Product or Product and Location are displayed. Optionally, enter a full or partial code in the Attribute Code field. When you tab through this field, the displayed attribute definitions are limited to those whose codes start with your entry, but that don’t need to match completely. Optionally, select an Attribute Type to display attribute definitions of the same type. Optionally, select a Data Type to display attribute definitions of the same type. Optionally, select an Allow Multiple setting of Yes or No to display attribute definitions that match your selection. Sort displayed attribute definitions: You can also sort the displayed attribute definitions by clicking the up arrow (^) or down arrow next to each field title. View options: Open the View Options drop-down menu to the right of the Actions menu to manage columns, change the sort of individual columns from ascending to descending or back, or remove the search fields above the columns. See How to use the View options in Modern View for more information. Filter options: Open the Filter Options drop-down menu to the right of the refresh icon () to control whether the search results need to match all the search criteria entered for multiple columns. See How to use the Filter Options in Modern View for more information. Clear filters: Select Clear Filters to remove the criteria entered in the filter fields.
update an attribute definition	Highlight a displayed attribute definition. Select Edit from the Actions menu or click the Edit icon () to open the Edit Attribute Definition window. You can edit the Attribute Description or Ship for Pickup Match Type You can also add or remove list items for a List attribute, and you can change the setting of the Allow Multiple flag for a Text or Number attribute. See Fields at the Add, Edit, and View Attribute Definitions Windows, below, for details on fields. Select OK or press enter to save your changes.
view an attribute definition	Highlight a displayed attribute definition. Select View from the Actions menu or click the View icon () to open the View Attribute Definition window. See Fields at the Add, Edit, and View Attribute Definitions Windows, below, for details on fields.
delete an attribute definition	Highlight a displayed attribute definition. Select Delete from the Actions menu or click the Delete icon (). Select OK or press enter at the Confirm Deletion window to delete the attribute definition.

Fields at the Attribute Definitions screen

Field	Description
Attribute Description	The description of the attribute. Can be up to 100 positions. Optionally, enter a full or partial description to display attribute definitions whose descriptions match or start with your entry.
Attribute Code	The Code identifying an attribute you can apply to locations, products, or both. Attribute codes can be 1 to 40 positions in length and must be unique within the organization. The code can include special characters, but cannot include any spaces. Any lowercase letters entered are automatically converted to uppercase. Optionally, enter a full or partial code to display attribute definitions whose codes match or start with your entry.
Attribute Type	Location: The attribute can be applied to locations to filter eligible locations when routing orders. For example, if an order originates in a location associated with a particular brand, the eligible sourcing or pickup locations can be restricted to that brand. Product: The attribute can be applied to products. Not used in routing orders. Location and Product: The attribute can be applied to products and locations to filter eligible locations when routing orders. For example, if a product requires engraving, the eligible sourcing and pickup locations can be restricted to those that support engraving. Optionally, select an attribute type to display matching attribute definitions.
Data Type	Indicates the type of data that can be defined through the attribute. Available data types are: Boolean: Indicates whether a condition is true for the product or location; for example, use a Boolean attribute to identify each location that supports oversized items. List: Used to define a list of valid values that can be assigned to a product or location; for example, this might be a list of brands. Each value can be up to 50 positions. Number: Indicates that the value defined through the attribute must be numeric. Numbers can be up to 25 positions, including commas, decimal points, or minus signs. Text: Indicates that the value defined through the attribute is text. Values can be up to 50 positions. Optionally, select a data type to display matching attribute definitions.
Allow Multiple	Set to Yes if multiple values for the attribute can be assigned to the same product or location; otherwise, set to No. Boolean attributes do not support allowing multiples. Also, multiple attribute values cannot be applied to a location when the attribute’s Location Use for the location is set to Originating Location. Optionally, select Yes or No to display matching attribute definitions.

Fields at the Add, Edit, and View Attribute Definition Windows

All fields are display-only at the View Attribute Definition window.

Field	Description
Attribute Description	The description of the attribute. Can be up to 100 positions. Truncated if it exceeds the allotted space. Required at the Add or Edit Attribute Definition window.
Attribute Code	The Code identifying an attribute you can apply to locations, products, or both. Attribute codes can be 1 to 40 positions in length and must be unique within the organization. The code can include special characters, but cannot include any spaces. Any lowercase letters entered are automatically converted to uppercase. Required at the Add Attribute Definition window; otherwise, display-only.
Last Updated	Indicates the last date and time, if any, when the attribute definition was updated. The date and time format are based on the locale defined for the organization. Note that this field displays a date and time after you select OK at the Edit Attribute Definition window only if you actually made a change to the definition. Displayed only at the Edit and View Attribute Definition windows. Display-only.
In Use	Yes indicates that the attribute is currently assigned to a product and/or a location; otherwise, set to No. If the attribute is in use, it cannot be deleted. Also, if the attribute is a list type and is in use, you cannot delete any list values, although you can add list values. Displayed only at the Edit and View Attribute Definition windows. Display-only.
Attribute Type	Location: The attribute can be applied to locations to filter eligible locations when routing orders. For example, if an order originates in a location associated with a particular brand, the eligible sourcing or pickup locations can be restricted to that brand. Product: The attribute can be applied to products. Not used in routing orders. Location and Product: The attribute can be applied to products and locations to filter eligible locations when routing orders. For example, if a product requires engraving, the eligible sourcing and pickup locations can be restricted to those that support engraving. Required at the Add Attribute Definition window; otherwise, display-only.
Ship For Pickup Match Type	Indicates whether to filter a location based on its role in fulfilling a ship-for-pickup order: Sourcing: Locations must match the attribute in order to qualify to source the order. For example, if a product requires engraving, the sourcing location must support engraving, based on a matching location attribute with a Location Use of Sourcing. Pickup: Locations must match the attribute in order to qualify as pickup locations for the order. For example, if the order was submitted under a particular brand, the pickup location must support that brand, based on a matching location attribute with a Location Use of Pickup. Sourcing and Pickup: Both the sourcing and the pickup location for an order must match the attribute. For example, if a product is flagged as oversized, both the sourcing and the pickup location must support oversized products, based on both a matching location attribute with a Location Use of Sourcing and a matching location attribute with a Location Use of Pickup. Note: This setting does not control routing of delivery or pickup orders. Required at the Add or Edit Attribute Definition window.
Data Type	Indicates the type of data that can be defined through the attribute. Available data types are: Boolean: Indicates whether a condition is true for the product or location; for example, use a Boolean attribute to identify each location that supports oversized items. List: Used to define a list of valid values that can be assigned to a product or location; for example, this might be a list of brands. Each value can be up to 50 positions. Number: Indicates that the value defined through the attribute must be numeric. Numbers can be up to 25 positions, including commas, decimal points, or minus signs. Text: Indicates that the value defined through the attribute is text. Values can be up to 50 positions. Required at the Add Attribute Definition window; otherwise, display-only.
Value	Use this field to enter each supported value that can be applied for a list attribute. For example, if the attribute is for brand, the values might be the name of each supported brand. Each value can be up to 50 positions. At least one value is required for a list attribute. If this is a Boolean, Number, or Text attribute, this field is not displayed. Click Add Value after entering each new value. The new value is displayed below. Duplicates? If you enter the same value more than once, no error is displayed; however, the duplicate is not added. Values are case-insensitive. For example, if you add a value of ABC123 and then try to enter a value of abc123, it is treated like a duplicate and not added, although no error is displayed. Existing values are listed below this field. Optionally, you can delete a value at the Add or Edit Attribute Definition window by selecting the delete (trash can) icon ); however, you cannot delete any values if the attribute definition is currently In Use.
Allow Multiple	Selected if multiple values for the attribute can be assigned to the same product or location; otherwise, unselected. Not displayed for a boolean attribute. Note that multiple attribute values cannot be applied to a location when the attribute’s Attribute Type for the location is set to Originating Location. Optional at the Add or Edit Attribute Definition window.