03 August 2007

Basic Concepts in Oracle Inventory - Part3


ITEM definition


You define items in one organization. To distinguish it from others, we call it the Item Master organization. Other organizations (child organizations) refer to the Item Master for item definition. After you define an item in the Item Master, you can assign it to any number of other organizations.

Item attributes


    • inventory attributes like lot control/ serial control

    • Purchasing and costing information.

    • bill of material/ item category attributes

    • Physical attributes like weight, volume

    • Receiving attributes

    • General planning attributes like min-max qty, order qty.

    • Status of item

Generally we will group the item attributes in these groups -


Main

Inventory

Bill of material

Asset management

Costing

Purchasing

Receiving

Physical attributes

General planning

MPS/MRP planning

Lead times

Work In Process

Order Management

Invoicing

Service


Now we will discuss main attributes from major group.


Main attribute group



Primary Unit of Measure-


This is the stocking and selling unit of measure. Any necessary conversions are based on this unit of measure. This attribute is not updatable.

The default primary unit of measure for new items is defined using the INV: Default Primary Unit of Measure profile option.


User Item Type-


Oracle provides several types by default at installation. These types correspond to the item templates also provided. Select one of these values, or one you defined with the Item Type window.

Different item types are ATO model/ Finished good/ Freight/ Inventory Type etc.


Item Status-


Item status codes set or default the values for attributes under status control. User–defined status codes control certain item attributes designated as status attributes.

Item status can be active/engineer/inactive.

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


Inventory Attribute Group






Inventory Item-

Indicate whether to stock and transact this item in Oracle Inventory.


Stockable-

Indicate whether to stock this item in Inventory. You can set this attribute only when you turn on the Inventory Item option.


Transactable –

Indicate whether to allow Inventory transactions. You can set this attribute only when you turn on the Stockable option.


Reservable-

Indicate whether you can create material reservations. You can reserve an item only when you have sufficient inventory.


Other attribute in this group are Lot control, serial control, locator control.



Bill of Material attribute group






BOM allowed-

Allows you to define a bill of material for an item, or to assign the item as a component on a bill.


BOM item type-

This attribute is controlled at the Master level only. Select a type to control bill functionality. You must enter a value here if BOM Allowed is turned on.













Related Articles to Read




Post a Comment

 

© 2008 About Oracle Apps - A Complete Guide to Oracle Applications Professionals. | Contact|About us.

All articles are copyrighted to About Oracle Apps.