Oracle Inventory: Item Attributes

Item Attributes

Item attributes are the collection of information about an item.

Item Attribute Group:

•        Main

•        Inventory

•        Bills of Material

•        Costing

•        Asset Management

•        Purchasing

•        Receiving

•        Physical

•        General Planning

•        MPS/MRP

•        Lead times

•        Work In Process

•        Order Management

•        Invoicing

•        Process Manufacturing

•        Service

•        Web Option

Basics of Item Attributes:

1.       Item attributes are fields in the item table used to store specific characteristics of an item, such as item status, unit of measure, revision control, etc…

2.       Attributes can be controlled at either the master or the organization level.

3.       An item has the same value for Attributes that are controlled at the Master level in all organizations in which it is defined.

4.       You can enter and update the values of Master-level attributes only by using the Master Item window. Oracle Inventory reflects your changes in all organizations that carry the item.

5.       An item may have different values for such Attributes that are controlled at the Organization level in each organization in which it is defined.

6.       You can update the values of organization-level attributes only by using the Organization Item window in each organization that carries the item.

7.       These attributes are stored in a table named MTL_ITEM_ATTRIBUTES.

8.       The attributes that are available to the user depend on which Oracle applications are installed. The table MTL_ATTR_APPL_DEPENDENCIES maintains the relationships between items attributes and Oracle applications.

9.       Two units of measure columns are stored in MTL_SYSTEM_ITEMS table.

10.   PRIMARY_UOM_CODE is the 3–character unit that is used throughout Oracle Manufacturing.

11.   PRIMARY_UNIT_OF_MEASURE is the 25–character unit that is used throughout Oracle Purchasing.

Main Attributes

Primary Unit of Measure is the stocking and selling unit of measure

Tracking attribute controls how on-hand balances are tracked

Pricing attribute controls if pricing is based on the primary or secondary unit of measure

Secondary specify the Secondary unit of measure

User Item Type

•        There are several default item types available by installation.

•        We can define our own item types using Item Type Quick Codes window and choose them here.

Item Status:

•        This is the most important attribute as it sets or defaults attributes under the status control Like BOM Allowed, Build in WIP, Customer Orders Enabled, Internal Orders Enabled, Invoice Enabled, Transactable, Purchasable, Stockable.

•        The default item status for new items is defined using the INV:Default Item Status profile option

Order Entry:

Customer Orders:

•        Indicate whether to allow an item to be ordered by external customers.

•        You can add any customer orderable items to price lists in Order Management.

•        This attribute must be turned off if the BOM Item Type attribute is set to Planning.

•        If you turn this attribute on, you can temporarily exclude an item from being ordered by turning Customer Orders Enabled off.

•        This is an item defining attribute.

•        If you turn this attribute on, the item is automatically assigned to the default category set for the Order Management functional area.

Customer Orders Enabled:

•        Indicate whether an item is currently customer orderable.

•        If you turn this attribute on you can specify the item in the Enter Orders window in Order Management.

•        You can initially define an item with Customer Ordered Item turned on and Customer Orders Enabled turned off. This means prices can be defined for the item, but no orders can be placed for it. This attribute is optionally set by the Item Status code.

Shippable:

•        Indicate whether to ship an item to a customer.

•        Shippable items are released by Order Management’s Pick Release program, creating confirmable shipping lines, and are printed on the pick slip.

•        A warning is issued if you change the value of this attribute when open sales order lines exist.

•        For an item to be shippable, it must also be an Inventory Item and Stockable. Both of these attributes are listed on the Inventory Tab.

•        This Shippable attribute must be turned off if the BOM Item Type attribute is set to Planning.

Internal Ordered:

•        Indicate whether to allow an item to be ordered on an internal requisition in Purchasing. These items then are transferred onto an Internal Sales Order in Order Management.

•        If you turn this attribute on, you can temporarily exclude an item from being ordered on an internal requisition by turning Internal Orders Enabled off.

•        This is an item defining attribute. If you turn this attribute on, the item is automatically assigned to the default category set for the Oracle Purchasing functional area.

Internal Orders Enabled:

•        Indicate whether you can currently order an item internally.

•        If you turn Internal Ordered Item on, you can temporarily exclude an item from being ordered on an internal requisition by turning this attribute off.

•        This attribute is optionally set by the Item Status code.

OE Transactable:

•        Indicate whether demand can be placed for an item by Order Management (OM), and whether shipment transactions are interfaced to Inventory.

•        Most items with Shippable turned on also have OM Transactable turned on.

•        For items you do not ship, you may still want OM Transactable turned on if you use the items in forecasting or planning.

•        If you also want to reserve the item, turn Reservable on.

•        A warning is issued if you change the value of this attribute when open sales order lines exist.

•        You cannot turn this attribute off if demand exits.

Default Shipping Organization:

•        Enter the warehouse from which you typically ship this product.

•        This organization can default to the Enter Orders window if Item is the source attribute of the Warehouse object in the standard value rule set for the order.

•        This organization defaults to the Enter Returns window if a receiving warehouse is not defined on the customer or order type.

Picking Rule

•        Enter the picking rule that defines the order in which sub inventories, locators, lots, and revisions are picked.

Pick Components

•        Indicate whether an item has a bill of material with options, classes, or included items picked from finished goods inventory.

•        Pick-to-order items must have this attribute turned on.

•        Assemble-to-order items and items without a bill of material must have this attribute turned off.

Assemble to Order

•        Turn this attribute on if an item is generally built for sales order demand; a final assembly work order is created based on sales order details.

•        An item cannot have Pick Components turned on and this attribute turned on at the same time.

Check ATP

•        Select Check Material Only, Check Material and Resources, Check Resources Only, or None to indicate whether to check available to promise and/or capable to promise information when placing demand.

•        This attribute also determines whether you can view component ATP information for material requirements in Work in Process.

