Oracle Field Dependencies

The following table illustrates fields in the Oracle forms which have dependencies on other fields. If all the relevant fields are not included in the Item Wizard worksheet an error will be returned when the concurrent program is run.

When using Item Wizard and trying to change the value of a field in the “Field” column below, you must also include in the worksheet the fields(s) in the “Is dependent on” column.

For example: the ‘Eam Act Notification Flag’ is dependent on the value entered in the ‘Eam Item Type’ field. If you are setting the value for ‘Eam Act Notification Flag’ you must also include a column ‘Eam Item Type’ in the worksheet.

Tab in the Oracle Item Form	Field in the Oracle Item Form	Is dependent on …
AssetManagement	Eam Act Notification Flag	Eam Item Type
AssetManagement	Eam Act Shutdown Status	Eam Item Type
AssetManagement	Eam Activity Cause Code	Eam Item Type
AssetManagement	Eam Activity Source Code	Eam Item Type
AssetManagement	Eam Activity Type Code	Eam Item Type
AssetManagement	Eam Item Type	Organization Code Inventory Item Transactable Effectivity Control Serial Generation Control Track in Installed Base
BOM	Configurator Model Type	BOM Item Type
BOM	Create Configured Item, BOM	BOM Item Type Assemble To Order
BOM	Match Configuration	BOM Item Type Assemble To Order
Costing	Cost of Goods Sold Account	Organization Code
Costing	Material Sub Element	Organization Code
GeneralPlanning	Inventory Planning Method	Pick Components
GeneralPlanning	Maximum Min Max Quantity	Minimum Min Max Quantity
GeneralPlanning	Maximum Order Quantity	Minimum Order Quantity
GeneralPlanning	Planner	Organization Code
GeneralPlanning	Safety Stock Method	MRP Planning Method
GeneralPlanning	Source Organization	Item Number Organization Code Inventory Item Source Type
GeneralPlanning	Source Subinventory	Source Organization Organization Code Inventory Planning Method
Inventory	Check Material Shortage	Transactable
Inventory	Cycle Count Enabled	Contract Item Type
Inventory	Default Lot Status	Lot Status Enabled
Inventory	Default Serial Status	Serial Status Enabled
Inventory	Lot Merge Enabled	Lot Control
Inventory	Lot Split Enabled	Lot Control
Inventory	Lot Starting Prefix	Lot Control Organization Code
Inventory	Lot Status Enabled	Inventory Item
Inventory	Lot Substitution Enabled	Lot Control
Inventory	Lot Translate Enabled	Lot Control
Inventory	Restrict Locators	Restrict Subinventories
Inventory	Serial Generation Control	Inventory Item
Inventory	Serial Starting Number	Serial Generation Control
Inventory	Serial Starting Prefix	Serial Generation Control Organization Code
Inventory	Serial Status Enabled	Serial Generation Control
Inventory	Stockable	Inventory Item
Inventory	Transactable	Stockable
Invoicing	Invoicing Rule	Invoiceable Item
Invoicing	Sales Account	Organization Code
Main	Primary UOM	Item Number
Main	Secondary UOM	Item Number
MPSPlanning	Demand Time Fence Days	Demand Time Fence
MPSPlanning	Planned Time Fence Days	Planning Time Fence
MPSPlanning	Planning Exception Set	Organization Code
MPSPlanning	Release Time Fence Days	Release Time Fence
OrderManagement	Assemble To Order	BOM Item Type Pick Components
OrderManagement	ATP Components	Assemble To Order Pick Components WIP Supply Type
OrderManagement	Check ATP	Contract Item Type
OrderManagement	Customer Ordered	BOM Item Type Configurator Model Type
OrderManagement	Customer Orders Enabled	Customer Ordered
OrderManagement	Default SO Source Type	Ship Model Complete
OrderManagement	Internal Ordered	BOM Item Type
OrderManagement	Internal Orders Enabled	Internal Ordered
OrderManagement	Returnable	Contract Item Type
OrderManagement	Shippable	BOM Item Type Contract Item Class
PhysicalAttribute	Internal Volume	Container Type Vehicle
PhysicalAttribute	Maximum Load Weight	Container Type Vehicle
PhysicalAttribute	Minimum Fill Percent	Container Type
Purchasing	Encumbrance Account	Organization Code
Purchasing	Expense Account	Organization Code Inventory Asset Value Inventory Item
Purchasing	Inspection Required	Receipt Routing
Purchasing	Outside Processing Item	Purchasable
Purchasing	Outside Processing UOM Type	Outside Processing Item
Purchasing	Purchasable	Purchased
Purchasing	Purchasing Tax Code	Taxable
Purchasing	Unit of Issue	Item Number msi.concatenated_segments
WebOption	Orderable On the Web	Customer Orders Enabled
WorkInProgress	Supply Locator	Organization Code Supply Subinventory Subinventory Code
WorkInProgress	Supply SubInventory	Organization Code
WorkInProgress	WIP Supply Type	BOM Item Type