Oracle Inventory

1
Oracle Inventory

• ?????

2
Outline

• Inventory Overview
• Inventory introduction
• Inventory components
• Inventory Control
• Oracle Inventory Flow Process
• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

3
Inventory Overview
4
Inventory Overview

• Inventory introduction
• Inventory components
• Inventory control

5
Inventory Overview

• Inventory introduction
• Inventory components
• Inventory control

6
Inventory Introduction

• ????
• ???????????
• ??
• ???????????????
• ???????????
• ???????????????
• ?????????

7
Inventory Overview

• Inventory introduction
• Inventory components
• Item
• subinventory
• Inventory control

8
Inventory Overview

• Inventory introduction
• Inventory components
• Item
• subinventory
• Inventory control

9
Inventory Components - Item

• Type
• Number schema
• Engineering aspect
• Inventory aspect
• Purchasing aspect

10
Inventory Components - Item

• Type
• Raw material
• WIP (work in process)
• Semi-finished goods
• Finished goods (end item)
• MRO (Maintenance , Repair and Operation Supplies)
  
• Number schema
• Engineering aspect
• Inventory aspect
• Purchasing aspect

11
Inventory Components - Item

• Type
• Number schema
• Part number or Item number
• ?????????????????????
• Engineering aspect
• Inventory aspect
• Purchasing aspect

12
Inventory Components - Item

• Type
• Number schema
• Engineering aspect
• Revision
• EC
• Drawing
• Inventory aspect
• Purchasing aspect

13
Inventory Components - Item

• Type
• Number schema
• Engineering aspect
• Inventory aspect
• Locator
• Safety stock
• On-hand quantity
• Transaction summary
• Purchasing aspect

14
Inventory Components - Item

• Type
• Number schema
• Engineering aspect
• Inventory aspect
• Purchasing aspect
• Lead-time
• Order Policy Reorder point?EOQ
• Supplier

15
Inventory Overview

• Inventory introduction
• Inventory components
• Item
• Subinventory
• Inventory control

16
Inventory Components - Subinventory

• Types
• ????
• ????
• ????
• ???
• ????
• ???
• ????
• ??
• ?????????

17
Inventory Overview

• Inventory introduction
• Inventory components
• Inventory control
• ABC analysis
• Reorder point
• Economic Order Qty ,EOQ
• Physical inventory

18
Inventory Overview

• Inventory introduction
• Inventory components
• Inventory control
• ABC analysis
• Reorder point
• Economic Order Qty ,EOQ
• Physical inventory

19
ABC Analysis

• A?
• ??1030?????,???????????7080
• C?
• ??4050?????,???????????515
• B?
• ?????

20
ABC Analysis

• A?????
• ????
• ???????????
• ?????????????
• ????????????????
• ??????????
• C?????
• ????????
• ??????
• ????

21
Inventory Overview

• Inventory introduction
• Inventory components
• Inventory control
• ABC analysis
• Reorder point
• Economic Order Qty ,EOQ
• Physical inventory

22
Reorder Point
Quantity
Reorder Quantity?????
Reorder Point
Safety Stock
Lead Time????
Time
23
Inventory Overview

• Inventory introduction
• Inventory components
• Inventory control
• ABC analysis
• Reorder point
• Economic Order Qty ,EOQ
• Physical inventory

24
EOQ
25
Inventory Overview

• Inventory introduction
• Inventory components
• Inventory control
• ABC analysis
• Reorder point
• Economic Order Qty ,EOQ
• Physical inventory

26
Physical Inventory
????????
??????
????
??????
??????????
??????
????????
????
????????
27
Oracle Inventory Flow Process

• ?????

28
Oracle ERP Overview
?? Inventory
29
Oracle ERP Overview
?? Inventory
30
Inventory Flow Process
31
Oracle Inventory Flow Process

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

32
Oracle Inventory Flow Process

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

33
Inventory Enterprise Structure
34
(No Transcript)
35
Inventory Organization Hierarchy

• Each oracle inventory organization must have an
  item master organization.

36
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

37
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Unit of Measure , UOM
• Item status
• Define Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

38
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Unit of Measure , UOM
• Item status
• Define Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

39
Unit of Measure
Define one base UOM For each UOM class
Define UOM classes
Define multiple nonbase UOMs for each class
Define standard Conversions
Define Intraclass Conversions
Define UOM Conversion
Define interclass Conversions
40
(No Transcript)
41
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Unit of Measure , UOM
• Item status
• Define Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

42
Item Status

• By giving an item status you can control key
  functionality of an item.

43
Item Status Control

• Control Level of status attributes
• Master-level control
• Identical value
• Organization-level control
• Different value
• Status Setting Level
• Sets Value nonupdatable
• Defaults Value updatable
• Not Used no value

44
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Unit of Measure , UOM
• Item status
• Define Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

45
Define Item
Choose Item Attribute Control Levels
Define Catalogs
Define UOMs
Define Status Control Levels
Define Categories
Create Templates
Define Category Sets
Define Statuses
Define Default Category Sets
1
46
Define Item
1
Copy templates
Copy Items
Enter attribute values
Enable in child organizations
Update organization level attributes
Define Item costs
47
Practice (1)(2)