ATP Components

•        Indicate whether to include, in available to promise checking, additional components in the bill of material for ATO and PTO items.

•        These components are included in ATP checking if Check ATP for the component is turned on.

ATP Rule

•        Enter a user-defined available to promise rule. ATP rules define supply and demand sources, time-fence parameters, and available-to-promise calculation methods.

•        You can give ATP rules meaningful names, such as ATO ATP Rule.

•        If there is no ATP rule for the item, the organization’s default ATP rule is used.

Ship Model Complete:

•        Indicate whether any configuration derived from this model can ship only when all required quantities of all configuration components (options or included items) are available.

•        If you turn this attribute on, the Pick Components attribute and the profile option OE: Reservations must be Yes; the BOM Item Type attribute can be Model or Standard.

Returnable:

•        Indicate whether to allow customers to return an item.

•        If an item is returnable, you can enter it on the Returns window in Order Management.

•        Order Management uses this attribute along with Stockable and Transactable to determine which authorized returned items you can physically receive into inventory.

RMA Inspection Required

•        Indicate whether inspection is required for items returned by the customer.

•        The item then must be separately transferred to inventory.

•        Credits are never automatically generated by Order Management for customer return items awaiting inspection.

Over Shipment Tolerance

•        The amount by which you want to allow shipments over the sales order quantity.

•        This is expressed in terms of a percentage.

Under Shipment Tolerance

•        The amount by which you want to allow shipments under the sales order quantity.

•        This is expressed in terms of a percentage.

Over Return Tolerance

•        The amount by which you want to allow returns over the sales order quantity.

•        This is expressed in terms of a percentage.

Under Return Tolerance

•        The amount by which you want to allow returns under the sales order quantity.

•        This is expressed in terms of a percentage.

Financing Allowed

•        Indicate whether a customer can finance this item.

Master Level vs. Organization Level

Item attributes are the collection of information about an item. Using the Item Attribute Controls window, you can designate whether an item attribute is defined/maintained at the Master level or the Organization level. Attributes at the Master level are the same across all organizations, giving you centralized control over the values assigned. If an attribute is maintained at the Organization level, you can have different values in each organization the item is assigned to and therefore have decentralized control over that attribute. 

For example, you can define and maintain an item’s unit of measure at the Master level. This means that the unit of measure is always the same for the item, no matter in which organization you assign the item. Or, you can designate that an item’s unit of measure is maintained at the Organization level. This means that each organization you assign the item to can have a different unit of measure for the item.

Some attributes can be maintained only at one of these levels. The following table lists the attributes that require control at a specific level:

Attribute	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

An item-defining attribute identifies the nature of an item. What designates an item as an engineering item is the attribute Engineering Item, but what controls the functionality of the item is the collection of attributes that describe it. You can buy an engineering item if you want to; set Engineering Item, Purchased, and Purchasable to Yes.

The following table presents 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

When you set an item defining attribute to Yes the item is automatically assigned to the default category set of the corresponding functional area. For example, if you set Inventory Item to Yes the item is automatically assigned to the default category set for the Inventory functional area.

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 attributes: You must enter a value for the attribute based on the settings for other related attributes.

·         Interdependent attributes: You can enter only certain values depending on other attribute values.

·         Updatable attributes: You can update values under certain conditions.

·         Control level dependencies: You can update the control level of some attributes only under special conditions and with certain consequences.

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

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

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.

Oracle Inventory: Item Attributes

Item Attributes

Item attributes are the collection of information about an item.

Item Attribute Group:

•        Main

•        Inventory

•        Bills of Material

•        Costing

•        Asset Management

•        Purchasing

•        Receiving

•        Physical

•        General Planning

•        MPS/MRP

•        Lead times

•        Work In Process

•        Order Management

•        Invoicing

•        Process Manufacturing

•        Service

•        Web Option

Basics of Item Attributes:

1.       Item attributes are fields in the item table used to store specific characteristics of an item, such as item status, unit of measure, revision control, etc…

2.       Attributes can be controlled at either the master or the organization level.

3.       An item has the same value for Attributes that are controlled at the Master level in all organizations in which it is defined.

4.       You can enter and update the values of Master-level attributes only by using the Master Item window. Oracle Inventory reflects your changes in all organizations that carry the item.

5.       An item may have different values for such Attributes that are controlled at the Organization level in each organization in which it is defined.

6.       You can update the values of organization-level attributes only by using the Organization Item window in each organization that carries the item.

7.       These attributes are stored in a table named MTL_ITEM_ATTRIBUTES.

8.       The attributes that are available to the user depend on which Oracle applications are installed. The table MTL_ATTR_APPL_DEPENDENCIES maintains the relationships between items attributes and Oracle applications.

9.       Two units of measure columns are stored in MTL_SYSTEM_ITEMS table.

10.   PRIMARY_UOM_CODE is the 3–character unit that is used throughout Oracle Manufacturing.

11.   PRIMARY_UNIT_OF_MEASURE is the 25–character unit that is used throughout Oracle Purchasing.

Main Attributes

Primary Unit of Measure is the stocking and selling unit of measure

Tracking attribute controls how on-hand balances are tracked

Pricing attribute controls if pricing is based on the primary or secondary unit of measure

Secondary specify the Secondary unit of measure

User Item Type

•        There are several default item types available by installation.

•        We can define our own item types using Item Type Quick Codes window and choose them here.

Item Status:

•        This is the most important attribute as it sets or defaults attributes under the status control Like BOM Allowed, Build in WIP, Customer Orders Enabled, Internal Orders Enabled, Invoice Enabled, Transactable, Purchasable, Stockable.

•        The default item status for new items is defined using the INV:Default Item Status profile option

Order Entry:

Customer Orders:

•        Indicate whether to allow an item to be ordered by external customers.

