Previous  Next          Contents  Index  Glossary  Library

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
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 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
Starting Lot Number Lot Control is set to Full lot control
Starting Lot Prefix Lot Control is set to Full lot control
Starting Serial Number Serial Number Control is set to Predefined serial numbers
Starting Serial Prefix Serial Number Control is set to Predefined serial numbers

Interdependent Attributes

Certain attribute values depend on other attribute values. For example, MRP Planning Method must be Not Planned if Pick Components is set to Yes. The attribute interdependences are:

Attribute Must be If
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
ATP Components No Pick Components equals No AND Assemble to Order equals No AND WIP Supply Type is NOT Phantom
Base Model Null BOM Item Type does NOT equal Standard OR Pick Components is set to Yes
BOM Allowed No Inventory Item is set to No
Build in WIP No Inventory Item is set to No OR BOM Item Type does NOT equal Standard
Container Type Null Container is set to No
Costing Enabled Yes Inventory Asset is set to Yes
Customer Ordered No BOM Item Type is set to Planning
Customer Orders Enabled No Customer Ordered is set to No
Demand Time Fence Days null Demand Time Fence is NOT User-defined
Internal Ordered No BOM Item Type does NOT equal Standard
Internal Orders Enabled No Internal Ordered is set to No
Internal Volume Null Container and Vehicle are both set to No
Invoice Enabled No Invoiceable Item is set to No
Lead Time Lot Size 1 Repetitive Planning is set to Yes
Maximum Load Weight Null Container and Vehicle are both set to No
Minimum Fill Percentage Null Container and Vehicle are both set to No
MRP Planning Method Not Planned Pick Components is set to Yes
Pick Components No Assemble to Order is set to Yes OR BOM Item Type is set to Planning OR MRP 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
Postprocessing lead time 0 (Zero) Make or Buy is set to Make
Purchasable No Purchasing Item is set to No
Release Time Fence Days null Release Time Fence is NOT User-defined
Restrict Locators Locators not restricted to predefined list Restrict Subinventories is set to Subinventories not restricted to predefined list
Restrict Locators Locators not restricted to predefined list 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
Serviceable Product No Support Service is set to Yes
Shippable No BOM Item Type is set to Planning
Stockable No Inventory Item is set to No
Stock Locator Control No loc. control OR Pre- specified loc. control Restrict Locators is set to Locators restricted to predefined list
Support Service No Serviceable Product is set to Yes
Transactable No Stockable is set to No

Updatable Attributes

You may 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:

Attribute Updatable If
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
Inventory Asset Value Yes No on-hand quantity exists
Lot Control Yes No on-hand quantity exists
OE Transactable from Yes to No No demand exists
  With a warning If open sales order line exists with a value different from the new value
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
Repetitive Planning Yes Not scheduled by MRP
Reservation Control Yes No demand exists
Revision Control Yes No on-hand quantity exists
  With a warning If open sales order line exists with a value different from the new value
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

Control Level Dependences

You can change the control level of some attributes only in special cases or with certain consequences. The following table shows attributes with conditionally updatable control levels and the consequences of changing the control level.

Attribute Updatable To If Consequences
Item Status Master Level No pending statuses exist in any child org All status attributes under status control or default control are updated
Inventory Asset Value or Costing Enabled Master Level Organization with WIP parameters defined uses itself as the Master org for costing (cannot point to a different org for costing when WIP parameters are defined) --
    Item costs are the same across organizations  
Inventory Asset Value Master or Org Level -- Costing Enabled is updated to the same level
All Item Defining Attributes Org Level Default category set for the functional area is maintained at the Org Level --

See Also

Defining Items

Item Attributes Listed by Group Name

Item Attributes Listed in Alphabetical Order

Overview of Item Setup and Control.


         Previous  Next          Contents  Index  Glossary  Library