Download - OPM r12 Inventory v1.0
-
7/29/2019 OPM r12 Inventory v1.0
1/23
Inventory for Oracle Process Manufacturing
AGSS Process Manufacturing Sales Support Team
-
7/29/2019 OPM r12 Inventory v1.0
2/23
Agenda
General concepts
Process Inventory Solution
Key Functionality
Additional resources
-
7/29/2019 OPM r12 Inventory v1.0
3/23
General Concepts
-
7/29/2019 OPM r12 Inventory v1.0
4/23
Manufacturing Building Blocks
Quality
Costing
Analysis
Inventory
Product
DevelopmentPlanning Produce
Order
Management
Purchase
-
7/29/2019 OPM r12 Inventory v1.0
5/23
Inventory
Quality
Costing
Analysis
Inventory
Product
DevelopmentPlanning Produce
Order
Management
Purchase
-
7/29/2019 OPM r12 Inventory v1.0
6/23
Order Management Procurement ASCP
OPMRecipe /Quality
OPM
Costing
OPM
Production
BOM /
QualityCostingWIP
OPM
Production
BOM /
Quality
Inventory Data Model Structure
Order Management Procurement ASCP
OPMRecipe /Quality
OPM
Costing
OPM
Production
Oracle Inventory
BOM /
QualityCostingWIP
Single Inventory Model Org specific attributes
Process featuresinclude: Flexible balance tracking in
two units of measure
Grade
Expiration/ Maturation dates
Material Status
Enhanced inventoryallocation rules
Indivisible lots
Support for child lots
Process Manufacturingflags
-
7/29/2019 OPM r12 Inventory v1.0
7/23
Inventory ManagementCapture Location & Composition
thoughout Lifecycle
Multi-Level
Where Used /
Lot Source
Product Attributes Shelf life Retest interval Potency Dual units of measure User-defined classifications
Plant
Item
Inventory Org
Locator
Parent Lot
Child Lot
Grade
Company ABC Company
Manufacturing Location
Product
Inventory Location/Warehouse
Batch ID / Pallet #/Billet
Traceable Quantity of Material/Heat
Area, Tank, Zone, etc.
Grade A,B,C w/in a Spec
Improve Recall Responsiveness / Cost
Trace Materials Enterprise-Wide to Analyze Vendor Quality
Comply with International Regulations
Lot Status Released, Hold, Quarantine
Sub-inventoryRow/Rack/Bin
-
7/29/2019 OPM r12 Inventory v1.0
8/23
Process Inventory Solution
-
7/29/2019 OPM r12 Inventory v1.0
9/23
Process Inventory Solution
Enables you to:
Satisfy customer demand quickly and accurately
Reduce costs with efficient Inventory Management Reduce risk with rapid lot genealogy analysis
Ensure Regulatory compliance
-
7/29/2019 OPM r12 Inventory v1.0
10/23
Key Functionality
Multi-purposed single item
Dual UOM (unit of measure)
Simultaneous multiple UOM
Automatic lot level allocation Shelf life management
Grade control
Lot level status control
Divisible lots Parent / Child lot tracking
-
7/29/2019 OPM r12 Inventory v1.0
11/23
Inventory Items Are:
Any item you want to: Track
Sell
Buy
Cost
Plan
Use in manufacturing
Testey Concept Items are entered ONCE used everywh
-
7/29/2019 OPM r12 Inventory v1.0
12/23
Dual Units of Measure
Package / Liquid / Solid contents can vary by containers
Inventory in EA / Price in LB
Track onhand inventory in two units of measure simultaneously
throughout business flow (PO to Ship)
Update lot/sublot UOM conversions and inventory
Standard:
1 EA = 10 LB 20.0LB
vs.
Lot 001- A
1 EA = 10.5 LB
Lot 001- B
1 EA = 10.3 LB 20.8 LB
-
7/29/2019 OPM r12 Inventory v1.0
13/23
Simultaneous Multiple UOM
UOM TypesMASS
VOL UNITS PKG POTENT
LBKGGROZ
GLQTCFTTRK
EAdrmcase
can
BLKCSETRKPLT
PBFYield%SOLLBA
Generic
Conversions
Item
LotChild / Sublot
Conversions
Fundamental Units
-
7/29/2019 OPM r12 Inventory v1.0
14/23
Inventory Allocation Rules
Allowing the selection of single or multiple lots
Matching customer specifications
Allowing the partial allocation of a request
Order based on:
Lot Number Item Revision
Subinventory
Stock Locator
Picking based on: Lot Expiration or Creation date Receipt date
-
7/29/2019 OPM r12 Inventory v1.0
15/23
OPM selects lots based on FIFO or FEFO methods
2/1/20072/5/2007Creation
Date1/1/2007
FIFO
2/15/20073/5/2007
Lot ALot A Lot CLot CLot BLot B
Expiration
Date
Production batchProduction batch
Shipment
2/10/2007
FEFOAdditionally, for customer shipments:Preferred Grade Match on Quality Specification Remaining Shelf Life
OPM Automatic Lot AllocationsConfigurable Rules Ensure the Right Inventory
-
7/29/2019 OPM r12 Inventory v1.0
16/23
Lot Expiration ManagementValidate and Manage Date-Sensitive Goods
Automatically notify when lots are approaching
expiration or require retesting
Disallow shipment of expired inventory
Control expiration tolerances by customer
Manage retesting
Lot Creation Day 0 Lot Expiration Day 14Lot Retest Day 7
UnshippableShippable to Customer A
Shippable to Customers B, C
Shippable to Other Customers
X
WF WF
WF = Workflow Notification
-
7/29/2019 OPM r12 Inventory v1.0
17/23
Lot Grade
Specify preferred grade by customer
Represents any combination of inventory and quality
attributes
May be used in Pricing and Sales Allocation Rules
Grade is effective at the lot / child lot level
May be updated based on QC sample test results
-
7/29/2019 OPM r12 Inventory v1.0
18/23
Inventory Status
Control Inventory Usability
Bulk Subinventory Status:QC HOLD (Disallows Sales Order Issue)
B1.1.1Locator Status:
Active (Disallows Sales Order Issue)
L123
Effective Status:
Disallows Sales Order Issue,
Misc Issue, Sub Transfer
Material
Lot Status:
Quarantine (Disallows Misc Issue, Sub Transfer)
-
7/29/2019 OPM r12 Inventory v1.0
19/23
Divisible Lots
Lot 123
Qty 5 bundles
Lot 456
Qty 5 bundles
Lot 789
Qty 20 bundles
Divisible = No
Order = 10 bundles
Allocation
Divisible = Yes
Order = 10 bundles
Allocation
-
7/29/2019 OPM r12 Inventory v1.0
20/23
Multi-Level TraceabilityReduce Time to Resolve Issues
Improve Recall Responsiveness / Cost
Comply with FDA GxP and Safety Regulations
Trace Materials Enterprise-Wide to Analyze Vendor Quality
Ingredients
& Resources
Intermediate or
Bulk Products
Finished
ProductSupplier Customers
Where UsedWhere Used
Lot SourceLot Source
-
7/29/2019 OPM r12 Inventory v1.0
21/23
Process Inventory Solution
Enables you to:
Satisfy customer demand quickly and accurately Multi-purposed single item, dual & multiple UOM, auto lot
allocation, grade control, divisible lot control
Reduce costs with efficient Inventory Management Dual UOM, shelf life management, grade control, lot level
status control, physical and cycle counting, APIs
Reduce risk with rapid Lot Genealogy analysis Parent / child lot tracking and tractability
Ensure Regulatory compliance Audit trail, strong security, ERES, Inventory tied to Regulatory
-
7/29/2019 OPM r12 Inventory v1.0
22/23
Additional Resources
-
7/29/2019 OPM r12 Inventory v1.0
23/23
Additional Resources
Vivian Lewis AGSS SCM Solution Specialist
[email protected] 972-xxx-xxxx
Andrew Hyers AGSS SCM Solution Specialist
Mobile 502-xxx-xxxx David Ballin AGSS SCM Solution Architect
Mobile 201-218-3245
Office 201-794-6221
mailto:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]