•        You can add any customer orderable items to price lists in Order Management.

•        This attribute must be turned off if the BOM Item Type attribute is set to Planning.

•        If you turn this attribute on, you can temporarily exclude an item from being ordered by turning Customer Orders Enabled off.

•        This is an item defining attribute.

•        If you turn this attribute on, the item is automatically assigned to the default category set for the Order Management functional area.

Customer Orders Enabled:

•        Indicate whether an item is currently customer orderable.

•        If you turn this attribute on you can specify the item in the Enter Orders window in Order Management.

•        You can initially define an item with Customer Ordered Item turned on and Customer Orders Enabled turned off. This means prices can be defined for the item, but no orders can be placed for it. This attribute is optionally set by the Item Status code.

Shippable:

•        Indicate whether to ship an item to a customer.

•        Shippable items are released by Order Management’s Pick Release program, creating confirmable shipping lines, and are printed on the pick slip.

•        A warning is issued if you change the value of this attribute when open sales order lines exist.

•        For an item to be shippable, it must also be an Inventory Item and Stockable. Both of these attributes are listed on the Inventory Tab.

•        This Shippable attribute must be turned off if the BOM Item Type attribute is set to Planning.

Internal Ordered:

•        Indicate whether to allow an item to be ordered on an internal requisition in Purchasing. These items then are transferred onto an Internal Sales Order in Order Management.

•        If you turn this attribute on, you can temporarily exclude an item from being ordered on an internal requisition by turning Internal Orders Enabled off.

•        This is an item defining attribute. If you turn this attribute on, the item is automatically assigned to the default category set for the Oracle Purchasing functional area.

Internal Orders Enabled:

•        Indicate whether you can currently order an item internally.

•        If you turn Internal Ordered Item on, you can temporarily exclude an item from being ordered on an internal requisition by turning this attribute off.

•        This attribute is optionally set by the Item Status code.

OE Transactable:

•        Indicate whether demand can be placed for an item by Order Management (OM), and whether shipment transactions are interfaced to Inventory.

•        Most items with Shippable turned on also have OM Transactable turned on.

•        For items you do not ship, you may still want OM Transactable turned on if you use the items in forecasting or planning.

•        If you also want to reserve the item, turn Reservable on.

•        A warning is issued if you change the value of this attribute when open sales order lines exist.

•        You cannot turn this attribute off if demand exits.

Default Shipping Organization:

•        Enter the warehouse from which you typically ship this product.

•        This organization can default to the Enter Orders window if Item is the source attribute of the Warehouse object in the standard value rule set for the order.

•        This organization defaults to the Enter Returns window if a receiving warehouse is not defined on the customer or order type.

Picking Rule

•        Enter the picking rule that defines the order in which sub inventories, locators, lots, and revisions are picked.

Pick Components

•        Indicate whether an item has a bill of material with options, classes, or included items picked from finished goods inventory.

•        Pick-to-order items must have this attribute turned on.

•        Assemble-to-order items and items without a bill of material must have this attribute turned off.

Assemble to Order

•        Turn this attribute on if an item is generally built for sales order demand; a final assembly work order is created based on sales order details.

•        An item cannot have Pick Components turned on and this attribute turned on at the same time.

Check ATP

•        Select Check Material Only, Check Material and Resources, Check Resources Only, or None to indicate whether to check available to promise and/or capable to promise information when placing demand.

•        This attribute also determines whether you can view component ATP information for material requirements in Work in Process.

ATP Components

•        Indicate whether to include, in available to promise checking, additional components in the bill of material for ATO and PTO items.

•        These components are included in ATP checking if Check ATP for the component is turned on.

ATP Rule

•        Enter a user-defined available to promise rule. ATP rules define supply and demand sources, time-fence parameters, and available-to-promise calculation methods.

•        You can give ATP rules meaningful names, such as ATO ATP Rule.

•        If there is no ATP rule for the item, the organization’s default ATP rule is used.

Ship Model Complete:

•        Indicate whether any configuration derived from this model can ship only when all required quantities of all configuration components (options or included items) are available.

•        If you turn this attribute on, the Pick Components attribute and the profile option OE: Reservations must be Yes; the BOM Item Type attribute can be Model or Standard.

Returnable:

•        Indicate whether to allow customers to return an item.

•        If an item is returnable, you can enter it on the Returns window in Order Management.

•        Order Management uses this attribute along with Stockable and Transactable to determine which authorized returned items you can physically receive into inventory.

RMA Inspection Required

•        Indicate whether inspection is required for items returned by the customer.

•        The item then must be separately transferred to inventory.

•        Credits are never automatically generated by Order Management for customer return items awaiting inspection.

Over Shipment Tolerance

•        The amount by which you want to allow shipments over the sales order quantity.

•        This is expressed in terms of a percentage.

Under Shipment Tolerance

•        The amount by which you want to allow shipments under the sales order quantity.

•        This is expressed in terms of a percentage.

Over Return Tolerance

•        The amount by which you want to allow returns over the sales order quantity.

•        This is expressed in terms of a percentage.

Under Return Tolerance

•        The amount by which you want to allow returns under the sales order quantity.

•        This is expressed in terms of a percentage.

Financing Allowed

•        Indicate whether a customer can finance this item.

Master Level vs. Organization Level

Item attributes are the collection of information about an item. Using the Item Attribute Controls window, you can designate whether an item attribute is defined/maintained at the Master level or the Organization level. Attributes at the Master level are the same across all organizations, giving you centralized control over the values assigned. If an attribute is maintained at the Organization level, you can have different values in each organization the item is assigned to and therefore have decentralized control over that attribute. 

For example, you can define and maintain an item’s unit of measure at the Master level. This means that the unit of measure is always the same for the item, no matter in which organization you assign the item. Or, you can designate that an item’s unit of measure is maintained at the Organization level. This means that each organization you assign the item to can have a different unit of measure for the item.

