Inventory Attribute Group
Inventory Attribute Group
Following are the Inventory attributes and their possible values. You set these attributes when defining or updating items.
1. 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 Inventoryfunctional area.
2. 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.
3. Transactable: Indicate whether to allow Inventory transactions. You can set this attribute only when you turn on the Stockable option.
Note: Oracle Order Management 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.)
4. 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 Management, if item attribute Reservable is checked, you can manually reserve a specific revision at order entry or let Pick Release use Inventory picking rules to suggest the revision when the order is picked. If Reservable item attribute is not
checked, Inventory picking rules will suggest the revision when the order is picked.
5. Reservable: Indicate whether you can create material reservations. You can reserve an item only when you have sufficient inventory.
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: If the Reservable attribute is checked, Oracle Order Management allows reservation of the item during order entry. If material hasn’t been reserved prior to pick release, pick release creates reservations for material when the pick wave move order is allocated.
6. Check Material Shortages: Indicate whether the system will check this item for material shortages.
Turn this option on to trigger a material shortage alert and shortage notification during transactions of this item Oracle Inventory and Oracle Shipping execution will 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 pick wave move order line will be immediately deleted and the delivery line status will change to Backordered. In the event that only part of the required quantity is available, the delivery line will split into the released portion and the backordered portion. The requested quantity on the move order line will update to reflect the quantity that was available for picking, and the move order line will close when the available quantity has been picked. The delivery line can be re–released
through the Shipping Transactions form, the Release Sales Orders for, or the Release Sales Orders SRS process.
LOT DETAILS
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.
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.
Note: For Oracle Order Management, if an item is Reservable, you can manually reserve a specific lot at order entry or let pick release use Inventory picking rules to suggest the lot when the order is picked. If the item is not Reservable, Inventory picking rules will suggest the lot when the order is picked.
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.
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.
Lot Status Enabled
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.
Lot Split Enabled
Indicate whether a lot–controlled item may split into many lots during the production of a batch.
Lot Merge Enabled
Indicate whether many lots of a lot–controlled item may merge during the production of a batch.
Lot Translate Enabled
Enables you to translate lots within a lot controlled item.
Lot Substitution Enabled
Enables you to substitute lots during a transaction.
SERIAL DETAILS
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 sales order. If you select this option, serial numbers are required at ship confirm. 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.
The following table presents conditions where you can change back and forth between certain options:
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.
Serial Status Enabled
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.
LOCATOR DETAILS
Locator Control
Dynamic entry Define locators when you use them, either as you receive or ship items.
No control Locator control not established.
Prespecified Defined 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.
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. 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
Inventory Attribute Group | OracleUG
I really blog as well and I am posting a thing very similar to this specific article, “Inventory Attribute Group | OracleUG”. Would you care in cases where I personallyutilise a few of your suggestions? Thank you -Hildegard