Oracle Inventory User's Guide

Setup Steps

Inventory Profile Options

Profile Options

Oracle Inventory Management Command Center

Inventory Management Command Center Overview

Receiving Dashboard

Aging Inventory Dashboard

Reservations Dashboard

Shipping Dashboard

Space Utilization Dashboard

Accuracy Dashboards

Cycle Counting Dashboard

Physical Inventory Dashboard

Activity Dashboard

Move Orders Dashboard

Supply/Demand Dashboard

Track and Trace Dashboard

Transaction Management Dashboard

Items Dashboard

Kanban Dashboard

Inventory Management Command Center Setup

Setting Up Inventory Management Command Center

Setup and Configuration Steps

Setting Profile Options for Inventory Management Command Center

Setting Up Steps for Resource Requirements Components on the Shipping Dashboard

Configuring Descriptive Flexfields for Search

Loading Inventory Management Data - Inbound Details Data Load

Loading Inventory Management Data - Inventory On Hand

Loading Inventory Management Data - Inventory Cycle Counting

Loading Inventory Management Data - Physical Inventory

Loading Inventory Management Data - Inventory Reservations

Loading Inventory Management Data - Delivery Details

Loading Inventory Management Data - Space Utilization

Loading Inventory Management Data - Track and Trace

Loading Inventory Management Data - Activity Details

Loading Inventory Management Data - Move Orders

Collecting Item Supply/Demand Data

Loading Inventory Management Data - Supply/Demand

Loading Inventory Management Data - Transaction Management

Loading Inventory Management Data - Items Dashboard

Setup and Configuration Steps for the Kanban Dashboard

Setting Profile Options for the Kanban Dashboard

Enabling Electronic Kanban ECC Access Roles

Loading Electronic Kanban ECC Data

Inventory Structure

Overview of Inventory Structure

Organization Parameters Window

Defining Default Inventory Parameters

Defining Costing Information

Valuation Accounts

Defining Revision, Lot, Serial, and LPN Parameters

Defining ATP, Pick, Item-Sourcing Parameters

Defining Inter-Organization Information

Inter-Organization Transfer Accounts

Defining Other Accounts Parameters

Defining Warehouse Parameters

Defining Subinventories

Subinventory General Ledger Account Fields

Defining Stock Locators

Defining Organization Access

Defining Shortage Parameters

Copying Inventory Organizations

Inter-Organization Shipping Network

Defining Shipping Methods

Defining Intercompany Relations

Defining Economic Zones

Oracle Yard Management and Oracle Inventory

Unit of Measure

Overview of Units of Measure

Defining Unit of Measure Classes

Examples of Unit of Measure Classes

Defining Units of Measure

Examples of Units of Measure

Defining Unit of Measure Conversions

Examples of Unit of Measure Conversions

Lot-Specific Unit of Measure Conversions

UOM Public API

Item Setup and Control

Overview of Item Setup and Control

Implementing the Item Master Organization

Item Master Business Example

Item Attribute Controls

Control Level Dependencies

Item Status Control

Item-Defining Attributes

Status Attributes and Item Status Control

Relationships Between Attributes

Interdependent Attributes

Updatable Attributes

Defining Item Attribute Controls

Defining Container Types

Defining Item Status Codes

Defining and Viewing Pending Statuses

Defining Picking Rules

Defining Item Types

Item Templates

Templates Provided by Oracle

User-defined Templates

Copying Templates

Using Templates

Organization-Specific Templates

Defining Item Templates

Copying Item Templates

Defining Cross-Reference Types

Assigning Cross-Reference Types

Defining Commodity Codes

Defining Customer Items

Setting Customer Item Defaults

Defining Customer Item Cross References

Overview of Item Categories

Item Category Flexfield Structures

Defining Categories

Defining Category Sets

Cartonization

Defining Default Category Sets

Assigning Items to Categories

Copying Items with Category Assignments

Unlimited Additional Category Sets

Specifying Recommended Categories