Some attributes can be maintained only at one of these levels. The following table lists the attributes that require control at a specific level:

Attribute	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

An item-defining attribute identifies the nature of an item. What designates an item as an engineering item is the attribute Engineering Item, but what controls the functionality of the item is the collection of attributes that describe it. You can buy an engineering item if you want to; set Engineering Item, Purchased, and Purchasable to Yes.

The following table presents 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

When you set an item defining attribute to Yes the item is automatically assigned to the default category set of the corresponding functional area. For example, if you set Inventory Item to Yes the item is automatically assigned to the default category set for the Inventory functional area.

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 attributes: You must enter a value for the attribute based on the settings for other related attributes.

·         Interdependent attributes: You can enter only certain values depending on other attribute values.

·         Updatable attributes: You can update values under certain conditions.

·         Control level dependencies: You can update the control level of some attributes only under special conditions and with certain consequences.

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

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

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.

Oracle Inventory : Item

Item

An item is a part or services we can

•        Purchase

•        Sell

•        Plan

•        Manufacture

•        Stock

•        Distribute

•        Prototype

Items can also be containers for items as well as components you build into other items.

Steps to Set Up, Define, and Maintain Items

The following are the steps for creating and maintaining items:

•        Define Inventory organization.

•        Create the item templates.

•        Use the templates or existing items to define items.

•        Enter values for additional item attributes.

•        Assign a status to the item.

•        Enable the item in organizations.

•        Update the organizational-level attributes values.

•        Assign categories to the item (optional)

•        Assign items to catalog groups (optional)

•        Define item relationships (optional)

•        Delete items (optional)

Define only the information you need to maintain the item. You cannot define an item at the organization level. Oracle Inventory automatically switches to the Master Item window when you define a new item.

Item Master Organization

An item master organization is a logical entity that you use to define items. You use the other organizations to store and transact inventory. After you define an item in the item master, you can assign it to any number of other organizations.

There is no functional or technical difference between the item master organization and other organizations; however, it is recommended that you limit the item master to an item definition organization.

You should also define one item master organization per implementation. You can use the same item master for child organizations across different ledgers. Item masters are distinct entities with no relationship to each other. You cannot associate items in one item master organization with another item master organization. You cannot copy items across item master organizations.

Defining the Item Master Organization

You create the item master organization in the same way that you create other inventory organizations.

•        You use the Organization window to create the item master organization.

•        Use the Organization Parameters window to specify the organization as the Item Master.

•        You assign child organizations to the item master organization

Note: The item master uses itself as its item master

Item Master

Always define items in the master organization. When you define an item, Oracle automatically changes your current organization to the master organization. You may enable your new items in as many child organizations as needed.

Item Attributes

Item attributes are the collection of information about an item.

Item Attribute Group:

•        Main

•        Inventory

•        Bills of Material

•        Costing

•        Asset Management

•        Purchasing

•        Receiving

•        Physical

•        General Planning

•        MPS/MRP

•        Lead times

•        Work In Process

•        Order Management

•        Invoicing

•        Process Manufacturing

•        Service

•        Web Option

Oracle Inventory : Item

Item

An item is a part or services we can

•        Purchase

•        Sell

•        Plan

•        Manufacture

•        Stock

•        Distribute

•        Prototype

Items can also be containers for items as well as components you build into other items.

Steps to Set Up, Define, and Maintain Items

The following are the steps for creating and maintaining items:

•        Define Inventory organization.

•        Create the item templates.

•        Use the templates or existing items to define items.

•        Enter values for additional item attributes.

•        Assign a status to the item.

•        Enable the item in organizations.

•        Update the organizational-level attributes values.

•        Assign categories to the item (optional)

•        Assign items to catalog groups (optional)

•        Define item relationships (optional)

•        Delete items (optional)

Define only the information you need to maintain the item. You cannot define an item at the organization level. Oracle Inventory automatically switches to the Master Item window when you define a new item.

Item Master Organization

An item master organization is a logical entity that you use to define items. You use the other organizations to store and transact inventory. After you define an item in the item master, you can assign it to any number of other organizations.

There is no functional or technical difference between the item master organization and other organizations; however, it is recommended that you limit the item master to an item definition organization.

You should also define one item master organization per implementation. You can use the same item master for child organizations across different ledgers. Item masters are distinct entities with no relationship to each other. You cannot associate items in one item master organization with another item master organization. You cannot copy items across item master organizations.

Defining the Item Master Organization

You create the item master organization in the same way that you create other inventory organizations.

•        You use the Organization window to create the item master organization.

•        Use the Organization Parameters window to specify the organization as the Item Master.

•        You assign child organizations to the item master organization

Note: The item master uses itself as its item master

Item Master

Always define items in the master organization. When you define an item, Oracle automatically changes your current organization to the master organization. You may enable your new items in as many child organizations as needed.

Item Attributes

Item attributes are the collection of information about an item.

Item Attribute Group:

•        Main

•        Inventory

•        Bills of Material

•        Costing

•        Asset Management

•        Purchasing

•        Receiving

•        Physical

•        General Planning

•        MPS/MRP

•        Lead times

•        Work In Process

•        Order Management

•        Invoicing

•        Process Manufacturing

•        Service

•        Web Option

Oracle Inventory Unit Of Measure Implementation

Units of Measure

Oracle Inventory provides you with powerful methods for defining and manipulating units of measure. You can easily convert between the units of measure you define. This enables you to manufacture, order, or receive items in any unit of measure. With units of measure you can:

1. Define unit of measure classes,
2. Define units of measure,
3. Define unit of measure conversions,
4. Define lot-specific unit of measure conversions

Defining Unit of Measure Classes
Unit of measure classes represent groups of units of measure with similar characteristics.

