Main Attribute Group

The following are the Main attributes and their possible values. You set these attributes when you define or update items. See: Defining Items and Updating Organization Level Items.

Primary Unit of Measure

This is the stocking and selling unit of measure. Any necessary conversions are based on this unit of measure. This attribute is not updatable and assigned at the organization level. See: Defining Units of Measure.

The default primary unit of measure for new items is defined using the INV:Default Primary Unit of Measure profile option. See: Oracle Inventory Profile Options.

The primary unit of measure is the default for invoices and credit memos entered in Oracle Receivables.

Note: If an item belongs to both a master organization and a child organization, and these organizations belong to the same costing organization, the primary unit of measure for the item must be the same within both organizations.

Tracking

This attribute controls how on-hand balances are tracked. This attribute is assigned at the organization level. The available values are:

Primary The system tracks the on-hand balances by the primary unit of measure.
Primary & Secondary The system tracks the on-hand balances by both the primary and secondary units of measure.

Warning: Oracle Bill of Materials and Dual Unit of Measure (UOM): When the Tracking UOM for an item is Primary & Secondary (a dual unit of measure), do not select the BOM Allowed check box on the Bills of Material tab. Otherwise, an error occurs when you try to create a BOM with this item in Oracle Bill of Materials.

Pricing

This attribute controls if pricing is based on the primary or secondary unit of measure. If you set the value to secondary, the system reprices the orders line at ship confirmation. This attribute is assigned at the organization level.

Secondary

If the item is dual unit of measure controlled, or priced in a secondary unit of measure, you can specify a secondary unit of measure. This attribute is assigned at the organization level.

Defaulting (Dual Control)

You can stock items in two units of measure. This attribute is assigned at the organization level. The available choices are:

Fixed The system stores inventory in both the primary and secondary units of measure. You can enter an item quantity in one unit of measure, and the system converts the quantity to the secondary unit of measure and displays both quantities.
Default The system stores inventory in both the primary and secondary units of measure. You can enter an item quantity in one unit of measure, and the system converts the quantity to the second unit of measure and displays both quantities. You can change the quantity in the secondary unit of measure, without changing the quantity in the primary unit of measure.
No Default The system stores inventory in both the primary and secondary units of measure. Use this option when the default conversion between the two units of measure is usually not the same. The system does not automatically display in the secondary unit of measure when you specify the quantity for the primary unit of measure. You manually enter the quantity of the secondary unit of measure before you process a transaction. The secondary quantity can fluctuate from the default conversion by the factors that you specify in the Deviation + and Deviation - attributes.

Deviation Factor +

You can enter acceptable deviations as decimal values. This attribute is assigned at the organization level. This produces a plus or minus tolerance of acceptability. For example, if the allowable transaction quantity deviation for the item is 10 percent higher than the established conversion, you would enter 10 in this field.

Deviation Factor -

You can enter acceptable deviations as decimal values. This attribute is assigned at the organization level. This produces a plus or minus tolerance of acceptability. For example, if the allowable transaction quantity deviation for the item is 10 percent lower than the established conversion, you would enter 10 in this field.

User Item Type

Oracle provides several types by default at installation. These types correspond to the item templates also provided. Select one of these values, or one you defined with the Item Type window. See: Defining Item Types.

Item Status

Item status codes set or default the values for attributes under status control. User-defined status codes control certain item attributes designated as status attributes. The status attributes are:

These attributes control the functionality of an item over time. See: Status Attributes and Item Status Control, Defining Item Status Codes, and Defining Item Attribute Controls.

The default item status for new items is defined using the INV:Default Item Status profile option. See: Oracle Inventory Profile Options.

Conversions

Both Use both item-specific and standard unit of measure conversions. If you defined an item-specific and a standard conversion for the same unit of measure, the item-specific conversion is used.
Item specific Use only unit of measure conversions unique to this item.
Standard Use only standard unit of measure conversions. If you want to use only standard conversions do not create item specific conversions.

Long Description

Indicate the long description for this item. This Long Description is supported in multiple languages.

Related Topics