• Define your own items
• Two for Finished Goods
• Two for Raw Materials
• Responsibility
• Inventory , Vision Operations (USA)

48
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

49
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Locator control
• Revision control
• Lot control
• Serial number control
• Miscellaneous Transaction
• Accuracy control
• Planning

50
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Locator control
• Revision control
• Lot control
• Serial number control
• Miscellaneous Transaction
• Accuracy control
• Planning

51
Locator Control

• Track items by rack and bin locators.
• Assign default shipping locators for items.
• Assign default receiving locators for items.
• Restrict items to particular locators.
• Use locators in a material transaction

52
Locator Control
Item with locator control in this subinventory
Organization
Subinventory
Subinventory
Locator
Item without locator control in this subinventory
53
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Locator control
• Revision control
• Lot control
• Serial number control
• Miscellaneous Transaction
• Accuracy control
• Planning

54
Revision Control

• Track items by revision information.
• Enter a miscellaneous receipt with revision
  control.
• Enter a engineering change order with revision
  number.

Revision A
Revision B
55
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Locator control
• Revision control
• Lot control
• Serial number control
• Miscellaneous Transaction
• Accuracy control
• Planning

56
Lot Control

• Track specific batches of items.
• Regulate the use of perishable items.
• Enable lot and shelf life control of items.

Lot 032698
57
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Locator control
• Revision control
• Lot control
• Serial number control
• Miscellaneous Transaction
• Accuracy control
• Planning

58
Serial Number Control

• Track individual units of items that you store
  and transact in your organization.
• Track items that you want to maintain very tight
  control.

SN 0101549
59
(No Transcript)
60
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

61
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Overview
• Customize Transactions
• Miscellaneous Transactions
• Accuracy control
• Planning

62
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Overview
• Customize Transactions
• Miscellaneous Transactions
• Accuracy control
• Planning

63
Overview
Material Flow
Business Flow
Receive Goods
WIP
Purchasing
Move Goods
Inventory
Order Management
MRP
Ship Goods
64
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Overview
• Customize Transactions
• Miscellaneous Transactions
• Accuracy control
• Planning

65
Customize Transactions

• A transaction source type and transaction action
  make up a transaction type.

66
Transaction Source Type
67
Transaction Action

• Issue from stores (-)
• Receipt into stores ()
• Subinventory transfer (-)
• Direct organization transfer (-)
• Intransit shipment (-)

68
Transaction Type
69
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Overview
• Customize Transactions
• Miscellaneous Transactions
• Accuracy control
• Planning

70
Miscellaneous Transactions Term
Miscellaneous Receipt
Miscellaneous Issue
Organization
Subinventory
Subinventory
Locator
Locator
Subinventory Transfer
Locator
Locator
Direct Inter-organization Transfer
Inter-organization Transfer by Way of Intransit
Organization
71
Practice (3)(6)

• Revision Control
• INV-02 needs revision control in M1
• Miscellaneous transaction
• Account Receipt of INV-01 INV-02
• Subinventory Transfer of INV-02
• Query on-hand Qty
• INV-01 INV-02
• Responsibility
• Inventory , Vision Operations (USA)

72
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning

73
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Physical inventory
• ABC analysis
• Cycle counting
• Planning

74
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Physical inventory
• ABC analysis
• Cycle counting
• Planning

75
Physical Inventory Flow
????????
??????
????
??????
??????????
??????
????????
????
????????
76
Physical Inventory Flow
77
Oracle Physical Inventory
78
Physical Inv. v.s Oracle Physical Inv.
????????
????
??????????
????
????????
??????
??????
??????
????????
79
Define Physical Inventory Snapshot
80
Generate Tags
81
Enter Counts
82
Approve Counts
83
Run Adjustment Program
84
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Physical inventory
• ABC analysis
• Cycle counting
• Planning

85
ABC Analysis
86
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Physical inventory
• ABC analysis
• Cycle counting
• Planning

87
Cycle Count
88
Cycle Count Steps
Define cycle count header.
Update cycle-count items.
Schedule items to count.
Generate count requests.
Enter cycle counts.
Approve cycle counts.
89
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning
• Reorder point?EOQ
• Min-max planning

90
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning
• Reorder point ?EOQ
• Min-max planning

91
Reorder Point Order time
Quantity
Reorder Quantity
Reorder Point
Safety Stock
Lead Time
Time
92
EOQ Order Qty
93
Reorder Point Steps
94
Oracle Inventory Flow

• Inventory Enterprise Structure
• Item
• Inventory Control
• Miscellaneous Transaction
• Accuracy control
• Planning
• Reorder point ?EOQ
• Min-max planning

95
Min-max Planning
Enter item-planning attributes.
Define subinventory-level info. (optional)
Run min-max report.
96
Practice (7)

• Min-max planning
• Use min-max planning for your raw material items
  INV-03 , INV-04
• Responsibility
• Inventory , Vision Operations (USA)