Interdependencies for Status Attributes: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 Purchasableto 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 following table presents status attributes:
| Status Attribute | Item Defining Attribute | Functional Area / Oracle Product | Functionality |
|---|---|---|---|
| Stockable | Inventory Item | Inventory | Enables you to store the item in an asset subinventory. |
| Transactable | Inventory Item | Inventory, Order Management, Purchasing, Work in Process | Enables you to transact the item in Oracle Inventory, Oracle Order Management, Oracle Purchasing and Oracle Work in Process. |
| Purchasable | Purchased | Purchasing | Enables you to place the item on a purchase order. |
| Build in WIP | NA | Work in Process | Enables you to build the item on a discrete job, a repetitive schedule, or both. |
| Customer Orders Enabled | Customer Ordered Item | Order Management | Enables you to place the item on a sales order. |
| Internal Orders Enabled | Internal Ordered Item | Inventory, Order Management, Purchasing | Enables you to create an internal sales order for the item |
| BOM Allowed | Inventory Item | Bills of Material | Enables you to create a bill of material for the item |
| Invoice enabled | Invoiceable Item | Receivables | Enables you to create an invoice for the item |
| Recipe Enabled | NA | Process Manufacturing | Enables you to create a recipe or formula for this item in process manufacturing. |
| Process Execution Enabled | Inventory Item | Process Manufacturing | Enables you to use the item in a production batch as an ingredient, product, or by-product. |
You set status control for a status attribute with the Item Attributes Control window.
Interdependencies 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 following table presents interdependencies for the status attributes:
| Attribute | Must be set to | If |
|---|---|---|
| Stockable | No Yes | Inventory Item is set to No ASL is VMI enabled |
| Transactable | No Yes | Stockable is set to No ASL is VMI enabled |
| 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 |
| Process Execution Enabled | No | Inventory Item or Recipe Enabled Flag is set to No |
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 and 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 that 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.
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.
