Item Attributes
Master Level vs. Organization Level
Control Level
|
|
Base Model
|
Master
|
BOM Item Type
|
Master
|
Cost of Goods Sold Account
|
Organization
|
Cumulative Total Lead Time
|
Organization
|
Cumulative Manufacturing Lead Time
|
Organization
|
Encumbrance Account
|
Organization
|
Engineering Item
|
Master
|
Expense Account
|
Organization
|
Fixed Lead Time
|
Organization
|
Planner
|
Organization
|
Planning Exception Set
|
Organization
|
Postprocessing Lead Time
|
Organization
|
Preprocessing Lead Time
|
Organization
|
Processing Lead Time
|
Organization
|
Sales Account
|
Organization
|
Source Organization
|
Organization
|
Source Subinventory
|
Organization
|
Variable Lead Time
|
Organization
|
WIP Supply Locator
|
Organization
|
WIP Supply Subinventory
|
Organization
|
Item-Defining Attributes
Item-Defining Attributes
Functional Area
|
Item Defining Attribute
|
Oracle Inventory
|
Inventory Item
|
Oracle Purchasing
|
Purchased, or Internal Ordered Item
|
Oracle Master Scheduling/MRP and Oracle Supply Chain Planning
|
MRP Planning Method
|
Oracle Cost Management
|
Costing Enabled
|
Oracle Engineering
|
Engineering Item
|
Oracle Order Management
|
Customer Ordered Item
|
Oracle Service
|
Support Service, or Serviceable Product
|
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 following table presents status attributes:
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:
Interdependencies for 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
|
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 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.
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
Relationships Between Attributes
When you define items, Oracle Inventory enforces particular relationships between some of the item attributes:
Required Attribute Values
You must enter values for certain attributes if some related attributes have values as shown in the following table:
Attribute
|
If
|
Contract Coverage Template
|
Contract Item Type is set to Service or Warranty
|
Contract Duration
|
Contract Item Type is set to Service or Warranty
|
Contract Duration Period
|
Contract Item Type is set to Service or Warranty
|
Demand Time Fence Days
|
Demand Time Fence is set to User-defined
|
Encumbrance Account
|
Reverse Encumbrance parameter is set to Yes
|
Expense Account
|
Inventory Asset Value is set to No and Inventory Item is set to Yes
|
Outside Processing Unit Type
|
Outside Processing Item is set to Yes
|
Planning Time Fence Days
|
Demand Time Fence is set to User-defined
|
Planning Time Fence Days
|
Planning Time Fence is set to User-defined
|
Release Time Fence Days
|
Release Time Fence is set to User-defined
|
Repetitive Planning
|
MRP Planning Method is set to MPS planning or MRP planning
|
Service Duration
|
Service Duration Period is not null
|
Shelf Life Days
|
Lot Expiration (Shelf Life) Control is set to Item shelf life days
|
Source Organization
|
Replenishment Source Type is set to Inventory or Subinventory.
|
Starting Lot Number
|
Lot Control is set to Full lot control, and Lot Generation Organization Parameter is set to Item Level
|
Starting Lot Prefix
|
Lot Control is set to Full lot control and Lot Generation organization parameter is set to Item Level
|
Starting Serial Number
|
Serial Number Control is set to Predefined serial numbers
|
Starting Serial Prefix
|
Serial Number Control is set to Predefined serial numbers
|
Substitution Window Days
|
Substitution Window is set to User Defined
|
Interdependent Attributes
Interdependent Attributes
Attribute
|
Must be
|
If
|
Activity Source
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Assemble to Order
|
No
|
Pick Components is set to Yes or BOM Item Type is set to Planning
|
Assemble to Order or Pick Components
|
Yes
|
BOM Item Type is set to Model or Option Class
|
Asset Activity Cause
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Asset Activity Notification
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Asset Activity Shutdown Type
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Asset Activity Source
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Asset Activity Type
|
Null
|
Asset Item Type is anything other than Asset Activity
|
AutoCreated Configuration
|
Null
|
Base Model is Null
|
Base Model
|
Null
|
BOM Item Type does not equal Standard or Pick Components is set to Yes
|
BOM Allowed
|
No
|
If organization process manufacturing enabled, and tracking is set to primary and secondary.
|
ATP Components
|
None
|
Pick Components is set to No, and Assemble to Order is set to No, and WIP Supply Type is set to anything other than Phantom
|
Billing Type
|
Null
|
Contract Item Type is set to anything other than Subscription
|
Billing Type
|
Not Null
|
Enable Service Billing set to Yes
|
BOM Item Type
|
Standard
|
Effectivity Control is set to Model / Unit Number
|
BOM Item Type
|
Model
|
Configurator Model Type is set to container
|
BOM Model Type
|
No
|
If the organization is process manufacturing enabled, and tracking is set to primary and secondary.
|
Build in WIP
|
No
|
Inventory Item is set to No or BOM Item Type does not equal Standard
|
Check ATP
|
Null
|
Contract Item Type is set to anything other than Subscription
|
Check Material Shortage
|
No
|
Transactable is set to No
|
Container Type
|
Null
|
Container is set to No
|
Contract Coverage Template
|
Null
|
Contract Item Type is set to No
|
Contract Duration
|
Null
|
Contract Item Type is set to No
|
Contract Duration Period
|
Null
|
Contract Item Type is set to No
|
Contract Item Type
|
Null or Subscription
|
Inventory Item is set to Yes
|
Contract Item Type
|
Subscription
|
Subscription Dependency enabled is set to Yes
|
Create Configured Item, BOM
|
Null
|
If the item is not an ATO model.
|
Create Fixed Asset
|
Yes
|
Track in Install Base is set to Yes
|
Costing Enabled
|
Yes
|
Inventory Asset is set to Yes
|
Customer Ordered
|
No
|
BOM Item Type is set to Planning or Product Family
|
Customer Ordered
|
No
|
Contract Item Type is Warranty
|
Customer Orders Enabled
|
Yes
|
Configurator Model Type is set to container
|
Customer Orders Enabled
|
No
|
Customer Ordered is set to No
|
Customer Orders Enabled
|
Yes
|
Customer Ordered is set to Yes
|
Cycle Count Enabled
|
No
|
Contract Item Type is set to anything other than Subscription
|
Defaulting
|
Fixed, Default, or No Default
|
Tracking is Set to Primary & Secondary
|
Defaulting
|
Default or No Default
|
Tracking is set to Primary and Pricing is set to Secondary
|
Default Lot Status
|
Null
|
Lot Status Enabled is set to No
|
Default Serial Status
|
Null
|
Serial Status Enabled is set to No
|
Default SO Source Type
|
Internal
|
Ship Model Complete is set to Yes
|
Demand Time Fence Days
|
null
|
Demand Time Fence is not User-defined
|
Deviation Factor +
|
Null
|
UOM Dual Control is set to No Control
|
Deviation Factor –
|
Null
|
UOM Dual Control is set to No Control
|
Effectivity Control
|
Model / Unit Number
|
Asset Item Type is Asset Group
|
Expense Account
|
Yes
|
Inventory Asset Value is No and Inventory Item is Yes
|
Grade
|
N
|
If Lot Control is null
|
Height
|
Null
|
Dimensions UOM is Null
|
Inspection Required
|
No
|
Receipt Routing is set to anything other than Inspection
|
Installed Base Trackable
|
Yes
|
Serviceable is set to shelf Yes and Contract Item Type is set to Null or Subscription
|
Instance Class
|
Null
|
Contract Item Type is set to anything other than Subscription
|
Instance Class
|
Null
|
Install Base Trackable is set to No
|
Internal Ordered
|
No
|
BOM Item Type does not equal Standard
|
Internal Orders Enabled
|
No
|
Internal Ordered is set to No
|
Internal Volume
|
Null
|
Container, Vehicle, or Weight UOM are set to Null.
|
Inventory Item
|
No
|
Contract Item Type is set to anything other than Null or Subscription
|
Inventory Item
|
Yes
|
Asset Item Type, Default Receiving Subinventory, Default Move Orders Subinventory, Default Shipping Subinventory are set to anything other than Null; or BOM Item Type is set to Product Family,
|
Invoice Enabled
|
No
|
Invoiceable Item is set to No
|
Lead Time Lot Size
|
1
|
Repetitive Planning is set to Yes
|
Length
|
Null
|
Dimensions UOM is Null
|
Lot Status Enabled
|
No
|
Lot Control is set to No Control
|
Lot Split Enabled
|
No
|
Lot Control is set to No Control
|
Lot Merge Enabled
|
No
|
Lot Control is set to No Control
|
Lot Substitution Enabled
|
No
|
Lot Control is set to No Control
|
Lot Translation Enabled
|
No
|
Lot Control is set to No Control
|
Match Configuration
|
Null
|
If the item is not an ATO model
|
Maximum Load Weight
|
Null
|
Container, Vehicle, or Weight UOM is set to Null
|
Minimum Fill Percentage
|
Null
|
Container and Vehicle are both set to No
|
Move Order Receipts Subinventory
|
Null
|
Transactable is set to No
|
Orderable On Web
|
No
|
Customer Orders Enabled is set to No
|
Outside Processing Item
|
N
|
If Purchased is set to No or if ASL has VMI.
|
Outside Processing Unit
|
Y
|
Outside Processing Item is Yes
|
Pick Components
|
No
|
Assemble to Order is set to Yes or BOM Item Type is set to Planning or Planning Method does not equal Not planned
|
Pick Components
|
Yes
|
Ship Model Complete is set to Yes
|
Planning Time Fence Days
|
null
|
Planning Time Fence is not User-defined
|
Planning Method
|
Not Planned
|
Pick Components is set to Yes
|
Postprocessing lead time
|
0 (Zero)
|
Make or Buy is set to Make
|
Purchasable
|
No
|
Purchasing Item is set to No or Contract Item Type is set to anything other than Subscription
|
Purchasable
|
Yes
|
Default SO Source Type is set to External
|
Purchasing Tax Code
|
Null
|
Taxable is set to Null
|
Recovered Part Disposition
|
Null
|
Billing Type is Labor
|
Release Time Fence Days
|
Null
|
Release Time Fence is not User-defined
|
Replenishment Point
|
Minimum Quantity
|
Either Maximum Quantity or Fixed Quantity Attributes isenabled.
|
Replenishment Point
|
Minimum Days of Supply
|
Either Maximum days of Supply of Fixed Quantity is enabled.
|
Restrict Locators
|
Locators not restricted to predefined list
|
Restrict Subinventories is set to Subinventories not restricted to predefined list or Stock Locator Control is set to Dynamic entry locator control
|
Restrict Subinventories
|
Subinventories restricted to predefined list
|
Restrict Locators is set to Locators restricted to predefined list
|
Returnable
|
No
|
Contract Item is set to anything other than Subscription
|
Safety Stock Method
|
Non-MRP Planned
|
MRP Planning Method is set to Not Planned
|
Secondary UOM
|
Null
|
UOM Dual Control is set to No Control, or Tracking and Pricing are both set to Primary
|
Serial Number Generation
|
At Receipt or Predefined
|
Equipment is set to Yes or Effectivity Control is set to Model / Unit Number
|
Serial Status Enabled
|
No
|
Serial Control is set to No Control
|
Service Request
|
Null. Disabled, or Inactive
|
Contract Item Type is Service, Warranty, or Usage
|
Service Importance Level
|
Null
|
Contract Item Type is set to Service
|
Serviceable Product
|
No
|
Support Service is set to Yes
|
Shippable
|
No
|
BOM Item Type is set to Planning or Contract Item Type is set to anything other than Subscription
|
Source Organization
|
Null
|
Inventory Planning Method is set to Vendor Managed
|
Source Type
|
Null
|
Inventory Planning Method is set to Vendor Managed
|
Stockable
|
No
|
Inventory Item is set to No
|
Stockable
|
No
|
Billing Type is Labor or Expense
|
Stockable
|
Yes
|
ASL is VMI
|
Stock Locator Control
|
No locator control or Pre- specified locator control
|
Restrict Locators is set to Locators restricted to predefined list
|
Support Service
|
No
|
Serviceable Product is set to Yes
|
Taxable
|
Yes
|
Tax Code is set to anything other than Null
|
Transactable
|
No
|
Stockable is set to No
|
Transactable
|
No
|
Billing Type is Labor or Expense
|
Transactable
|
Yes
|
ASL is VMI
|
Unit Volume
|
Null
|
Volume UOM is Null
|
Unit Weight
|
Null
|
Weight UOM is Null
|
Width
|
Null
|
Dimensions UOM is Null
|
WIP Overcompletion Tolerance Value
|
Null
|
Overcompletion Tolerance Type is set to Null
|
WIP Supply Locator
|
Null
|
On Organization Parameters window, Locator is set to None or Locator controls is Subinventory Level and Selected WIP Supply Subinventory has Locator Control as None or Locator controls is Subinventory Level, Selected WIP Supply Subinventory has Locator Control as Item Level, and Item Locator Control is None.
|
WIP Supply Type
|
Phantom
|
BOM Item Type is set to Option Class
|
Updatable Attributes
You can change the values of some attributes in special cases. The following table shows updatable attributes and the conditions under which you can change their values:
Updatable Attributes
Attribute
|
Updatable
|
If
|
Asset Item Type
|
yes
|
Approved Supplier list does not have the VMI flag enabled or the Consigned Inventory flag deselected.
|
ATP Components
|
from No to Yes
|
Assemble to Order equals Yes or Pick Components equals Yes or WIP Supply Type equals Phantom
|
BOM Item Type
|
No
|
Bill of Material exists or Exists as a component of a BOM or Exists as a substitute component of a standard BOM. Exception: Can change from Product Family for components and substitute components.
|
Costing Enabled
|
Yes
|
No on-hand quantity exists
|
Demand Time Fence Days
|
Yes
|
Demand Time Fence equals User-defined time fence
|
Effectivity Control
|
No
|
If on-hand quantity is greater than 0 or a BOM exists for the item.
|
Inventory Asset Value
|
Yes
|
No on-hand quantity exists
|
Locator Control
|
Yes
|
No on-hand quantity exists
|
Lot Control
|
Yes
|
No on-hand quantity exists
|
OM Indivisible
|
With a warning
|
OM Indivisible is set to No
|
OE Transactable
|
from Yes to No
|
No demand exists
|
Outside Processing Item
|
Yes
|
Approved Supplier list does not have the VMI flag enabled or the Consigned Inventory flag unchecked.
|
Outside Processing Unit
|
Yes
|
Purchasing Item equals Yes
|
Planning Time Fence Days
|
Yes
|
Planning Time Fence equals User-defined time fence
|
Release Time Fence Days
|
Yes
|
Release Time Fence equals User-defined time fence
|
Reservable
|
Yes
|
No reservations exist for the item
|
Repetitive Planning
|
Yes
|
Not scheduled by MRP
|
Reservation Control
|
Yes
|
No demand exists
|
Revision Control
|
Yes
|
No on-hand quantity exists
|
Serial Number Control
|
Yes
|
No on-hand quantity exists
|
Shelf Life Control
|
Yes
|
No on-hand quantity exists
|
Shippable
|
With a warning
|
If open sales order line exists with a value different from the new value
|
Stockable
|
Yes
|
Approved Supplier list does not have the VMI flag enabled or the Consigned Inventory flag deselected.
|
Transactable
|
Yes
|
Approved Supplier list does not have the VMI flag enabled or the Consigned Inventory flag deselected.
|