• Creating unit of measure classes is the first step in unit of measure management. Each unit of measure you define must belong to a unit of measure class.
• Each class has a base unit of measure. The base unit of measure is used to perform conversions between units of measure in the class. For this reason, the base unit of measure should be representative of the other units of measure in the class, and generally one of the smaller units. For example, you could use CU (cubic feet) as the base unit of a class called Volume.
• Unit of measure classes are not organization-specific. Default unit of measure classes are not provided.

1. Enter a unique name for the unit of measure class.

2. Define the base unit of measure for this class.
3. Define a unique abbreviation for the base unit of measure.

Defining Units of Measure

Units of measure are used by a variety of functions and transactions to express the quantity of items.

• Defining units of measure is the second step in unit of measure management.
• The values defined in the Units of Measure window provide the list of values available in unit of measure fields in other windows.
• Units of measure are not organization-specific.

Primary Unit of Measure
Theprimary unit of measure is the stocking unit of measure for an item in a particular organization. The primary unit of measure is an item attribute that you specify when defining each item.

Prerequisites
You must define at least one unit of measure class.

Enter UOM from UOM Class FORM

After defining the UOM class click on Uint of measure button to enter a new UOM.
Enter the UOM namd and short name. Save the form

Define a UOM in UOM form
Navigate to the Units of Measure window.

1. Enter a unique name for the unit of measure.
2. Enter a unique abbreviation for the unit of measure with a maximum length of three characters.
For example, EA for each or HRS for hours.
3. Enter a unit of measure class.
4. Indicate if this is the base unit of measure for the unit of measure class.

To delete a unit of measure:
1. You can delete existing units of measure that are not base units of measure if no standard or item specific conversions are defined.

To make a unit of measure inactive:
1. Enter the date on which the unit of measure becomes inactive. As of this date, you can no longer assign standard or item-specific conversions to the unit of measure.

To change Base UOM:
Its not possible to change the base UOM from one UOM to another UOM

Defining Unit of Measure Conversions

Unit of measure conversions are numerical factors that enable you to perform transactions in units other than the primary unit of the item being transacted. You can define:

A conversion common to any item (Standard)
A conversion for a specific item within a unit of measure class (Intra-class)
A conversion for a specific item between unit of measure classes (Inter-class)

• Unit of measure conversions are not organization-specific.
• You must define a conversion between a non-base unit of measure and the base unit of measure before you can assign the non-base unit of measure to an item

Specifying Which Conversion to Use
When you define an item you decide which type of unit of measure conversion to use:

1. Itemspecific: Only uses unit of measure conversions unique to this item. If none exist, you can only transact this item in its primary unit of measure.
2. Standard: Uses standard unit of measure conversions for this item if an item-specific conversion is not available.
3. Both: Uses both item-specific and standard unit of measure conversions. If both exist for the same unit of measure and item combination, the item-specific conversion is used.

Unit of Measure Conversions During Transactions
Whenever you enter an item’s quantity, the default is the primary unit of measure for the item. The list of values for the unit of measure field displays all units of measure for which you have defined standard and/or item-specific conversions from the primary unit of measure.
Transactions are performed in the unit of measure you specify. The conversion happens automatically and item quantities are updated in the primary unit of measure of the item.

Important: Inventory transactions and on hand balance supports decimal precision to 5 digits after the decimal point. Oracle Work in Process supports decimal precision to 6 digits. Other Oracle Applications support different decimal precision. As a result of the decimal precision mismatch, transactions another Oracle Application passes may be rounded when processed by Inventory. If the transaction quantity is rounded to zero, Inventory does not process the transaction.
It is therefore suggested that the base unit of measure for an item is set up such that transaction quantities in the base unit of measure not require greater than 5 digits of decimal precision.

Define a Standard conversion for any item
In standrad conversion you specify how one unit of mesaure is related to the primary unit of measure in the same class.
In standrad conversion you cant do the following
You cant specify any sort of intra class conversion
Relationship between two UOMs not invloving primary UOM

Navigate to the Unit of Measure Conversions window  & Select the Standard tabbed region.

1 Enter a unit of measure.
2 Enter the conversion factor by which the unit of measure is equivalent to the base unit of measure established for this class.
For example, if one DZ (this unit of measure) is equivalent to 12 EA (base unit), the conversion factor is 12. Or, if EA is equal to one-twelfth of a DZ, the conversion factor is 0.08333.

Define a conversion for a specific item within a unit of measure class (Intra-class)
We have seen in standard conversion we can only do convesrion from one UOM to primary UOM.
Suppose we have defined a UOM convsrion rule for a unit of measure UOM_XYZ as UOM_XYZ = 6 x Primary UOM but for a particular item the vonvsrion rate is not 6 in that case we define a intra class convesrion for  a particular item and when ever that item is transacted system ‘ll pick the convesrion rate from either intra class or standrad convesrion depending upon ITEM master set up.
Notes
We can do intra class conversion between two UOMs for a particular item only for a single class which is the UOM class of the primary UOM of the item.
For exampe Suppose ITEM001 has a primary UOM as Ea and UOM Ea belongs to class Quantity then we can define intra class conversion for the item ITEM001 between two UOMs in the class Quantity.
we cant define intra class convesrion between any other UOMs belonging to a differnt UOM class.

Navigate to the Unit of Measure Conversions window.

1. Select the Intra-class tabbed region.
2. Enter an item.
3. Enter a unit of measure.
4. Enter the conversion factor by which the unit of measure is equivalent to the base unit of measure established for this class.
For example, if one LB (this unit of measure) is equivalent to 16 OZ (base unit), the conversion factor is 16.

Define a conversion for a specific item between unit of measure classes (Inter-class)
Inter class conversion is used to convert an item from one primary UOM in one class to another primary UOM in a differnt class for a particular item.

