Oracle Inventory
 
 

Oracle Inventory

Course Code: FI

Duration: 2 days

S5

Oracle Inventory Course Overview

This course is designed to give delegates the knowledge to use Oracle 11i Inventory for day to day transaction processing as well as activities such as managing stock levels, together with periodic processes such as stock-taking, cycle counting and updating stock records to agree with physical stock counts. It provides a sound introduction to key elements of set up such as defining sub-inventories, locators and inventory items.

The delegate will learn and acquire skills as follows:

  • 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
  • Planning Reorder Point
  • Replenishing Counting
  • Defining and Maintaining a Physical Inventory
  • Defining an ABC Compile

Who will the Course Benefit?

This Oracle Inventory course is designed for end users working either within a Finance department or in stores or equivalent areas.

Course Objectives

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 , ensure the maintenance of appropriate stock levels, set up cycle counts and process periodic physical stocktakes and adjustments arising as a result of these. Delegates will be shown how to transfer bookkeeping entries from Inventory to General Ledger.

Requirements

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

Follow-On Courses

Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.


 

Course Contents

Oracle Inventory Training Course

Course Introduction

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

Session 1: 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

Session 2: 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

Session 3: 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

Session 4: INVENTORY TRANSACTIONS

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

Session 5: 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

Session 6: 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

Oracle Inventory Training Course

Session 7: 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

Session 8: REPLENISHMENT COUNTING

  • Generating a Replenishment Count
  • Purging Replenishment Counts

Session 9: PHYSICAL INVENTORY

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

Session 10: ABC CLASSIFICATION

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

Session 11: 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

Session 12: INVENTORY USER EXERCISES

Session 13: INVENTORY SUPERUSER EXERCISES

 

Oracle Inventory

Duration: 2 days

RRP: £1,050.00 exc. VAT 


Upcoming Scheduled Events
Next 6 months

London
Start Date   Spaces Book
18 Feb 2019   Spaces StayAhead - Course Running Book
 
20 May 2019   Spaces StayAhead - Course Running Book
 
Virtual Events StayAhead Virtual Courses available You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.
 

Course Reviews

It was beneficial to me being the only delegate on the course, which enabled me to influence the course content and instruction to my particular work needs.

Sarah - SCM Inbound Functional Support - Manufacturing


The course was excellent and very relevant to our needs. Our trainer, John, was excellent, very helpful and knowledgeable about the subject and was able to tailor the course to our requirements. Would definitely recommend StayAhead.

Carol - Oracle Applications analyst/programmer - Police


The course was very useful and the trainer was excellent. He went beyond the training course material and delved into areas that were specific to our requirements. He has provided extra material that would assist us in understanding the complete lifecycle between the various Oracle modules. Very pleased with the delivery style and the contents of the training course.

Rashmi - Oracle Applications Support - Police


 
 
 
        Home             Let Us Call You
 

 

Course Deliveries

Public Scheduled and Closed
Virtual
UK and Overseas

OUG

Oracle User Group - Membership Benefits

OUG

Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

StayAhead
Flexibility

Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!




Our Course Curriculum

 
 
 
 
 



Our Ratings

Instructor
Quality
 

97.48%

Course
Practical
 

92.63%

Overall
Courseware
 

94.44%

Overall
Course
 

96.46%

+44 (0)20 7600 6116
sales@stayahead.com
Copyright © 2019 StayAhead Training Ltd
Cookies   /   Privacy Policy