Previous  Next          Contents  Index  Glossary  Library

Status Attributes and Item Status Control

Status attributes enable and disable the functionality of an item over time. Each status attribute allows you to enable the item for a particular use. For example, if you set the status attribute Purchasable to Yes, you can put the item on a purchase order.

The status attributes are related to the item defining attributes. You cannot enable a status attribute if you do not set the corresponding item defining attribute to Yes.

The status attributes are:

Status Attribute Item Defining Attribute Functional Area / Oracle Product Functionality
Stockable Inventory Item Inventory Allows you to store the item in an asset subinventory.
Transactable Inventory Item Inventory, Order Entry, Purchasing, Work in Process Allows you to transact the item in Oracle Inventory, Oracle Order Entry, Oracle Purchasing and Oracle Work in Process.
Purchasable Purchased Purchasing Allows you to place the item on a purchase order.
Build in WIP - Work in Process Allows you to build the item on a discrete job, and/or repetitive schedule.
Customer Orders Enabled Customer Ordered Item Order Entry Allows you to place the item on a sales order.
Internal Orders Enabled Internal Ordered Item Inventory, Order Entry, Purchasing Allows you to create an internal sales order for the item
BOM Allowed Inventory Item Bills of Material Allows you to create a bill of material for the item
Invoice enabled Invoiceable Item Receivables Allows you to create an invoice for the item

You set status control for a status attribute with the Item Attributes Control window.

Interdependences for Status Attributes

Each status attribute is dependent on the value of at least one other attribute. For example, you cannot set Stockable to Yes if you set Inventory Item to No. The interdependences for the status attributes are:

Attribute Must be set to If
Stockable No Inventory Item is set to No
Transactable No Stockable is set to No
Purchasable No Purchased is set to No
Build in WIP No Inventory Item is set to No OR BOM Item Type is NOT set to Standard
Customer Orders Enabled No Customer Ordered Item is set to No
Internal Orders Enabled No Internal Ordered Item is set to No
BOM Allowed No Inventory Item is set to No
Invoice Enabled No Invoiceable Item is set to No

Item Status Control

When defining an item, you can use the item attribute Item Status to control status attribute values. You determine the list of values for the Item Status attribute by defining Item Status Codes. An Item Status Code has a user-defined set of Yes/No values for the status attributes. The values are applied to the status attributes when you choose an Item Status Code when defining an item. For example, assume you define an Item Status named Prototype with all status attributes set to Yes except for Customer Orders Enabled. Next, you define another Item Status, Active, with all status attributes set to Yes. In the beginning of a product development cycle, assign the status code Prototype to an item so that you cannot place the item on a sales order. Later, assign the status code Active to allow all functions for the item. See: Defining Item Status Codes.

Pending Statuses

Use pending statuses to automatically update an item's status on a specified date. For each item, specify a list of pending statuses and the corresponding effective dates. See: Defining and Viewing Pending Statuses.

See Also

Item Attributes Listed by Group Name

Defining Item Attribute Controls


         Previous  Next          Contents  Index  Glossary  Library