Navigate to the Unit of Measure Conversions window and Select the Inter-class tabbed region

1. Select an item.
2. Select the destination base unit of measure of the class to which you are converting a unit of measure.
3. Enter the conversion factor by which the source base unit is equivalent to the destination base unit.
For example, if one ML (source base unit) is equivalent to one GR (destination base unit), the conversion factor is one.

Lot-Specific Unit of Measure Conversions

Lot specific conversions enable you to perform a specific inter-class conversion for a given lot. This enables you to establish more granular control over the transactional quantities of a lot. For example, the standard inter-class conversion for a lot controlled item is one gallon equals 15 pounds; however, when you receive a particular lot of the item, 1 gallon equals 16 pounds. You can create a lot specific unit of measure for this instance.

You can create lot-specific unit of measure conversions for on-hand lots or lots with a zero balance. If you create a lot-specific conversion for a lot with on-hand quantities, you can automatically update the quantities in the system to more accurately reflect the on-hand quantity.

You can also view the history of changes made to the lot unit of measure conversion, and the corresponding quantity changes.

1. Enter the item number in the Item field.
2. Enter the lot number in the Lot Number field.
3. Select the destination base unit of measure of the class to which you are converting the unit of measure.
4. Enter the conversion factor by which the source base unit is equivalent to the destination base unit.
For example, if 16 pounds (source base unit) is equivalent to 1 Gallon (destination base unit), the conversion factor is 16.
5. Optionally, enter an inactive date for the conversion. This is the date when the unit of measure conversion for the lot reverts back to the standard inter-class conversion.
6. Optionally, enter a transaction reason for the conversion.

Oracle Inventory Unit Of Measure Implementation

Units of Measure

Oracle Inventory provides you with powerful methods for defining and manipulating units of measure. You can easily convert between the units of measure you define. This enables you to manufacture, order, or receive items in any unit of measure. With units of measure you can:

1. Define unit of measure classes,
2. Define units of measure,
3. Define unit of measure conversions,
4. Define lot-specific unit of measure conversions

Defining Unit of Measure Classes
Unit of measure classes represent groups of units of measure with similar characteristics.

• Creating unit of measure classes is the first step in unit of measure management. Each unit of measure you define must belong to a unit of measure class.
• Each class has a base unit of measure. The base unit of measure is used to perform conversions between units of measure in the class. For this reason, the base unit of measure should be representative of the other units of measure in the class, and generally one of the smaller units. For example, you could use CU (cubic feet) as the base unit of a class called Volume.
• Unit of measure classes are not organization-specific. Default unit of measure classes are not provided.

1. Enter a unique name for the unit of measure class.

2. Define the base unit of measure for this class.
3. Define a unique abbreviation for the base unit of measure.

Defining Units of Measure

Units of measure are used by a variety of functions and transactions to express the quantity of items.

• Defining units of measure is the second step in unit of measure management.
• The values defined in the Units of Measure window provide the list of values available in unit of measure fields in other windows.
• Units of measure are not organization-specific.

Primary Unit of Measure
Theprimary unit of measure is the stocking unit of measure for an item in a particular organization. The primary unit of measure is an item attribute that you specify when defining each item.

Prerequisites
You must define at least one unit of measure class.

Enter UOM from UOM Class FORM

After defining the UOM class click on Uint of measure button to enter a new UOM.
Enter the UOM namd and short name. Save the form

Define a UOM in UOM form
Navigate to the Units of Measure window.

1. Enter a unique name for the unit of measure.
2. Enter a unique abbreviation for the unit of measure with a maximum length of three characters.
For example, EA for each or HRS for hours.
3. Enter a unit of measure class.
4. Indicate if this is the base unit of measure for the unit of measure class.

To delete a unit of measure:
1. You can delete existing units of measure that are not base units of measure if no standard or item specific conversions are defined.

To make a unit of measure inactive:
1. Enter the date on which the unit of measure becomes inactive. As of this date, you can no longer assign standard or item-specific conversions to the unit of measure.

To change Base UOM:
Its not possible to change the base UOM from one UOM to another UOM

Defining Unit of Measure Conversions

Unit of measure conversions are numerical factors that enable you to perform transactions in units other than the primary unit of the item being transacted. You can define:

A conversion common to any item (Standard)
A conversion for a specific item within a unit of measure class (Intra-class)
A conversion for a specific item between unit of measure classes (Inter-class)

• Unit of measure conversions are not organization-specific.
• You must define a conversion between a non-base unit of measure and the base unit of measure before you can assign the non-base unit of measure to an item

Specifying Which Conversion to Use
When you define an item you decide which type of unit of measure conversion to use:

1. Itemspecific: Only uses unit of measure conversions unique to this item. If none exist, you can only transact this item in its primary unit of measure.
2. Standard: Uses standard unit of measure conversions for this item if an item-specific conversion is not available.
3. Both: Uses both item-specific and standard unit of measure conversions. If both exist for the same unit of measure and item combination, the item-specific conversion is used.

Unit of Measure Conversions During Transactions
Whenever you enter an item’s quantity, the default is the primary unit of measure for the item. The list of values for the unit of measure field displays all units of measure for which you have defined standard and/or item-specific conversions from the primary unit of measure.
Transactions are performed in the unit of measure you specify. The conversion happens automatically and item quantities are updated in the primary unit of measure of the item.

Important: Inventory transactions and on hand balance supports decimal precision to 5 digits after the decimal point. Oracle Work in Process supports decimal precision to 6 digits. Other Oracle Applications support different decimal precision. As a result of the decimal precision mismatch, transactions another Oracle Application passes may be rounded when processed by Inventory. If the transaction quantity is rounded to zero, Inventory does not process the transaction.
It is therefore suggested that the base unit of measure for an item is set up such that transaction quantities in the base unit of measure not require greater than 5 digits of decimal precision.

