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
|