Inventory Attribute Group (Oracle Inventory Help)


	Previous	Next		Contents	Index	Glossary	Library

Inventory Attribute Group

Following are the Inventory attributes and their possible values. You set these attributes when defining or updating items. See: Defining Items and Updating Organization Level Items.

Inventory Item

Indicate whether to stock and transact this item in Oracle Inventory. You must turn this option on if you want to enable the following item attributes: Stockable, BOM Allowed, Transactable, and Build in WIP.

This is an item defining attribute. If you turn this option on, the item is automatically assigned to the default category set for the Inventory functional area. See: Item Defining Attributes.

Stockable

Indicate whether to stock this item in Inventory. You can set this attribute only when you turn on the Inventory Item option. Turning this option on enables you to set the Transactable item attribute.

This attribute is optionally set by the Item Status code. See: Status Attributes and Item Status Control.

Transactable

Indicate whether to allow Inventory transactions. You can set this attribute only when you turn on the Stockable option. This attribute is optionally set by the Item Status code. See: Status Attributes and Item Status Control.

Note: Oracle Order Entry uses this along with Stockable and Returnable to determine which authorized returned items can be physically received into inventory. (See also the OE Transactable attribute.)

Revision Control

Indicate whether to track inventory balances by revision. If you turn this option on you must specify an existing revision number for issues and receipts.

Attention: You cannot change revision control when an item has quantity on hand. If Revision Control is controlled at the Master Item level, the check for on-hand quantity is against the sum of on-hand quantities in all child organizations.

Note: For Oracle Order Entry, if profile option OE: Reservations is Yes, you can specify a revision at order entry or scheduling, or let Pick Release use Inventory picking rules to determine the revision when the order is picked. If the profile option is No, you must enter a revision at ship confirmation.

Reservable

Indicate whether you can create material reservations. You can reserve an item only when you have sufficient inventory. See: Scheduling an Order or Order Line.

Note: Reservation control for a subinventory overrides reservation control for an item. In other words, if an item is reservable but a subinventory is not, the item quantity in that subinventory is not reservable.

Note: Oracle Order Entry recognizes this attribute only if profile option OE: Reservations is Yes. Then, Order Entry allows reservation of the item during order entry or scheduling and automatically creates any necessary reservations when the item is released for picking.

Attention: You cannot turn reservation control off if reservations exist.

Lot Control

No control	Do not establish lot control for the item.
Full control	Track inventory balances by lot number. You must specify a lot number for issues and receipts.

Note: For Oracle Order Entry, if profile option OE: Reservations is Yes, you can specify a lot at order entry or scheduling, or let Pick Release use Inventory picking rules to determine the lot when the order is picked. If the profile option is No, you must enter a lot at ship confirmation.

You can establish lot number control only for an item that has no quantity on hand. If Lot Control is controlled at the Master Item level, the check for on-hand quantity is against the sum of on-hand quantities in all child organizations.

Attention: Oracle Work in Process recognizes either lot control or serial number control for an item--but not both. You cannot transact an item into Work in Process if it has both lot and serial control defined.

Starting Lot Prefix

Enter a starting prefix for all lot numbers you define for this item. When Lot Number Generation is At item level in the organization parameters, this prefix is used when you define a lot number.

Starting Lot Number

Enter a starting numeric suffix for this item only. When Lot Number Generation is At item level in the organization parameters, this starting numeric suffix is used when you create a lot number. Thereafter, this number is incremented for each succeeding lot. See: Defining Organization Parameters.

Lot Expiration (Shelf Life) Control

Lot Expiration control governs how long items in a given lot remain available.

Shelf life days Specify a number of days for all lots of an item, beginning on the day you create the lot by receiving the item. You receive a warning message that the lot expires after the specified number of days.

No control Shelf life control not established for this item

User-defined Specify an expiration date as you receive each lot. You receive a warning but are not prevented from using the lot after expiration.

Attention: You cannot change lot expiration control when an item has quantity on hand. If Lot Expiration is controlled at the Item level, the check for on-hand quantity is against the sum of on-hand quantities in all child organizations.

Shelf Life Days

Enter the number of days each lot is active. At receipt, the expiration date is determined by adding the shelf life days to the system date (includes the day you define the lot). This is used only when you choose Shelf life days for Lot Expiration Control.

Cycle Count Enabled

Turn this option on for automatic cycle count scheduling. See: Overview of Cycle Counting.

Negative Measurement Error