Define a Standard conversion for any item
In standrad conversion you specify how one unit of mesaure is related to the primary unit of measure in the same class.
In standrad conversion you cant do the following
You cant specify any sort of intra class conversion
Relationship between two UOMs not invloving primary UOM

Navigate to the Unit of Measure Conversions window  & Select the Standard tabbed region.

1 Enter a unit of measure.
2 Enter the conversion factor by which the unit of measure is equivalent to the base unit of measure established for this class.
For example, if one DZ (this unit of measure) is equivalent to 12 EA (base unit), the conversion factor is 12. Or, if EA is equal to one-twelfth of a DZ, the conversion factor is 0.08333.

Define a conversion for a specific item within a unit of measure class (Intra-class)
We have seen in standard conversion we can only do convesrion from one UOM to primary UOM.
Suppose we have defined a UOM convsrion rule for a unit of measure UOM_XYZ as UOM_XYZ = 6 x Primary UOM but for a particular item the vonvsrion rate is not 6 in that case we define a intra class convesrion for  a particular item and when ever that item is transacted system ‘ll pick the convesrion rate from either intra class or standrad convesrion depending upon ITEM master set up.
Notes
We can do intra class conversion between two UOMs for a particular item only for a single class which is the UOM class of the primary UOM of the item.
For exampe Suppose ITEM001 has a primary UOM as Ea and UOM Ea belongs to class Quantity then we can define intra class conversion for the item ITEM001 between two UOMs in the class Quantity.
we cant define intra class convesrion between any other UOMs belonging to a differnt UOM class.

Navigate to the Unit of Measure Conversions window.

1. Select the Intra-class tabbed region.
2. Enter an item.
3. Enter a unit of measure.
4. Enter the conversion factor by which the unit of measure is equivalent to the base unit of measure established for this class.
For example, if one LB (this unit of measure) is equivalent to 16 OZ (base unit), the conversion factor is 16.

Define a conversion for a specific item between unit of measure classes (Inter-class)
Inter class conversion is used to convert an item from one primary UOM in one class to another primary UOM in a differnt class for a particular item.

Navigate to the Unit of Measure Conversions window and Select the Inter-class tabbed region

1. Select an item.
2. Select the destination base unit of measure of the class to which you are converting a unit of measure.
3. Enter the conversion factor by which the source base unit is equivalent to the destination base unit.
For example, if one ML (source base unit) is equivalent to one GR (destination base unit), the conversion factor is one.

Lot-Specific Unit of Measure Conversions

Lot specific conversions enable you to perform a specific inter-class conversion for a given lot. This enables you to establish more granular control over the transactional quantities of a lot. For example, the standard inter-class conversion for a lot controlled item is one gallon equals 15 pounds; however, when you receive a particular lot of the item, 1 gallon equals 16 pounds. You can create a lot specific unit of measure for this instance.

You can create lot-specific unit of measure conversions for on-hand lots or lots with a zero balance. If you create a lot-specific conversion for a lot with on-hand quantities, you can automatically update the quantities in the system to more accurately reflect the on-hand quantity.

You can also view the history of changes made to the lot unit of measure conversion, and the corresponding quantity changes.

1. Enter the item number in the Item field.
2. Enter the lot number in the Lot Number field.
3. Select the destination base unit of measure of the class to which you are converting the unit of measure.
4. Enter the conversion factor by which the source base unit is equivalent to the destination base unit.
For example, if 16 pounds (source base unit) is equivalent to 1 Gallon (destination base unit), the conversion factor is 16.
5. Optionally, enter an inactive date for the conversion. This is the date when the unit of measure conversion for the lot reverts back to the standard inter-class conversion.
6. Optionally, enter a transaction reason for the conversion.

Oracle Inventory: Units of Measure

Unit of Measure (UOM)

A Unit of measure is a value that specifies the quantity of an item.

We define unit of measure for tracking, moving, storing and counting items.

Primary Unit of measure: This is the UOM which can be used for tracking, counting the onhand quantities and to calculate during any transactions.

Secondary Unit of Measure: If business needs to track any item in dual unit of measure, then we need to define a secondary UOM for the item if there is no constant conversion available with the primary UOM. For example, in a cake shop cakes can be measured as Each and Pounds and here constant conversion not possible.

If an item is under dual unit of measure control the system tracks on-hand quantity based on both the primary and secondary units of measure. For example, you can track an item in both each and liter.

Uses of Unit of Measure

·         Planning Products

o   Forecasting and consumption

o   Master scheduling

o   Material requirements planning

·         Work in Process

o   Shop floor moves

o   Resource transaction

o   Completion and return transactions

o   Inquiries and reports

·         Bills of Material and Engineering

o   Defining bills of material

o   Defining engineering items

Unit of Measure Class

Unit of measure classes represent groups of units of measure with similar characteristics. A unit of measure class contains a base unit of measure. You use the base unit of measure to perform conversions between units of measure in the class. For this reason, the base unit of measure should represent the other units of measure in the class, and be one of the smaller units. For example, quantity is a unit of measure class and each, dozen, and gross are examples of units of measure within the class. The unit of measure each is the base unit of measure for this class. 

Units of Measure Conversions

A unit of measure conversion is a mathematical relationship between two different units of measure. For example, 16 ounces = 1 pound, or 2.2 pounds = 1 kilogram. If you want to transact items in units of measure belonging to classes other than their primary UOM class, you must define conversions between the base units of measure in different UOM classes.

Lot-Level Unit of Measure Conversions

Lot specific conversions enable you to perform a specific inter-class conversion for a given lot. This enables you to establish more granular control over the transactional quantities of a lot. For example, the standard inter-class conversion for a lot controlled item is one gallon equals 15 pounds; however, when you receive a particular lot of the item, 1 gallon equals 16 pounds. You can create a lot specific unit of measure for this instance.

