What are you looking for ?
Recent Topics

Item Setup-2

Supply Chain - Oracle Inventory
Item Setup and Control in oracle apps r12

Master Item 

Oracle Item Master allows you to define and control items that you stock in inventory. 

MAIN – Set item attributes Primary unit of measure (UOM),Item Type, Item status, long description
INVENTORY – Inventory Item, stockable, transactable, reservable, revision control, cycle count, Lot control, serial control, shelf life.

To assign the item  to member Organizations go to => Tools   => Organization Assignments. 
Or just click on Organization Assignments as in picture then Check the Assigned check box and save the changes.

A revision is particular version of an Item, Bill of Materials, or Routing.
Use the version control to track item quantities by item revision and specify a revision for each material transaction.

Defining Item Relationships

You can define relationships between items. This allows you to search for items through these relationships.
Except in Oracle Purchasing, these relationships are for inquiry , reporting or dispense transaction .
  • Choose new to define a new relationship.
You can also enter search criteria and choose Find to display existing item relationships.
  • Enter an item that represents the From part of the relationship.
  • Enter an item that represents the From part of the relationship.
  • Enter an item that represents the To part of the relationship.
  • Select the Type of relationship between the items.
    • Related: The items are related in a non-specific way.
    • Substitute: One item is a substitute for another.

Item Setup 1

Supply Chain - Oracle Inventory

Item Setup and Control in oracle apps r12

Item Attribute Controls

Item attributes are information about an item, such as order cost, lead time, and revision control.
One of the prerequisites for defining items (and assigning values to item attributes) is setting attribute controls.

Control Level

This attribute control type determines whether you have centralized (Master level) or decentralized (Organization level) control of item attributes.

Attributes maintained at the Master level have the same attribute values in each organization in which an item is assigned. For example, you maintain an item's primary unit of measure at the Master level.
Attributes maintained at the Organization level may have different attribute values in different organizations. For example, an item may be min-max planned in a distribution organization but material requirement planning (MRP) planned in a production organization.

Status Attribute

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.

Status attributes "Sets Value"           Can't change attributes value
Status attributes "Defaults Value"    Attribute value can an be changed 
Status attributes "Not Used"            Don't use this attributes 

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 "Defaults Value".

 Status Control

Status control describes whether certain status attributes have default values that appear when you assign a status code to an item, and whether status codes control those attribute values after the defaults are assigned to an item.

Item Templates

Templates are defined sets of attributes that you can use over and over to create many similar items. Templates make initial item definition easier. Oracle recommends that you use templates-either those Oracle provides or those you define-when you define your items.
You can apply more than one template on the same item


A category is a logical classification of items that have similar characteristics.
You can use categories and category sets to group your items for various reports and programs.
The flexibility of category sets allows you to report and inquire on items in a way that best suits your needs.

Category Sets

One category set can contain more than one category code

Control level.

Master Level: Item assigned to this category set has the same category value in all organizations where it is assigned.
Org Level: Item assigned to this category set may have a different category value in each organization where it is assigned.

Select a default category.

This is the default category used when assigning an item to the category set. For example, a category set may have a default category called "Clinical Consumables". After an item is assigned to "Clinical Consumables", you can override the default category and choose another relevant category for each item.

Allow multiple item category assignments.

If you enable this feature, you can assign an item to multiple categories within a category set. For example, you may define a Hazard category set. In this case, an item may be assigned to both the Poison and Corrosive categories.

Catalog Groups

You can use item cataloging to add descriptive information to items and to partition your Item Master into groups of items that share common characteristics
  • Enter a unique name for the group.
  • Enter a description.
If you choose to build an item's description from the catalog, the description is built beginning with the information entered here.

Inventory Setup-2

 Supply Chain - Oracle Inventory

Inventory Setup in oracle apps r12

After Defining the Inventory Org , You need to create the Sub inventories.
You can't make any transaction "Shipping Or Receiving " unless you have at list one  sub-inventory.
Setup==> Organization ==> Subinventories
Click New
In Type : if you choose Receiving the you would be able to investigate on the on-hand quantity.

PAR level planning is perpetual in nature, only the reduction of on-hand quantity by consumption leads to replenishment of items based on the Replenishment count quantity or the PAR levels identified for each item.

Picking order: Take a numeric vale represent the priority in case of shipping (1 is the top priority) 
Dropping order: Take a numeric vale represent the priority in case of receiving (1 is the top receiving)
Sourcing: In case of replenishing inventory it should be from supplier or other inventory    
Item / Subinventory : used to determine a specific items to be stored in this inventory  

Dispensing Rules 

Creating a rule for picking items from inventory

Unit of measure 

Measure Class :represent a group unit of measure 
Each Class can have more than one unit of measure but only one Base unit

Inventory Setup-1

Supply Chain - Oracle Inventory

Inventory Setup in oracle apps r12

We will First create the Inventory Org Location.
Inventory ==> Setup ==> Organizations ==> Locations
Name should unique in both Global or local
In Shipping Details if you identify if you can ship to this location, send Bill, ...etc.
After Creating Inventory Location , we need to create the Inventory Calendar 
The 4-4-5 accounting cycle means that in each quarter, the first financial period consists of the first four weeks, the second period consists of the next four weeks, and the third period consists if the next five weeks.
The grouping of 13 weeks may also be set up as 4-4-5 weeks or 5-4-4 suitable if you are planning to use (MRP).

Material requirements planning (MRP) is a computer-based inventory management system designed to improve productivity for businesses.

When this type of calendar is in use, reports with month-by-month comparisons or trends are flawed as one month is 25% longer than the other two. It could still compare a period to the same period in the prior year, or use week by week data comparisons.

You need to tools and click Build to create your Calendar

Now we will create the Inventory Organization and assign the Inventory Location and Inventory Calendar
First create the Master Org as below
Next step will be creating  the Inventory Organization.
When we do click on Others Button , You will need to provide the additional information for 'Accounting Information ' , 'Inventory Information' , 'Receiving Information'.
In Accounting Information , We need to Provide the Ledger Name , Legal Entity  and the Operating Unit under which we want to create the Inventory Org.
Now you will define the Inventory Information.
In Inventory Information , we will provide the Unique the Organization code and attach the Inventory Calendar.
Under Costing Information Tab , We will define the Costing & Accounting Information.
The last step is the Receiving Information for Inventory Organization.
Receiving Options

Flag Counter

Social Profile

Copyright x 2011. By Wael Medhat - All Rights Reserved