logo
Home

Oracle® R12 Inventory

  • CMDBID 106201
  • Course Code FIR12
  • Duration 2 Days
Scroll

Oracle Course

course overview

Click to View dates & book now

Audience

Who will the Course Benefit? Who will the Course Benefit?

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

Skills Gained

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

Defining an ABC Compile Course Objectives 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 and adjustments arising as a result of these. Delegates will be shown how to transfer bookkeeping entries from Inventory to General Ledger.

Outline

View Course Contents - DAY 1 Oracle R12 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

View Course Contents - DAY 1 (continued)

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

View Course Contents - DAY 2

Oracle R12 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

Certification

Course Contents

View Course Contents - DAY 1

...more

Oracle R12 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

View Course Contents - DAY 1 (continued)

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

View Course Contents - DAY 2

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

Course Contents View Course Contents - DAY 1

...more Oracle R12 Inventory Training Course

Oracle R12 Inventory Training Course Oracle R12 Inventory Training Course

Inactive Items View Course Contents - DAY 1 (continued) View Course Contents - DAY 1 (continued) View Course Contents - DAY 1 (continued) View Course Contents - DAY 1 (continued)

Running the Min - Max Planning Report View Course Contents - DAY 2

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.