Generating Serial Numbers
If you specified Predefined as the serial number control type for an item, you must predefine serial numbers for that item.
If you specified entry At inventory receipt or At sales order issue, you can optionally predefine serial numbers for the item. The process of generating serial numbers does not assign serial numbers to units in inventory, it simply reserves specific serial numbers for an item, for later use. When you run the serial generation program if you have the same serial prefix number across organizations, the concurrent program searches across the organizations, and generates serial numbers using the highest start number across the organizations.

Serial Number Assignment

You must assign serial numbers whenever you receive items under serial number control into inventory. If an item is under Predefined control, you can choose from the list of predefined serial numbers for that item. If an item is under dynamic entry At inventory receipt, you can choose from a predefined list of serial numbers or enter any serial number, depending on the uniqueness control for your organization. You can create and assign serial numbers individually or as a range to speed up data entry. If your item is under dynamic entry At sales order issue, you can only assign serial numbers when you perform a shipment transaction in Oracle Shipping Execution.

Once you assign a serial number to an item, the combination of the serial number and the item is an entity known as a serialized unit. From that point on, Oracle Inventory tracks all movements and maintains the following information for each serialized unit:
• Receipt or Ship Date
The date on which you last performed a material transaction for your serialized unit. Material transactions update this
information when you move your serialized unit.
• Serial State
Oracle Inventory assigns one of the following states to your serialized unit: Defined but not used, Resides in inventory, Issued out of inventory, or Resides in intransit.
 

Status Codes
---------------------
1 Defined but not used
3 Resides in stores
4 Issued out of stores
5 Resides in intransit
6 Pending status
7 Resides in receiving
8 Resides in WIP

You can get a full list of the codes with the following SQL: select
lookup_type,
lookup_code,
meaning
from mfg_lookups
where lookup_type = 'SERIAL_NUM_STATUS'
order by lookup_type, lookup_code

• Location
The organization, subinventory, and locator in which the serialized unit currently resides. Material transactions update
this information when you transfer the serialized unit.
• Revision level
The revision of the item when you assign the serial number to the unit.
• Lot number
During material transactions, you first specify the lot number and then the serial number. Oracle Inventory tracks the lot from which a specific serialized unit originates.