Oracle Replenishment Counting Process

Replenishment counting can be used even if you do not maintain on-hand balances (i.e. on non-tracked subinventories). The replenishment counting system is used only at the subinventory level. Replenishment counting is a good method to generate reorders for items in production floor stock or departmental office supplies or manufacturing MRO items held on production lines. An open interface for loading bar coded count data collection is provided. All items to be planned with replenishment counting must be set to Min-max planning at the Item/Subinventory level.. 

eBooks
Download eBook	Data 2

Oracle Inventory Cycle Count Process

Cycle counting is the periodic counting of individual items throughout the course of the year to ensure the accuracy of inventory quantities and values.  Cycle counting can be used in lieu of taking a complete physical inventory, or both techniques can be used side-by-side.

The Oracle Inventory process can automatically select and rank items for cycle counts.  To do so the Inventory Control Manager uses the Define ABC Compile form to rank the items.  There are 11 different criteria for the ranking process.  Most generally used is the current on-hand quantity of items or current on-hand value of items.  The Define ABC Classes and Define ABC Groups are the forms used to link the classes with an ABC compilation.  Common class structure is A, ranked as 1, which is higher than B, ranked as 2, etc.

View Inventory Material Transactions Process

The Material Transaction Process allows you to view the details associated with inventory transactions.  You can search for transaction information by entering any combination of search criteria on the Find Material Transactions form.  The results will display in the Material Transactions window.

In the Material Transactions window you can view the information in the Location, Intransit, Reason/Reference, Transaction ID, or Transaction Type alternative regions.

Oracle Inventory Subinventory Transfer Process

The Subinventory Transfer Process is the movement of material from one subinventory to another subinventory within an organization.  It is also used to move material from one subinventory/location to another.  All of the accounting transactions are generated by the system based upon account numbers entered when the subinventories were defined.

Oracle Inventory Move Order Process Flow

The move order process follows the following steps:

1. Create a move order for required material. You can manually create a move order requisition or set up your system to automatically generate replenishment or pick wave move orders.

Updating Average Costs in Oracle Costing

For average cost organizations only, you can directly update the average cost of items to include additional costs, such as freight, invoice price variances, or job variances. You can update one or more cost elements or levels (this and previous) individually or to the total unit cost. Any change made to the total unit cost is spread to all cost elements and levels in the same proportion as existed prior to the update.

Oracle Inventory Min–Max Planning

Min–Max Planning

You can use min–max planning to maintain inventory levels for all of your items or selected items. With min–max planning, you specify minimum and maximum inventory levels for your items. When the inventory level for an item (on–hand quantities plus quantities on order) drops below the minimum, Oracle Inventory suggests a new purchase requisition, internal requisition, move order, or job to bring the balance back up to the maximum.

Oracle Inventory User’s Guide

Oracle  Inventory User’s Guide
Release 11i
Part No. A83507–08
Download PDF Material

Oracle Inventory User's Guide

Oracle Inventory
User's Guide
Release 12
Part No. B31547-02

Download PDF Material

Oracle Inventory Integration with other modules

Oracle Inventory interacts with the other applications by sharing information:

Ø       Oracle Cost Management: From cost Information to transaction rates

Ø       Oracle Work in Progress: From WIP activity and ATP supply information to UOM, items, and on-hand quantity.

Ø       Oracle Master Scheduling/MRP: From ATP supply information to on-hand quantity and forecasts

Ø       Oracle Bill of Materials to UOM and items