Defining Category Accounts

Overview of Item Cataloging

Defining Item Catalog Groups

Concatenated Item Descriptions

Defining Descriptive Elements

Defining Aliases

Item Cataloging Examples

Defining and Maintaining Item Information

Overview of Items

Master Level vs. Organization Level

Defining Items

Defining Catch Weight Item Attributes

Updating Item Attributes

Assigning Items to Organizations

Updating Organization Level Items

Open Item Interface

Importing Items

Customer Item and Customer Item Cross Reference Interfaces

Importing Customer Items

Importing Customer Item Cross References

Importing Item Cross References and Related Items

Adding Attachments to Items

Viewing Item Information

Assigning Items to Catalogs

Defining Item Relationships

Defining Manufacturer Part Numbers

Assigning Subinventories to an Item

Assigning Items to a Subinventory

Defining Item Revisions

Defining Item Transaction Defaults

Tagging Material Classification Type for Items

Assigning Item Status for Multiple Organizations

Searching for Items

Item Deletion

Item Attributes

Item Attributes Listed in Alphabetical Order

Main Attribute Group

Inventory Attribute Group

Bills of Material Attribute Group

Asset Management Attribute Group

Costing Attribute Group

Purchasing Attribute Group

Receiving Attribute Group

Physical Attribute Group

General Planning Attribute Group

MPS / MRP Planning Attribute Group

Lead Times Attribute Group

Work In Process Attribute Group

Order Management Attribute Group

Invoicing Attribute Group

Process Manufacturing Attribute Group

Service Attribute Group

Web Option Attribute Group

Lot Control

Overview of Lot Control

Setting Up Lot Control

Setting Up and Updating Global Lot Attributes

Setting Up Grade Control

Item Lots

Assigning Lot Numbers Within Transactions

Lot Action Codes

Viewing Lot Genealogy

Lot Control Reports

Serial Control

Serial Number Control

Serial Number Restrictions for Transferring Between Organizations

Setting Up Serial Number Control

Generating Serial Numbers

Serial Number Assignment

Overview of Serial Tagging Assignments

Setting Up Serial Tagging Assignments

Serial Tagging API

Assigning Serial Numbers

Maintaining Serial Number Information

Viewing Serial Genealogy

Serial Number Control Reports

Material Status Control

Overview of Material Status

Setting Up Material Status Control

Transaction Setup

Overview of Transaction Setup

Control Options and Restrictions

Defining Default Subinventories and Locators

Converting Units of Measure

Transaction Source Types

Defining and Updating Transaction Source Types

Transaction Actions

Transaction Types

Defining and Updating Transaction Types

Defining Transaction Reasons

Defining Account Aliases

Defining Consumption Transaction Rules

Setting Transaction Processing Profile Options

Transaction Processing Mode

Launching Transaction Managers

Transaction Managers

Transactions

Overview of Inventory Transactions

Receiving Transactions

Using the Receiving Page

Overview of Return to Vendor Transactions

Transferring Between Subinventories

Performing Miscellaneous Transactions

Inter-organization Transfers

Direct Inter-organization Transfers

Inter-Organization Transfers via Intransit Inventory

Transferring Material Between Organizations

Planning Transfer Transaction

Transferring Consigned and VMI Material

Shortage Alerts and Shortage Notifications

Viewing Potential Shortages

Overview of Movement Statistics

Major Features

Defining Movement Statistics Parameters

Setting Up Movement Statistics

Automatically Generating Movement Statistics

Viewing and Maintaining Movement Statistics

Viewing Material Transactions

Viewing Message History

Viewing Transaction Summaries

Viewing Accounting Lines

View Accounting Windows

Drilling Down to Inventory from Oracle General Ledger

Viewing Pending Transactions

Pending Transactions Folder Window Available Fields

Viewing and Updating Transaction Open Interface Activity

Transaction Interface Folder Window Available Fields

Purging Transaction History

Transactions Reports

On-hand and Availability

