Oracle R12 Inventory — A 2-Day Course

 Open Public Course Closed In-House Course

Synopsis

This course is designed to give delegates the knowledge to use Oracle Inventory for managing stock levels, as well as periodic processes such as stock-taking and updating stock records to agree with physical stock counts.

By the end of this course delegates will be able to use Oracle Inventory to carry out daily tasks such as recording receipts and issues of stock.

Objectives

The delegate will practise:

• Setting up Inventory
• Maintaining Inventory
• Setting Up and Maintaining Items
• Locating Inventory Transactions
• Checking Stock Availability
• Receipting Returns and Writing off Damaged Goods
• Min / Max Planning
• Reorder Point Planning
• Replenishing Counting
• Defining and Maintaining a Physical Inventory
• Defining an ABC Compile

Suitable For

This course is intended for:

• End users working either within a Finance department or in stores or equivalent areas.

Prerequisites

• Delegates should have knowledge of the inventory process within their own organisation.
• Knowledge of Oracle Navigation would be advantageous.

Publicly scheduled dates, locations, and prices

Outline Course Contents

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Overview of Oracle Inventory

• Inventory Structure
• Organizations
• Locations
• Sub-Inventories
• Locators
• Units of Measure
• Categories
• Item Defining Attributes
• Default Category Set
• Items
• Inventory Transactions
• Material Workbench
• Inventory Planning and Replenishment
• Accounting Close Cycle
• ABC Analysis
• Cycle Counting
• Physical Inventory
• Inter-Company Invoicing

Inventory Set Up and Maintenance

• Control and Inventory Organization
• Review Organization Parameters
• Limit Organization Parameters
• Limit Organization Access
• Create Sub-Inventories
• Define Units of Measure
• Define Unit of Measure Classes
• Define Unit of Measure Conversion
• Create Picking Rules
• Create Cross Reference Types

Item Set Up and Maintenance

• Define Items at Master Level
• Item Attributes
• Main Attribute Group
• Inventory Attribute Group
• Bill of Material Attribute Group
• Costing Attribute Group
• Purchasing Attribute Group
• Receiving Attribute Group
• Physical Attribute Group
• General Planning Attribute Group
• Lead Times Attribute Group
• Inactive Items

Inventory Transactions

• Inventory Transactions
• Account Alias Transactions
• Account Transactions
• Sub-Inventory Transfers
• Locating Inventory Transactions
• Checking Stock Availability

Receipts Returns and Corrections

• Receipts Returns and Corrections
• Receipting Expected Stock Items
• Entering a Partial Receipt
• Receiving Unordered Goods
• Entering a Return
• Making Corrections to a Receipt
• Writing off Damaged Goods

Min - Max Planning

• Organization Level Min - Max Planning
• Sub-Inventory Level Min - Max Planning
• Assigning Min - Max Levels at Sub-Inventory Level
• Running the Min - Max Planning Report

Reorder Point Planning

• Reorder Point Planning
• Setting up Items for Reorder Point Planning
• Generating a Demand Forecast
• Creating a Forecast Set
• Assigning Safety Stock
• Manually Define Safety Stock
• Calculate Safety Stock Based on Existing Forecast
• Running the Reorder Print Point Planning Report

Replenishment Counting

• Generating a Replenishment Count
• Purging Replenishment Counts

Physical Inventory

• Defining a Physical Inventory
• Generating Physical Tags
• Printing the Tag Report
• Entering Counts
• Voiding Tags
• Approving Adjustments
• Posting Adjustments
• Purging Physical Inventory

ABC Classification

• Reasons for ABC Classification
• ABC Analysis Setup
• Define an ABC Compile

Cycle Counting

• Set up a Cycle Count
• Define Cycle Count Classes
• Define Cycle Count Items
• Perform a Cycle Count
• View the Cycle Count Report
• Enter Cycle Counts
• Approve Cycle Count

Inventory User Exercises

Inventory SuperUser Exercises