This section describes the Inventory attributes and their possible values. You can set these attributes when defining or updating items. See: Defining Items and Updating Organization Level Items.
This attribute enables you to stock and transact this item in Oracle Inventory. Select this option to enable the following item attributes: Stockable, BOM Allowed, Transactable, and Build in WIP.
This is an item-defining attribute. If you selected this item, it is automatically assigned to the default category set for the Inventory functional area. See: Item Defining Attributes.
This attribute enables you to stock the item in Oracle Inventory. You can set this attribute only when you enable the Inventory Item attribute. You must enable this item attribute if you want to transact the item.
This attribute is optionally set by the Item Status code. See: Status Attributes and Item Status Control.
This attribute enables you to perform transactions on the item. You can set this attribute only if you set the item attributes Inventory Item and Stockable. This attribute is optionally set by the Item Status code. See: Status Attributes and Item Status Control.
Note: Oracle Order Management uses this along with the Stockable and Returnable item attributes to determine which authorized returned items can be physically received into inventory. (See also OE Transactable).
This attribute enables you to create item revisions. If you turn this option on you must specify an existing revision number for issues and receipts on the revisions tab. See, Defining Item Revisions for more information.
Important: You cannot change revision control when an item has on hand quantity. 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 Management, if item attribute Reservable is checked, you can manually reserve a specific revision at order entry or use Inventory picking rules to suggest the revision when you pick an order. If you do not enable the Reservable item attribute, Inventory picking rules suggest the revision when you pick the order.
This attribute enables you to create material reservations for the item. You can reserve an item only when you have sufficient inventory.
Non-Reservable ItemsOracle Inventory supports picking for non-reservable items. Non-reservable items are often used when on-hand quantities are not closely tracked and when inventory is often driven negative during shipment confirmation. When a line for a non-reservable item is pick released, the system does not require pick confirm or attempt to generate allocations for the material. Instead, the line status is immediately changed to Released and the delivery line becomes eligible for shipment confirmation. The subinventory and locator on the delivery line become the subinventory and locator from which the ship confirmation transaction issues the inventory (this is taken from the Shipping Item Transaction Default for that item).
If insufficient quantity is available in that location, and negative quantities are enabled for that organization, then the shipment confirmation will drive inventory negative. Negative quantities are permitted if the Allow Negative Balance check box is selected for the organization when picking and shipping the following:
a non-reservable item
a reservable item that resides in a non-reservable subinventory
Reservation control at the subinventory level takes precedence over reservation control at the item level. So if a reservable item resides in a non-reservable subinventory, then the subinventory's status takes precedence and a negative on-hand quantity will be allowed when picking/shipping a sales order (the Allow Negative Balance check box must be selected for the organization).
Note: If the Reservable attribute is selected, Oracle Order Management allows reservation of the item during order entry. If material has not been reserved prior to pick release, then pick release creates reservations for material when the pick wave move order is allocated.
Important: Reservation control cannot be turned off if reservations exist.
This attribute enables you to check for material shortages for the item. Turn this option on to trigger a material shortage alert and shortage notification during transactions of the item. See, Material Shortage Alerts and Shortage Notifications
Oracle Inventory and Oracle Shipping Execution automatically backorder a delivery line at pick release if inventory is unavailable for allocation. In the event that no material is available for allocation, the system deletes the pick wave move order line immediately and changes the delivery line status to Backordered. If the system can allocate part of the required quantity, then the system splits the delivery line. The system updates the requested quantity on the move order line to reflect the available quantity and closes the move order line when you pick the available quantity. You can use the Shipping Transactions window, the Releases Orders window, or the Releases Sales Orders SRS process to re-release the delivery line.
| 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. |
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 system checks for on hand quantity in all child organizations.
For Oracle Order Management, if an item is Reservable, you can manually reserve a specific lot at order entry or use Inventory picking rules to suggest the lot when you pick an order. If the item is not Reservable, then Inventory picking rules suggest the lot when you pick an order..
Work in Process recognizes lot control or serial control for an item, but not both. You cannot transact an item in Work in process if it is under both lot and serial control.
Enter a starting prefix for all lot numbers you define for this item. When you set Lot Number Generation to At item level in the Organization Parameters window, then the system uses this prefix you define a lot number for the item.
Enter a starting lot number for the item. When you set Lot Number Generation to At item level in the Organization Parameters window, the system uses this number as the starting lot number. When you create additional lots for the item, the system increments each suceeding lot. See, Defining Organization Parameters.
This is the number of days added to the lot creation date to determine the lot maturity date. If you do not enter a number, the system assumes the lot is mature at creation. Lot Creation Date + Maturity Days = Default Lot Maturity Date.
This is the number of days added to the lot creation date before you can release the lot. If you do not enter a number, the system assumes that you can use the lot immediately. Lot Creation Date + Hold Days = Default Hold Release Date.
Lot expiration controls govern how long items in a given lot remain available. Select the Control level:
| No control | Shelf life control not established for this item. |
| Shelf life days | Specify the shelf life of the item in days. The system starts counting the shelf life on the day you receive the lot into inventory. After the specified number of days, the system sends you a warning message. |
| 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. |
Note: If Lot Expiration is controlled at the Master level, the check for on-hand quantity is against the sum of on hand quantities in all child organizations.
You can customize how the system calculates the lot expiration date. For more information, see My Oracle Support.
Important: The following restriction applies to Oracle Process Manufacturing (OPM) organizations only:
An error message will prevent you from updating the Control field if one or more of the following conditions exist:
There is on-hand quantity.
Transactions exist.
Lots exist.
Enter the number of days each lot is active. At receipt, the system adds the shelf life days to the system date to determine the expiration date. This is used only when you choose Shelf life days for Lot Expiration Control.
Enter the number of days after the creation date before you need to retest the lot. The system adds this number to the lot creation date to determine the default retest date. Lot Creation Date + Retest Interval = Default Lot Retest Date.
Enter the number of days the system adds to the expiration date before it performs an action on the lot. Lot Expiration Date + Lot Expiration Action Interval = Default Expiration Action Date.
Enter the default action code for this item. This is the action listed on the expiration notification when the lot expires, fails quality inspection, or falls within the experimental error results region.
Select this option to enable cycle counting for the item. See: Overview of Cycle Counting.
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 require approval for if the counted quantity is within tolerance. For physical counts under 90 units, Inventory creates an adjustment, changing the quantity on hand to the physical count.
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 require approval for if the counted quantity is within tolerance. For physical counts over 110 units, Inventory creates an adjustment, changing the quantity on hand to the physical count.
Important: The lot substitution feature is not supported for items with serial control or any combination such as lot serial, lot revision, or LSR combinations.
Select from the following values on the Serial region:
| Field Name | Values |
|---|---|
| Generation |
|
| Serial Tagging at Issue | This is a display-only field. The Serial Tagging at Issue check box displays a check mark if one or more serial tagging transactions are enabled for the item-organization combination in the Serial Tagging Assignments window. The serial tagging transaction types include WIP Issue, field service usage, and return to vendor.
Note: If the serial generation is No Control or At Sales Order Issue then you can navigate to the Serial Tagging Assignments window by selecting Tools > Serial Tagging Assignments. If At Receipt or Predefined is selected, then this menu option is unavailable. |
| Starting Prefix | Enter a starting alphabetic 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 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 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. To generate more than nine serial numbers, the starting number needs to have as many placeholders (leading zeroes) as necessary, for example, 00000001********. See: Defining Organization Parameters. |
The following table presents conditions where you can change back and forth between certain options:
| Change back and forth between | 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 |
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.
| 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: For Oracle Order Management, if an item is Reservable, you can manually reserve a specific locator at order entry or let pick release use Inventory picking rules to suggest the locator when the order is picked. If the item is not Reservable, Inventory picking rules will suggest the locator when the order is picked.
Note: Locator control for an organization or for a subinventory overrides locator control for an item.
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.
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.
Defines the default value of the on-hand status for the receipt transaction for non lot-controlled items. If the field is null, then the subinventory level status serves as the default value for the on-hand status.
Indicate whether an item is subject to status control at the Lot Level. For example, a lot may be In Test. A company may have a policy of allowing Lots In Test to be used in planning and reserved, but not shipped. A lot may also be In Quarantine. For example, a company may have a policy of not allowing lots In Quarantine to be used in planning.
If an item is lot-controlled, you can indicate the Default Lot Status. For example, a lot of microprocessors may be at the Quarantine status until a soak test is complete.
Indicate whether an item is subject to status control at the Serial Level. For example, a company may have a policy of allowing all functions on serial numbers that are New, and a policy of allowing reservations to Reworked serial numbers, not including Reworked items.
If an item is serial-controlled, you can indicate the Default Serial Status. For example, a serial number of analytical equipment may be at the Quarantine status until a soak test is complete.
Indicate whether the item is grade controlled in addition to lot controlled. A grade code represents specific characteristics of a lot. If you select the Grade Controlled check box, then you must specify a default grade for the item.
Note: You cannot modify this check box if you have transacted the item.
Enter a default grade for the item. All items under grade control must have a default grade. You can use the grade change transaction to change the default grade of an item.
Note: You can change the default grade even if you performed transactions for the item.
If you enable child lot control, you can specify a parent lot and a child lot for transactional purposes. The system processes transactions for the lot regardless of whether you specify the parent lot for the transaction. You cannot modify this field if inventory transactions or reservations exist for the item. If you choose to control this attribute at the master organization level, then you can modify this attribute only if no transactions or reservations exist for the master organization or any child organizations that are associated with the master organization.
This field determines how the system generates child lot numbers at the item level. You can choose to generate child lot numbers across the organization level or at the item level. The available choices are:
Parent + Child: When set to parent + child, the parent lot number acts as a prefix, and the next available lot number is added to form the child lot. For example if the parent lot is p1, then the child lot would be p1-1.
Parent: When set to parent, child lot numbers are based on the same sequence as the lot number. For example, if the parent lot is p1, then the child lot is p2.
If you choose to generate child lots at the item level, you can optionally choose to enter a child lot prefix.
Enter the starting number for each child lot. This field is enabled only if the item is child lot enabled.
Select this check box to ensure the child lot number conforms to the child lot parameters that you define for the organization or the item. If you select this check box, then the system verifies the child lot number is the lot number concatenated with the child lot prefix and a numeric suffix for the lot number of the correct zero-padded length, if you enable zero padding at the item level.
Select this check box to ensure that a new child lot inherits all the attributes of the parent lot. If you do not select the check box, then the child lot does not inherit the parent lot attributes.
Indicate whether a lot-controlled item may split into many lots.
Indicate whether many lots of a lot controlled item may merge into one lot.
Enables you to translate lots within a lot controlled item.
Enables you to substitute lots during a transaction.
Important: The lot substitution feature is not supported for items with serial control or any combination such as lot serial, lot revision, or LSR combinations.
Select this check box to allocate, reserve, or move partial lot quantities. If you do not select this check box you must transact the full lot quantity for this item. You cannot modify this field if transactions exist for the item.
Additional Information: Indivisible lots must be consumed in full lot quantities. An indivisible lot has to be consumed in full quantity when performing WIP (Oracle Work in Process) issue transactions to a batch. However, for WIP return transactions, the same lot can be received in partial quantities.
Enables you to pick items in bulk.
Note: This attribute is specific to Oracle Warehouse Management.
Sets the default subinventory for move order receipts.