Overview of On-hand and Availability

Material Workbench Window and HTML Page

Material Workbench Information

Viewing Item Availability

Viewing Item Status Information

Viewing Attribute Information

Material Workbench Transactions

Viewing Inventory Positions

Requesting the Multi-Organization Quantity Report

Viewing Item Supply and Demand Information

Item Reservations

Creating Reservations

Viewing Reservation Interface Activity

Reservations Interface Folder Window Available Fields

On-hand Availability Reports

Reservations - Simplified User Interface

Move Orders

Overview of Move Orders

Setting Up Move Orders

Generating Move Order Requisitions

Generating Replenishment Move Orders

Allocating and Transacting Move Orders

Manual Move Order Allocation

Configuring the Material Pick Wave Process

Exception Management

Manually Allocating and Transacting Pick Wave Move Orders

Express Pick Release

Reservation Details

Planning and Replenishment

Overview of Inventory Planning and Replenishment

Summarizing Demand History

Requesting the Summarize Demand Histories Report

Defining ATP Rules

Defining a Forecast Rule

Generate a Forecast

Order Modifiers

Min-Max Planning

Requesting the Min-Max Planning Report

Entering and Reloading Item Safety Stocks

Reorder Point Planning

Running the Reorder Point Report

Overview of Kanban Replenishment

Major Features

Defining Kanban Pull Sequences

Generating Kanban Cards

Defining Kanban Cards

Printing Kanban Cards

Replenishing Kanban Cards

Replenishment Counting

Sources of Replenishment

Entering and Processing Replenishment Counts

Purging Replenishment Counts

Cost Control and Accounting

Overview of Accounting Close Cycle

Maintaining Accounting Periods

ABC Analysis

Overview of ABC Analysis

Defining and Running an ABC Compile

Defining ABC Classes

ABC Assignment Groups

Defining ABC Assignment Groups

Defining ABC Item Assignments

Updating ABC Item Assignments

Purging ABC Information

Cycle Counting

Overview of Cycle Counting

Defining and Maintaining a Cycle Count

Defining Cycle Count Classes

Cycle Count Items

Defining Cycle Count Items

Cycle Count Scheduling

Generating Automatic Schedules

Entering Manual Schedule Requests

Count Requests

Generating Count Requests

Requesting the Cycle Count List

Entering Cycle Counts

Approval Options and Tolerances

Count Adjustments and Approvals

Approving Cycle Count Adjustments

Approval Actions and Adjustments

Serialized Cycle Counting

Scheduling and Generating Count Requests

Entering Cycle Counts

Approving and Adjusting Counts

Purging Cycle Count Information

Cycle Count Open Interface

Cycle Counting Reports

Physical Inventory

Overview of Physical Inventory

Defining a Physical Inventory

Taking a Snapshot of Inventory Quantities

Physical Inventory Tags Overview

Generating Physical Inventory Tags

Physical Inventory Counts

Void Tags

Entering and Voiding Physical Inventory Tag Counts

Voiding Physical Inventory Tags

Approval Tolerances

Approving Physical Inventory Adjustments

Processing Physical Inventory Adjustments

Purging Physical Inventory Information

Physical Inventory Reports

Using the Physical Inventory API to Update Inventory Tag Records and Adjustment Records

Intercompany Invoicing

Intercompany Invoicing Process Overview

Features

General Business Processes Summary

Intercompany Invoicing Setup

Transaction Flows

Intercompany Invoicing Reports

Intercompany Account Receivables Invoices Report

Intercompany Account Payables Invoices Report

Intercompany Invoice Accounting Distributions

Accounting Distributions from the Intercompany Accounts Receivable Invoice

Accounting Distributions for Intercompany Accounts Payable Invoice

Intercompany Invoice Pricing

Using Advanced Pricing Engine with Intercompany Invoicing

Seed Data Support of Advanced Pricing Integration with Intercompany Invoicing

Intercompany Invoicing for Sales Orders Example