Enter the percentage of negative variance acceptable before cycle count creates an adjustment transaction. Your physical cycle count can be less than the quantity on hand by an amount less than or equal to this percentage.

For example, suppose quantity on hand is 100 and negative tolerance is 10%. Inventory does not create an adjustment for physical counts between 90 and 100 units. This means the quantity on hand remains 100 units. For physical counts under 90 units, Inventory creates an adjustment, changing the quantity on hand to the physical count.

Positive Measurement Error

Enter the percentage of positive variance acceptable before cycle count creates an adjustment transaction. Your physical count can be greater than the quantity on hand by an amount less than or equal to this percentage.

For example, suppose quantity on hand is 100 and positive tolerance is 10%. Inventory does not create an adjustment transaction for physical counts between 100 and 110 units. This means the quantity on hand remains 100 units. For physical counts over 110 units, Inventory creates an adjustment, changing the quantity on hand to the physical count.

Serial Generation

At inventory receipt	Create and assign serial numbers when you receive the item. Thereafter, for any material transaction, you must provide a serial number for each unit.
At sales order issue	Create and assign serial numbers when you issue (ship) the item against a customer sales order. (Internal requisition orders do not require a serial number when you ship the item.) If you receive an item on an RMA (return material authorization), you must specify the same serial numbers you created at sales order issue. All other material transactions for this item bypass serial number information.
No control	Serial number control not established for this item. All material transactions involving this item bypass serial number information.
Predefined	Assign predefined serial numbers when you receive the item. Thereafter, for any material transaction, you must provide a serial number for each unit.

You can change back and forth between certain options under the following conditions:

Change back and forth between When

Dynamic entry at inventory receipt Predefined serial numbers Any time

Dynamic entry at sales order issue No serial number control Any time

Dynamic entry at inventory receipt No serial number control Item has no on-hand quantity

Dynamic entry at sales order issue Predefined serial numbers Item has no on-hand quantity

Predefined serial numbers No serial number control Item has no on-hand quantity

Dynamic entry at inventory receipt Dynamic entry at sales order issue Item has no on-hand quantity

Table 1 - 9. (Page 1 of 1)

If Serial Generation is controlled at the Item level, the check for on-hand quantity is against the sum of on-hand quantities in all child organizations.

Change back and forth between	When
Dynamic entry at inventory receipt	Predefined serial numbers	Any time
Dynamic entry at sales order issue	No serial number control	Any time
Dynamic entry at inventory receipt	No serial number control	Item has no on-hand quantity
Dynamic entry at sales order issue	Predefined serial numbers	Item has no on-hand quantity
Predefined serial numbers	No serial number control	Item has no on-hand quantity
Dynamic entry at inventory receipt	Dynamic entry at sales order issue	Item has no on-hand quantity
Table 1 - 9. (Page 1 of 1)

Starting Serial Prefix

Enter a starting alpha prefix for all serial numbers you define. You must enter a value when you choose Predefined and when Serial Generation is At item level in the organization parameters. This prefix is used when you define your serialized units.

Starting Serial Number

Enter a starting numeric suffix for all serial numbers for this item only. You must enter a value when you choose Predefined and when Serial Number Generation is At item level in the organization parameters. This starting numeric suffix is used when you define your serialized units. Thereafter, this number is incremented for each succeeding serial number. See: Defining Organization Parameters.

Locator Control

Dynamic entry	Define locators when you use them, either as you receive or ship items.
No control	Locator control not established.
Prespecified	Define locators before you use them.

Note: In Oracle Order Entry, if profile option OE: Reservations is Yes, Order Entry uses Inventory picking rules to assign the locator to an item being shipped.

Note: Locator control for an organization or for a subinventory overrides locator control for an item.

Attention: You cannot change locator control when an item has quantity on hand.

Restrict Subinventories

Indicate whether to restrict transactions of this item to or from a subinventory specified in a list you define with the Item/Subinventory Information window. See: Assigning Subinventories to an Item. This option must be turned on if you choose to restrict locators.

Restrict Locators

Indicate whether to restrict transaction of this item to or from a locator specified in the list you define with the Item/Subinventory Information window. You cannot restrict locators unless you also restrict subinventories.

Shelf life days	Specify a number of days for all lots of an item, beginning on the day you create the lot by receiving the item. You receive a warning message that the lot expires after the specified number of days.
No control	Shelf life control not established for this item
User-defined	Specify an expiration date as you receive each lot. You receive a warning but are not prevented from using the lot after expiration.