You can create lot-specific unit of measure conversions for on-hand lots or lots with a zero balance. If you create a lot-specific conversion for a lot with on-hand quantities, you can automatically update the quantities in the system to more accurately reflect the on-hand quantity.

Oracle Inventory: Units of Measure

Unit of Measure (UOM)

A Unit of measure is a value that specifies the quantity of an item.

We define unit of measure for tracking, moving, storing and counting items.

Primary Unit of measure: This is the UOM which can be used for tracking, counting the onhand quantities and to calculate during any transactions.

Secondary Unit of Measure: If business needs to track any item in dual unit of measure, then we need to define a secondary UOM for the item if there is no constant conversion available with the primary UOM. For example, in a cake shop cakes can be measured as Each and Pounds and here constant conversion not possible.

If an item is under dual unit of measure control the system tracks on-hand quantity based on both the primary and secondary units of measure. For example, you can track an item in both each and liter.

Uses of Unit of Measure

·         Planning Products

o   Forecasting and consumption

o   Master scheduling

o   Material requirements planning

·         Work in Process

o   Shop floor moves

o   Resource transaction

o   Completion and return transactions

o   Inquiries and reports

·         Bills of Material and Engineering

o   Defining bills of material

o   Defining engineering items

Unit of Measure Class

Unit of measure classes represent groups of units of measure with similar characteristics. A unit of measure class contains a base unit of measure. You use the base unit of measure to perform conversions between units of measure in the class. For this reason, the base unit of measure should represent the other units of measure in the class, and be one of the smaller units. For example, quantity is a unit of measure class and each, dozen, and gross are examples of units of measure within the class. The unit of measure each is the base unit of measure for this class. 

Units of Measure Conversions

A unit of measure conversion is a mathematical relationship between two different units of measure. For example, 16 ounces = 1 pound, or 2.2 pounds = 1 kilogram. If you want to transact items in units of measure belonging to classes other than their primary UOM class, you must define conversions between the base units of measure in different UOM classes.

Lot-Level Unit of Measure Conversions

Lot specific conversions enable you to perform a specific inter-class conversion for a given lot. This enables you to establish more granular control over the transactional quantities of a lot. For example, the standard inter-class conversion for a lot controlled item is one gallon equals 15 pounds; however, when you receive a particular lot of the item, 1 gallon equals 16 pounds. You can create a lot specific unit of measure for this instance.

You can create lot-specific unit of measure conversions for on-hand lots or lots with a zero balance. If you create a lot-specific conversion for a lot with on-hand quantities, you can automatically update the quantities in the system to more accurately reflect the on-hand quantity.

Oracle Inventory: Implementation Considerations

Implementation Considerations

Few question need to be answered before going to implement Oracle Inventory

When you set up your organizations you need to determine the organization type. For example, you need to determine if the organization is a process or a discrete organization and if you are using Oracle Warehouse Management. You can use Oracle Warehouse Management and Oracle Process Management in the same organization. You should not however, use Oracle Asset Management with Oracle Warehouse Management or Oracle Process Execution. If you plan on using Oracle Warehouse Management you need to determine if you are going to use the Warehouse Control system. If this organization transacts business with Japan, Taiwan, or Korea you can enable Chargeable Subcontracting for the organization. You must consider all of this information before you create items or process transactions.

Subinventories:

·         Is it necessary to differentiate between receiving and storage subinventories in your warehouse?

·         Do you need to link your receipts to a receiving location?

·         Do you need to track material without it appearing in on-hand quantity?

Locator Control:

·         Do you need to implement locator Control?

·         Do you need to implement locator control for the organization, for individual subinventories or at the item level?

·         Should locator control be predefined, just-in-time or both?

Organization Access:

·         Should all responsibilities have access to the organization?

·         Which responsibilities should have the access to the organization?

Shipping Network:

·         Do you need to ship material between organizations?

·         Do you need to track inventory between transfers?

·         How do you want to ship material between organizations?

·         Do you Ship material to Japan, Korea or Taiwan?

·         Who owns the material until receipt, shipping organization or receiving organization?

·         Which receipt routing do you use, Standard, Direct or Inspection?

·         Is an internal order required for each shipment?

Oracle Inventory: Implementation Considerations

Implementation Considerations

Few question need to be answered before going to implement Oracle Inventory

When you set up your organizations you need to determine the organization type. For example, you need to determine if the organization is a process or a discrete organization and if you are using Oracle Warehouse Management. You can use Oracle Warehouse Management and Oracle Process Management in the same organization. You should not however, use Oracle Asset Management with Oracle Warehouse Management or Oracle Process Execution. If you plan on using Oracle Warehouse Management you need to determine if you are going to use the Warehouse Control system. If this organization transacts business with Japan, Taiwan, or Korea you can enable Chargeable Subcontracting for the organization. You must consider all of this information before you create items or process transactions.

Subinventories:

·         Is it necessary to differentiate between receiving and storage subinventories in your warehouse?

·         Do you need to link your receipts to a receiving location?

·         Do you need to track material without it appearing in on-hand quantity?

Locator Control:

·         Do you need to implement locator Control?

·         Do you need to implement locator control for the organization, for individual subinventories or at the item level?

·         Should locator control be predefined, just-in-time or both?

Organization Access:

·         Should all responsibilities have access to the organization?

·         Which responsibilities should have the access to the organization?

Shipping Network:

·         Do you need to ship material between organizations?

·         Do you need to track inventory between transfers?

·         How do you want to ship material between organizations?

·         Do you Ship material to Japan, Korea or Taiwan?

·         Who owns the material until receipt, shipping organization or receiving organization?

·         Which receipt routing do you use, Standard, Direct or Inspection?

·         Is an internal order required for each shipment?