Inventory R12 Enhancements
Agen Oracle R12 Inventory Structure Overview of Additional Features integrated in R12 Inventory
11i Org Structure Parent Org
Company
OU
Org/Plants Discrete
Warehouse OPM
Inv. Org Sub Inv
Sub Inv
Locators
Locators
12i Org Structure
OU
Inv Org
Sub Inv
Locators
Converged Inv. Model
Organization Parameters
Inventory Tab
Chargeable Subcontracting
Revision, Lot , Serial ..
Lot Specific UOM Conversion
ATP, Picking, Item
ATP, Picking, Item
Reservation to take priority over an allocation
Other Accounts
Other Accounts
Updates OPM Convergence Ø Dual Unit of Measure Control Ø Material Status Control Ø Advanced Lot Control Ø Support for Indivisible Lots Ø Material Aging Workflow Ø Manual Reservation and Allocation Enhancements Lot and Serial New Features
Dual Unit of Measure 1. One item with two units of measure simultaneously Ideal when no constant conversion 1. Transact, reserve, view in both units of measure 2. Pricing can be done in either unit of measure 3. Planning and Costing still done using primary UOM 4. Process organizations only
Dual UOM Control
Lot Expiration (Shelf Life) Retest Interval Enter the number of days after the creation date before you need to retest the lot. The system adds this number to the lot creation date to determine the default retest date. Lot Creation Date + Retest Interval = Default Lot Retest Date. Expiration Action Interval Enter the number of days the system adds to the expiration date before it performs an action on the lot. Lot Expiration Date + Lot Expiration Action Interval = Default Expiration Action Date.
Lot Control Maturity Days This is the number of days added to the lot creation date to determine the lot maturity date. If you do not enter a number, the system assumes the lot is mature at creation. Lot Creation Date + Maturity Days = Default Lot Maturity Date. Hold Days This is the number of days added to the lot creation date before you can release the lot. If you do not enter a number, the system assumes that you can use the lot immediately. Lot Creation Date + Hold Days = Default Hold Release Date.
Grade Controlled Indicate whether the item is grade controlled in addition to lot controlled. A grade code represents specific characteristics of a lot. If you select the Grade Controlled check box, then you must specify a default grade for the item. Note: You cannot modify this check box if you have transacted the item. Default Grade: Enter a default grade for the item. All items under grade control must have a default grade. You can use the grade change transaction to change the default grade of an item. Note: You can change the default grade even if you
Grade Control can be enabled for lot
Advanced Lot Control
Description- Available Capabilities q
q q q
Additional Lot Attributes Grade, Origination, Retest Date, Expiration Action Code, Expiration Action Date, Maturity Date, Hold Release Date Sublot Tracking Lot-Specific UOM Conversions Support for Indivisible Lots
Benefits q
More accurate inventory tracking
q
Better shipping accuracy
q
Better customer service
q
Easier to use, less user involvement
Child Generation This field determines how the system generates child lot numbers at the item level. You can choose to generate child lot numbers across the organization level or at the item level. The available choices are: Parent + Child: When set to parent + child, the parent lot number acts as a prefix, and the next available lot number is added to form the child lot. For example if the parent lot is p1, then the child lot would be p1-1. Parent: When set to parent, child lot numbers are based on the
Lot Divisible Select this check box to enable you to allocate, reserve, or move partial lot quantities. If you do not select this check box you must transact the full lot quantity for this item. You cannot modify this field if transactions exist for the item.
Process Manufacturing
Use item in a production batch as an ingredient, product, or by-product
Unified view of Lot and Navigation On-hand Quantity
Serial No.
Lot, Serial, Transaction Details on same form Material Workbench view also by Grade
Click
On-Hand Reservations qInclude Cross-dock qSerial
CrossDock Crossdock allows warehouses to increase its operational efficiency by transferring inbound material directly to an outbound area. It bypasses the inventory-holding function of a warehouse while still allowing it to serve its consolidation and shipping functions.
Picking Rule qSort Criteria for Picking Rules qTerminology Changes in Sort Criteria
UOM qLot Specific Conversion
New Function
Transaction Type
Location can be made mandatory
Material Status