Serial Number Generation in Oracle Apps

Serial generation in Oracle Apps is based on the parameters defined for an Organization:

• Serial Uniqueness
• Within organization: Enforce unique serial numbers within the current organization
• Within inventory model and items: Enforce unique serial numbers for inventory items
• Across organizations: Enforce unique serial numbers throughout all organizations
• Serial Generation
• At organization level: Define the starting prefix and serial number information for items using the information you enter in the following fields of this window
• At item level: Define the starting serial number prefix and the starting serial number when you define the item
• Prefix
• Starting Serial Number Parameter
• Allocate Serial Number: Indicate whether the system will suggest serial numbers as part of the move order line allocating process. If you do not select this option, you must manually enter the serial numbers in order to transact the move order.

Case-1 In organization parameters Serial Generation='At organization level' and Uniqueness='Within inventory model and items'

INVENTORY> On-hand Availability> Generate Serial Number

Select Organization and generate serial number for different items.

The serial number value gets incremented for each serial generation irrespective of item

e.g.

1. INVENTORY> Setups> Organizations> Parameters
2. Define ‘Prefix= MFG’ and ‘Starting Serial Number Parameter= 0001’ in MFG organization parameters
3. Define ‘Prefix= SER’ and ‘Starting Serial Number Parameter= 0001’ in SER organization parameters
4. Select MFG organization
5. INVENTORY> On-hand Availability> Generate Serial Number
6. Run Serial Generation program for ABC with quantity=5
7. Run Serial Generation program for XYZ with quantity=5
8. Serial number ‘MFG0001 to MFG0005’ will be assigned to ABC
9. Serial number ‘MFG0006 to MFG0010’ will be assigned to XYZ
10. Select SER organization
11. INVENTORY> On-hand Availability> Generate Serial Number
12. Run Serial Generation program for ABC with quantity=5
13. Run Serial Generation program for XYZ with quantity=5
14. Serial number ‘SER0001 to SER0005’ will be assigned to ABC
15. Serial number ‘SER0006 to SER0010’ will be assigned to XYZ

Case-2 In organization parameters Serial Generation=’At Item Level’ and Uniqueness='Within inventory model and items'

1. INVENTORY> Items> Organization items Query the item and go to Inventory tab
2. Define Serial ‘Prefix= Item-MFG’ and ‘Starting Number= 0001’ for ABC and XYZ item in MFG organization
3. Define Serial ‘Prefix= Item-SER’ and ‘Starting Number= 0001’ for ABC and XYZ item in SER organization
4. Select MFG organization
5. INVENTORY> On-hand Availability> Generate Serial Number
6. Run Serial Generation program for ABC with quantity=5
7. Run Serial Generation program for XYZ with quantity=5
8. Serial number ‘Item-MFG0001 to Item-MFG0005’ will be assigned to ABC
9. Serial number ‘Item-MFG0001 to Item-MFG0005’ will be assigned to XYZ
10. Select SER organization
11. INVENTORY> On-hand Availability> Generate Serial Number
12. Run Serial Generation program for ABC with quantity=5
13. Run Serial Generation program for XYZ with quantity=5
14. Serial number ‘Item-SER0001 to Item-SER0005’ will be assigned to ABC
15. Serial number ‘Item-SER0001 to Item-SER0005’ will be assigned to XYZ