Inventory Controls
Stock Locator / Locator
Control
Any combination of the four controls can be
implemented for each item. Inventory controls are optional for all items
Ø
Locator
Ø
Revision
Ø
Lot
Ø
Serial Number
Ø
Locators are
optional structures within sub inventories.
Ø
Locators are the
third level in the enterprise structuring scheme of Oracle Inventory.
Ø
Locators may
represent rows, aisles, or bins in warehouses. Items can be received directly
into and shipped items directly from locators.
Ø
You can
structure your Oracle Inventory installation so some of the subinventories and
items have locator control while others do not.
If locator control is turned on at the item level, you must specify a
locator when transacting the item into or out of a subinventory. If locator control is turned on at the
subinventory level, you must specify a locator when transacting any item into
or out of that subinventory. Each stock
locator you define must belong to a subinventory, and each subinventory can
have multiple stock locators. The
possible locator control types are:
o
None
o
Pre-specified
o
Dynamic entry
o
Item Level
Explaining Locator
Control Reports
Locator Quantities
Report
You use the Locator Quantities Report to identify
items and their quantities stored in the specified stock locators. If the stock locator has a zero on-hand
quantity, then the locator is not included in the report.
Locator Listing
Report
You use the Locator Listing Report to list stock
locators you defined. You also use this
report to review volume and weight allowed in a location before transacting
items.
Revision Control
Ø
A revision is a
particular version of an item, bill of material, or routing.
Ø
By using the
‘Revision control’ option while defining items item quantities can be tracked
by item revision. To do so a revision is
a must for each material transaction.
Ø
Revision control
is enabled for items for which version changes or changes that are significant
enough to track but are not affecting the function and feature of the item are
tracked.
Ø
Revision Control
item attributes cannot be changed when an item has quantity on hand.
Ø
When defining
Revision numbers letters, numbers and characters such as A, A1, 2B, etc can be
used.
Ø
Letters are
always in upper case and numbers may include decimals.
Ø
To ensure that
revisions sort properly, decimals should always be followed by a number.
Ø
Revisions are
sorted according to ASCII rules.
Ø
Each revision
must be greater than the previous revision.
For example, revision 10 cannot be used after revision 9 because,
according to ASCII sorting, 10 precede 9.
Ø
The value entered in the Starting Revision field in the
Organization Parameters window displays as the starting revision for the item
when assigning revisions to an item.
Lot Control
Ø
Inventory
provides complete lot number support for inventory transactions.
Ø
A lot identifies
a specific batch of an item that is received and stored in an organization.
Ø
Lot control is a
technique for enforcing the use of lot numbers during material transactions,
thus enabling the tracking of batches of items throughout their movement in and
out of inventory.
Ø
If Lot Control
is turned on for an item, the lot number must be indicated to perform a
transaction.
Ø
Lot Control must be turned on at the item level.
Ø
Lot numbers must
be assigned whenever items under lot control are received into inventory.
Ø
An inventory
receipt can be split in to several lots, as necessary.
Ø
Quantities can
be added to existing lot numbers.
Ø
Inventory will
generate default lot numbers by using the default lot number generation method
which is configured in the Organization Parameters window during setup.
Explaining Lot Control
Reports
Lot Transactions
Register
You can use the Lot Transactions Register to report
comprehensive lot number material transaction detail within a specific date
range. You can run the report for a
range of lots, items, transactions types, transaction reasons, and
subinventories. You can also specify a
specific category set and display transaction quantities in their primary or
transacted unit of measure.
Supplier Lot Trace
Report
You can use the Supplier Lot Trace Report to trace a
specific lot to its supplier lots. You
can run the report for a range of lot numbers and items and a specific supplier
lot number. The report shows you the lot
material transactions related to the selected items as, lot numbers,
transaction dates, and transaction quantities.
Expired Lots Report
You can use the Expired Lots Report to show lots in
your organization that expire on or before the date you specify. You can run the report for a range of items
or for a specific item only.
Serial Control
Ø
A serial number
is an alphanumeric piece of information assigned to an individual unit of an
item. A serialized unit is a combination
of an item number and a serial number.
Ø
Individual units
of items can be tracked by using serial numbers. Serial number control is a system
technique for enforcing the use of serial numbers during a material
transaction. Serial numbers can be used to track items over which a very tight
control is to be maintained.
Ø
One serial
number per unit of an item can be assigned
Ø
Depending on how
Serial Number Control is set at the Master Item level will determine how serial
numbers are generated.
Ø
If No Control is
specified as the serial number control type, no serial number control will be
enforced.
Ø
If Predefined is specified as the serial
number control type, serial numbers for that item must be predefined.
Ø
If control ‘At inventory receipt’ or ‘At sales order issue’, optionally
serial numbers for the item can be predefined.
Generating Serial Numbers
Ø
Inventory uses
the starting serial number prefix and the starting serial number specified in
the Item screen.
Ø
The process of
generating serial numbers is done through a concurrent report. This does not assign numbers to units in
inventory; it simply reserves serial numbers for an item, for later use.
Serial Genealogy
Ø
Enables to view
the composition and transaction history of a serial-controlled item through a
graphical user interface.
Ø
Includes all
material transactions within an organization.
Ø
Enables to trace
serial numbers from an assembly to all components.
Ø
Enables to trace
serial numbers from a component to a final assembly.
Explaining Serial
Number Control Reports
Serial Number
Transactions Register
You can use the Serial Number Transactions Register
to report comprehensive serial number material transaction detail within a
specific date range. You can run the
report for a range of serial numbers, items, transaction types, transaction
reasons, and subinventories. You can
also specify a specific category set and display transaction quantities in their
primary or transacted unit of measure.
Serial Number
Detail Report
You can use the Serial Number Detail Report to
report on information about current serialized units in your organization for a
specific source type or serialized unit status.
Oracle Inventory enables you to run the report for a range of serial
numbers, items, suppliers, and supplier serial numbers.
