Oracle Fusion SCM Inventory Setups – Complete Guide (Part 2)
In this blog, we continue our deep dive into Oracle Fusion SCM Inventory Setups, focusing on advanced configurations that consultants implement in real-world projects. If you have already understood the basic inventory structure (items, organizations, subinventories), this part will help you move into practical, implementation-level setups used in live environments.
Inventory setups in Oracle Fusion are not just configuration steps—they directly impact procurement, order fulfillment, costing, and supply chain execution. A small mistake here can cause major downstream issues in transactions.
Understanding Advanced Inventory Setups in Oracle Fusion
In Part 1, we covered foundational setups. In this part, we focus on:
- Subinventory and Locator Configuration
- Item Status Control
- Units of Measure (UOM) Setup
- Inventory Transaction Types
- Lot and Serial Control
- Min-Max Planning Setup
These setups are critical for organizations managing high-volume inventory operations, warehouses, and manufacturing flows.
Key Features of Inventory Setups (Advanced)
Some of the most important capabilities in advanced inventory setups include:
- Multi-level inventory tracking (Organization → Subinventory → Locator)
- Flexible item control policies (lot, serial, revision)
- Configurable transaction processing
- Inventory planning automation (Min-Max)
- Integration with Procurement, Order Management, and Costing
Real-World Business Use Cases
1. Manufacturing Company – Raw Material Tracking
A manufacturing client needs:
- Raw materials tracked at bin level
- Lot control for quality tracking
- Serial tracking for finished goods
👉 Solution:
- Enable Locator control
- Configure Lot & Serial tracking
- Define separate subinventories for RM and FG
2. Retail Warehouse – Bulk Storage and Fast Picking
A retail client requires:
- Bulk storage in back warehouse
- Fast-moving items in front picking area
👉 Solution:
- Create multiple subinventories (Bulk, Picking)
- Enable locator hierarchy for warehouse layout
- Use Min-Max planning for auto-replenishment
3. Pharma Industry – Compliance and Traceability
Pharma companies need:
- Batch tracking (Lot)
- Expiry control
- Regulatory compliance
👉 Solution:
- Enable Lot control with expiration dates
- Configure item status restrictions
- Use transaction controls for restricted usage
Configuration Overview
Before starting advanced setups, ensure:
- Inventory Organization is created
- Items are defined in Product Information Management (PIM)
- Basic inventory parameters are configured
Step-by-Step Configuration in Oracle Fusion
1. Subinventory Setup
Subinventories represent physical or logical storage areas.
Navigation:
Navigator → Setup and Maintenance → Manage Subinventories and Locators
Step-by-Step:
Step 1 – Create Subinventory
- Enter:
- Subinventory Code:
RM_STORE - Description: Raw Material Storage
- Asset Subinventory: Yes
- Subinventory Code:
Step 2 – Enable Controls
- Enable:
- Locator Control (if needed)
- Picking Order
- Default Cost Group
Step 3 – Save
👉 Consultant Tip: Always separate asset vs expense subinventories clearly to avoid costing issues.
2. Locator Setup
Locators define exact physical locations (Rack, Bin, Shelf).
Step-by-Step:
Step 1 – Define Locator Structure
- Example:
- Row → Rack → Bin
Step 2 – Generate Locators
- Example:
- A-01-01
- A-01-02
Step 3 – Assign to Subinventory
👉 Real-world tip: For large warehouses, use system-generated locators instead of manual creation.
3. Item Status Setup
Item status controls what transactions are allowed.
Navigation:
Setup and Maintenance → Manage Item Statuses
Step-by-Step:
Step 1 – Create Status
- Name:
Active_Stock - Allowed Transactions:
- Inventory Transactions: Yes
- Purchasing: Yes
- Order Management: Yes
Step 2 – Create Restricted Status
- Name:
QC_Hold - Disable:
- Sales Orders
- Shipping
👉 Scenario: Items under quality inspection can be blocked from shipping.
4. Units of Measure (UOM)
UOM is critical for procurement, inventory, and sales.
Navigation:
Setup and Maintenance → Manage Units of Measure
Step-by-Step:
Step 1 – Define UOM Class
- Example: Quantity
Step 2 – Define Base UOM
- Example: Each (Ea)
Step 3 – Define Conversions
- 1 Box = 10 Each
👉 Consultant Tip: Always validate UOM conversions with business teams to avoid incorrect inventory valuation.
5. Inventory Transaction Types
Transaction types define how inventory moves.
Navigation:
Setup and Maintenance → Manage Inventory Transaction Types
Common Types:
- Miscellaneous Receipt
- Miscellaneous Issue
- Subinventory Transfer
- Account Alias Issue
Step-by-Step:
Step 1 – Create Transaction Type
- Name:
Internal Transfer
Step 2 – Assign Source Type
- Inventory
Step 3 – Save
👉 Tip: Use custom transaction types for audit tracking.
6. Lot and Serial Control Setup
This is essential for industries like pharma, electronics, and automotive.
Configuration at Item Level:
Step 1 – Enable Lot Control
- Full Control or At Receipt
Step 2 – Enable Serial Control
- At Receipt or Predefined
Step 3 – Define Attributes
- Expiration Date
- Supplier Lot
👉 Real Example:
- Laptop tracking uses Serial Number
- Medicine tracking uses Lot Number
7. Min-Max Planning Setup
Min-Max helps maintain optimal stock levels.
Navigation:
Setup and Maintenance → Manage Min-Max Planning
Step-by-Step:
Step 1 – Define Min-Max Values
- Min: 100
- Max: 500
Step 2 – Assign to Item/Subinventory
Step 3 – Run Min-Max Planning Process
👉 Outcome:
- System generates replenishment suggestions automatically.
Testing the Setup
Once configuration is complete, perform real transactions.
Example Test Scenario
Scenario: Receive Inventory
- Create Purchase Order
- Receive material into subinventory
- Verify:
- Locator assignment
- Lot/Serial generation
Expected Results
- Inventory should be visible in:
Inventory → Manage On-Hand Quantity
Validation Checks
- Correct UOM conversion applied
- Item status allows transaction
- Lot/Serial captured correctly
Common Implementation Challenges
1. Incorrect Locator Design
- Leads to warehouse confusion
👉 Solution: Design locator structure with warehouse team
2. UOM Conversion Errors
- Causes incorrect stock levels
👉 Solution: Validate conversions during testing
3. Item Status Misconfiguration
- Blocks transactions unexpectedly
👉 Solution: Carefully define allowed transactions
4. Overuse of Serial Control
- Slows down operations
👉 Solution: Use serial control only where necessary
Best Practices from Real Projects
- Always design inventory structure before system setup
- Keep subinventory naming consistent across organizations
- Avoid excessive locator levels unless required
- Use Min-Max planning for high-volume SKUs
- Maintain proper documentation for audit and support
Frequently Asked Questions (FAQs)
1. What is the difference between Subinventory and Locator?
Subinventory is a high-level storage area, while locator defines the exact physical location inside it.
2. When should Lot Control be used?
Lot control should be used when batch tracking and expiry management are required, such as in pharma or food industries.
3. Can we change UOM after transactions?
No. Once transactions exist, changing UOM can cause inconsistencies. Always finalize UOM during initial setup.
Summary
In this blog, we explored advanced configurations in Oracle Fusion SCM Inventory Setups, including:
- Subinventory and locator design
- Item status control
- UOM setup and conversions
- Transaction types
- Lot and serial tracking
- Min-Max planning
From an implementation perspective, these setups are not just technical steps—they define how your entire supply chain operates.
A well-designed inventory setup ensures:
- Accurate stock tracking
- Efficient warehouse operations
- Smooth integration with Procurement and Order Management
As a consultant, your focus should always be on aligning system configuration with business processes, not just completing setup tasks.
For more detailed official guidance, refer to Oracle documentation:
https://docs.oracle.com/en/cloud/saas/index.html