Loading

Monday, June 14, 2010

Item attributes in oracle inventory R12

<<-- Oracle inventory item attributes -->>

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.

In master item form, these attributes are segregated into following 14 tabs,

1.       Main
2.       Inventory
3.       Order Entry
4.       Bills of Material
5.       Costing
6.       Purchasing
7.       Receiving
8.       Physical Attributes
9.       General Planning
10.   MPS/MRP Planning
11.   Lead Times
12.   Work in Process
13.   Invoicing
14.   Service
Out of 14 tabs, I have discussed only about the main and order entry related attributes here.

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.
Ø      his 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.

3 Responses to “Item attributes in oracle inventory R12”

patrick said...
June 14, 2010 at 8:57 AM

Hi team,

it's a good introduction article. is it possible to add more info about other tabs..

THANKS!!!


Inventory Management Software said...
January 10, 2011 at 3:36 AM

I appreciate your post and it was superb .Thanks for sharing.I would like to hear more about this in future.


Anonymous said...
January 18, 2012 at 3:20 AM

Hiii. . 2 all..

I am a new user of oracle inventory and above information help me a lot to understand ATTRIBUTES..

Thanks...


Post a Comment