Inventory Setups

Organization Creation:

To create Org, we need to define location and calendar.

Setting Up Locations
(N) > Setup > Organizations > Locations.

Setting Up Calender
(N) > Setup > Organizations > Calendar (this is for Manufacturing plant to define week off & Shift)


Setting Up Organizations
(N) > Setup > Organizations >Organizations

-> Name (Org name) -> Locations
-> Org clasifications
-> Name (Inventory Org)

Others > Accounting information
PL->Vision Operations
LE->Vision Operations
OU->Vision Operations
->Inventory information (Parameters)

=>Inventory Parameters
->Org Code (define)
->IMO (Item Master Org)
->Calender

Costing information :
-> Material (Mandatory)

=> Receiving information (Parameters)
->Receipt day early
->Receipt day late
->Over receipt Tolerence

=>RMA receipt routing(customer)
->Receipt routing


UOM, UOM Class & UOM Conversion

UOMs are used in Oracle Advanced Pricing for the calculation and pricing unit.

(N) > Setup > Unit of Measure>Unit of Measure

Units of Measure Classes
(N) > Setup > Units of Measure > Classes.

Unit of Measure Conversions
(N) Setup > Units of Measure > Conversions


Sub-inventory

(N) Setup > Organization > Subinventories.

Attribute Control:

(N) Set up>Item>Attribute Control

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.

Crete Item:

(N) Item >Master Items>Item

(Name: _______
Description: _________)

->Tools ->Copy from ->Template
                                    ->Item

Next -> Org Adjustment

Item Status Attribute:

->Set up->Items->Status codes

Default values for each item:

System Admin -> Profiles

• Site-> Common for all
• Application
• Responsibility
• User (Inventory default)

Create Template->

Set up->Item-> Template
          ->New ->Template(name)
          ->Description
          ->Tools ->Copy Template

Delete Item :

Setup-> Item -> Delete Items -> Groups
(Category of deletion) - Details
->Item ->Delete Group

Concurrent Program -> View Request

Item Cross reference :

Item -> Cross  reference (Name)

Item Relationship :

-> Substitute item
->(Substitute item no)

Inventory Item Control :

a) Revision Control 

Parameters- Revision, Serial no & Lot control

Org->Inventory->  Revision Control

Create an item -> Assign to your Org->Open Org attributes-> Check the Revision Control

Ex : F-0001 (F-0001(A), F-0001(B) )

-> Perform transactions

b) Lot Control

->Batch ID

User defined
At Org level->Satrting with sequence
At item level ->Prefix and sequence

Now->Parameter->Rev,SN,Lot

->Perform Transaction

c) Serial Control

* Individual Qty will have serial#
No Control->SN not rerd
At Receipt ->For purchase
At Sales Order->For Sales
Predefined-> Either Purchase/Sales

Now->Parameter->Rev,SN,Lot

d) Locator control

Parameter -> LOC control

a)None
b)Predefined
c)Dynamic
d) Sub inventory

a) None- None of Sub have Stock locator

b) Predefined- Locator enabled and can use only predefined locations

c) Dynamic - Locator enabled and can keep anywhere

d) Sub inventory - Controlled at Sub inventory level

ORG LEVEL

a)         None

b)         Predefined

c)         Dynamic

d)         Sub inventory 

Under Sub inventory level we can define control

d1) None

d2) Prespecified

d3) Dynamic

d4) Item level

Under Item level we can define as below

dy1) – No control

dy2) - Prespecified

dy3) - Dynamic

Define & Link Stock locator :

Set up -> Org Organization -> Stock locator

Generate Serial#  :

On-hand Qty availability -> Generate Serial#

* On Hand Qty in each locator  should be zero to generate serial#.

Restrict in locator/Subinventory :

Parameters -> Restrict locator

Item -> Tools -> Item Sub inventory

reserving the products only in that subinventory.


Min Max Planning:

• Maintaining Minimum and Maximum Qty in an org
• It is a concurrent program, It will re order Qty
• This can be run at Org /Sub inventory level
• This will work only if On hand Qty is less than Minimum Qty

Re Order Qty = Max Qty - Available Qty 

Available Qty = (On Hand+ Supply Qty) - Demand Qty

Supply -> Incoming

Demand-> Outgoing

Source Types :

Suppliers & Inventory

Suppliers - > PR- > PO-> Receipt

Inventory- > IR- > ISO-> Receipt


Sub inventory

a) Supplier  - > PR- > PO-> Receipt

b) Inventory  - > IR- > ISO-> Receipt

c) Sub inventory - > Replenish Move Orders

Inventory Accuracy Method :

Basically matching system Inventory Qty with physical qty.

• This can be done at Org level for all sub inventories

• This is performed annually once or twice

Counting -> Physical Inventory -> Physical Inventory

-> New -> Physical Counting for (Inv Org name)

Approval Required - >

a) Never
b) Tolerance
c) Always

* Concurrent program will run

TAG GENERATION:

Each Item will have Tag assigned

Counting -> Physical Inventory -> Tag Generation

TAG COUNT:

Counting -> Physical Inventory -> Tag Count - Choose for which inventory.

Enter Actual Qty (Physical Qty). This is more or less than Tag qty.



Approve Adjustment

*  Financial Guy will do the adjustment

Counting -> Physical Inventory-> Tools -> Launch Adjustments-> Account # & Run Concurrent Program

Counting -> Physical Inventory-> Approve -> Physical Adjustments

Summary -> Approve & Same.