Intercompany Invoicing Example Accounting Details

Intercompany Invoicing Sales Order Process

Intercompany Invoicing Internal Order Process

Intercompany Accounting Transactions Flows

Reports and Concurrent Requests

ABC Assignments Report

ABC Descending Value Report

Account Alias Listing

Activate Onhand Level Material Status Tracking

Calculate Billing Units

Close Period Status Control

Consigned Return Transactions Report (XML)

Consumption Advice Diagnostics

Country-Specific Reports

Create Deferred Logical Transactions

Customer Item Commodity Codes Listing

Customer Item Cross References Report

Customer Items Report

Cycle Count Entries and Adjustments Report

Cycle Count Hit/Miss Analysis

Cycle Count Listing

Cycle Count Open Requests Listing

Cycle Count Unscheduled Items Report

Cycle Count Schedule Requests Report

Cycle Counts Pending Approval Report

Expired Lots Report

Forecast Rule Listing

Freight Carrier Listing

Genealogy Report

Generate cycle count requests

Global Transaction Purge

Grade Change History

Import Cycle Count Entries from Open Interface

Inactive Items Report

Intercompany AR Invoices Report

Intercompany AP Invoices Report

Inter-organization Shipping Information Listing

Inventory Aging Report (XML)

Inventory Charges and Product Usage Report

Inventory Debug File Retrieval

Inventory Packing Slip

Inventory Transaction by Cost Center and Account Report

Item Categories Report

Item Cross-References Listing

Item Definition Detail

Item Definition Summary

Item Demand History Report

Item Organization Assignment Report

Item Quantities Summary Report

Item Relationships Listing

Item Replenishment Count Report

Item Reservations Report

Item Statuses Report

Item-Subinventory Report

Item Template Listing

Locator Listing

Locator Quantities Report

Lot And Serial Date Notification

Lot Inventory Report

Lot Master Report

Lot Transaction Register

Mass Lot Attributes Sync

Material Account Distribution Detail

Material Account Distribution Summary

Material Status Change History Report

Material Status Definition Report

Min-Max Planning Report

Move Order Pick Slip Report

Move Order Purge

Movement Statistics Exception Report

Movement Statistics Reset Status Report

Movement Statistics Processor

Movement Statistics Report

Open Period Control

Organization Hierarchy Exceptions Report

Organization Parameters Listing

PAR Replenishment Count Worksheet

Physical Inventory Adjustments Report

Physical Inventory Adjustments Affecting Reservations and Allocations (XML) Report

Physical Inventory Counts Report

Physical Inventory Item Accuracy Report

Physical Inventory Missing Tag Listing

Physical Inventory Summary Report

Physical Inventory Tag Listing

Physical Inventory Tags

Physical Inventory Trend Report

Planner Listing

Print Cycle Count Entries Open Interface Data

Purge Cycle Count Entries Open Interface Data

Reorder Point Report

Serial Number Detail

Serial Number Transaction Register

Shortage Parameter Report

Shortages Summary Report

Status Attributes Listing

Subinventory Listing

Subinventory Quantities Report

Transaction Historical Summary Report

Transaction Purge

Transaction Register

Transaction Source Type Summary

Units of Measure Listing

Vendor Lot Trace Report

VMI Onhand by Supplier Report

Warehouse Inventory Adjustment Advice

Warehouse Inventory (Onhand) Report Message

Oracle Inventory Windows and Navigation Paths

Oracle Inventory Management Windows and Navigation Paths

Oracle Inventory Flexfields

Oracle Inventory Flexfields

System Items (Item Flexfield)

Oracle E-Records For Inventory

Manufacturing and Distribution Manager Windows and Navigation Paths

Navigation Paths For All Oracle E-Records-Enabled Discrete Manufacturing Business Events

Events

Event Key

Event Subscription

Oracle Approvals Management Seeded Data

Oracle E-Records Seeded Data: Generic Query Attributes

Glossary

Index

Oracle Inventory User's Guide

Contents