This chapter covers the following topics:
I want to create serial numbers in oracle duplicate Ask Question -1. This question already has an answer here. Want to create serial numbers 1 answer I want to create a serial number in Oracle. I have tried this query. Alter table tablename add(ID NUMBER); CREATE SEQUENCE SEQID START WITH 1 INCREMENT BY 1 MAXVALUE 31611805 MINVALUE 1. If you are looking for free access to manage your partition in PC or free download EaseUS Partition Master 11.5, try the free version or get 20% discount for free download EaseUS Partition Master 11.5 with serial code/key now.
Serial Number Control
Oracle Inventory provides complete serial number support for inventory transactions. You can enable serial number control for specific items. For items that are under serial number control, you assign unique serial numbers to individual units and reference the same serial numbers each time you perform a transaction on an individual unit. This enables you to have tight control over every unit of every item in your inventory. If you set up serial control at sales order issue, then at sales order issue, you can assign serial numbers only when you perform a shipment transaction in Oracle Shipping Execution.
Serial Number Validation
Oracle Inventory enables you to perform the following two optional validations for serial numbers that are used in Oracle Work in Process. You set the profile option INV: Restrict Receipt of Serials to Yes. to enable this validation.
-
Validation of serialized components:If you enable the profile option, then you cannot receive the serial number through purchase order receipt, miscellaneous receipt, or account alias receipt, if that same serial number has been issued to Oracle Work In Process.
-
Validation of serialized end-assemblies:If you enable the profile option, then you cannot complete an end assembly item into Oracle Inventory, for a discrete job, repetitive schedule, flow schedule, and work order-less completion, if that same serial number has a state of issued out of stores.
Maintaining Serial Number
You can use the Serial Numbers window to update supplier information that is associated with your serial numbers. You can view all serial numbers that you created in your current organization and the state and supplier lot information that is associated with your serial numbers. See Maintaining Serial Number Information.
Issuing Material from Inventory
If you issue items with a serial number control type of dynamic entry at inventory receipt or predefined, then you must choose from the list of serialized units that you have already received into inventory. If you issue items with a serial number control type of dynamic entry at sales order issue, then you must assign serial numbers when you ship the item against a sales order. See Assigning Serial Numbers, Overview of Material Control, Oracle Work in Process User's Guide, and Overview of Shop Floor Control, Oracle Work in Process User's Guide.
Cycle Counting
Oracle Inventory supports cycle counting of items under serial number control.
Performing Physical Inventories
Oracle Inventory includes the serial numbers of the items to count in your physical inventory when it generates tags. You must assign serial numbers to all items under serial number control for which you enter counts in the Physical Inventory Tag Counts window. See Entering and Voiding Physical Inventory Tag Counts.
Assigning Serial Numbers to Assemblies
When you receive into inventory a completed assembly with a serial number control type of dynamic entry at inventory receipt or predefined, then you must assign a serial number in the WIP Completion Transaction window in Oracle Work in Process. You either accept the default serial number or enter another valid one. See Overview of Assembly Completions and Returns, Oracle Work in Process User's Guide.
Returning Serialized Units to Suppliers
You can return serialized units to the supplier in the Enter Returns and Adjustments window. Oracle Inventory updates the serial number information with the purchase order number and transaction date of the return so that the location of the serialized unit is known.
When you receive replacement units, you can issue new serial numbers. When you receive repaired units, you should reference the original serial numbers so that Oracle Inventory can properly update the existing serial numbers. See Entering Returns, Oracle Purchasing User's Guide.
Purging Serial Number Transactions
You can purge all transaction information about serial numbers from your current organization. Note that the transactions must occur within closed accounting periods. See Purging Transaction History.
Related Topics
Serial Number Restrictions for Transferring Between Organizations
The system places certain restrictions on serial controlled items that you transfer between organizations where the serial control in the source and destination organizations is different. The following tables explain the expected results.
Direct Inter organization Shipment
Source Org / Destination Org | At Receipt or Predefined | At Sales Order Issue | None |
---|---|---|---|
At Receipt of Predefined | Allowed, serial moved to destination. | Allowed, serial number created as sales order issue. | Allowed, serial entered at issue and set to issued from stores in source organization. No serial received in destination organization. |
At Sales Order Issue | Not allowed. | Allowed, serial number dynamic entered at issue. | Allowed, no serial created or moved. |
None | Not allowed. | Allowed, serial number created at sales order issue. | Allowed, no serial created or moved. |
Intransit Inter organization Shipment
Source Org / Destination Org | At Receipt or Predefined | At Sales Order Issue | None |
---|---|---|---|
At Receipt or Predefined | Allowed, user prompted for serial at receipt from the list of values of shipped serials, serials received to destination location. | Allowed, user prompted for serial at receipt from LOV of shipped materials, serial received to destination organization but set to defined but not used. | Allowed, serial entered at issue and set to issued from stores in source organization. No serial received in destination. |
At Sales Order Issue | Allowed, no serials issued. New serials generated at receipt. | Allowed, no serials issued or received. | Allowed, no serials issued or received. |
None | Allowed, no serials issued. New serials generated at receipt. | Allowed, no serials issued or received. | Allowed, no serials issued or received. |
Direct Internal Requisition
Source Org / Destination Org | At Receipt or Predefined | At Sales Order Issue | None |
---|---|---|---|
At Receipt or Predefined | Allowed, serial moved to destination. | Allowed, set serial to defined but not used in destination organization. | Allowed, serial set at issued from stores in source organization. |
At Sales Order Issue | Allowed, serial moved to destination. | Allowed, serial moved to destination organization but set to defined but not used. | Allowed, serial set at issued from stores in source organization. |
None | Not allowed. | Allowed, not serial created or moved. | Allowed, no serial created or moved. |
Intranist Internal Requisition
Source Org / Destination Org | At Receipt or Predefined | At Sales Order Issue | None |
---|---|---|---|
At Receipt or Predefined | Allowed, user prompted for serial at receipt from LOV or shipped serials, serial received to destination location. | Allowed, user prompted for serial at receipt from LOV of shipped serials, serial received to destination organization, but set to defined but not used. | Allowed, serial set at issued from stores in source organization, user not prompted for serial at receipt. |
At Sales Order Issue | Allowed, user prompted for serial at receipt from LOV of shipped serials, serial received to destination location. | Allowed, user prompted for serial at receipt from LOV of shipped serials, serial received to destination organization, but set to defined but not used. | Allowed, serial set at issued from stores in source organization, user not prompted for serial at receipt. |
None | Allowed, serials generated at receipt. | Allowed, no serial issued or received. | Allowed, no serial issued or received. |
Related Topics
Customizing the Presentation of Data in a Folder, Oracle Applications User's Guide
Setting Up Serial Number Control
Before you can use serial number control, you must set the item attributes and organization parameters:
To set up serial number control
-
Establish serial number control for an item.You establish serial number control for an inventory item when you define it on the Item Master. You can choose from No control, Predefined, At inventory receipt, or At sales order issue. See Inventory Attribute Group.
-
Establish serial number uniqueness.You use the Organization Parameters window to choose a type of serial number uniqueness for your organization. You can choose to enforce uniqueness Within inventory items, Within an organization, or Across organizations. The three levels for serial uniqueness are cumulative, and the definitions are as follows:
-
Within Inventory Items: Once you assign a serial number to a particular item you cannot assign the same serial number to the same item regardless of the organization. For example if you assign serial number SN100 to item A, you cannot assign serial number SN100 to any other instance of item A in any organization. This also includes CTO items derived from base model A. However you could receive item B with serial number SN100 in any organization.
-
Within an Organization: In addition to the Within Inventory Items restrictions, the same serial number cannot exist twice within the same organization. For example, if you assign SN100 to item A, you cannot receive item B with the serial number SN100 in the same organization. You can, however, receive item B with the serial number SN100 in any other organization.
-
Across Organizations: In addition to the Within an Organization restrictions, you cannot assign the same serial number to any other item regardless of the organization. For example if you assign SN100 to item A you cannot receive item B with the serial number SN100 in any organization. If you assign Across Organizations uniqueness to any organization it restricts the serial generation in all other organizations. If one organization dictates Across Organizations, all other organizations must do so.
-
-
Optionally, create predefined serial numbers.If you specified Predefined as the serial number control type for an item, you use the Generate Serial Numbers window to define serial numbers for the item. If you specified entry at inventory receipt or at sales order issue, then you can optionally predefine serial numbers for the item.Oracle Inventory uses the starting serial number prefix and the starting serial number that you specify in the Item Master create predefined serial numbers. You can create as many serial numbers as you want for any item under serial number control.
Related Topics
Generating Serial Numbers
If you specified predefined as the serial number control type for an item, you must predefine serial numbers for the 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, but 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.
Prerequisites
- Establish serial control for an item. See Defining Items and Inventory Attribute Group for information on creating items and establishing serial number control.
To generate serial numbers
-
Navigate to the Generate Serial Numbers window or All Reports window.
-
Enter Serial Generation in the Name field. The Parameters window opens.
-
Enter an item that is under serial number control.
-
Enter a quantity of serial numbers to define and reserve for the item. The quantity must be a positive integer.
-
Click Submit to launch the process.
Related Topics
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 assign serial numbers only 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
-
Resides intransit
-
-
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.
Related Topics
Assigning Serial Numbers
Under serial number control, you must specify a serial number to each item that you issue or receive. In the Serial Number Entry window, you choose serial numbers for the item quantity to issue or receive. You can view this window only when you establish serial number control for the item that you issue or receive.
To assign serial numbers to the item quantity to issue or receive
-
Click the Lot/Serial button from a transaction window. The Serial Number Entry window appears displaying the item and transaction information.Note: If the lot is under lot and serial control, you must enter the lot information before you can assign serial numbers.The Serial Entry window displays the item, revision, lot, subinventory, locator, UOM, quantity, and quantity entered. The Quantity field displays the total transaction quantity, and the Quantity Entered field displays the item quantity you have assigned to serial numbers.
-
Indicate whether to enter a range of serial numbers, or individual serial numbers for each item or lot quantity.If you select a range of serial numbers, the system assigns each item in the line item or lot quantity to a serial number within the range.Note: You can enter a range of serial numbers only if the serial number ends in a number. If the serial number ends in a character, you must enter each serial number individually.
-
Enter a serial number for an individual item, or a beginning serial number for the range.
-
If you are using a serial number range, enter an ending serial number for the range. The default is the last serial number that was calculated from the starting serial number and transaction quantity.Note: The system automatically calculates the maximum valid contiguous serial number for the range. If a serial number within the range is already assigned to an item, then the system stops the range before that item, and you must enter a new beginning and ending range for the remaining quantity.
-
If you selected Individual for the serial number entry mode, enter the desired serial numbers.
-
Click Done to return to the Transaction Lines window.
Maintaining Serial Number Information
You can view location, job, and serial state information, as well as update supplier information that is associated with your serialized units.
To display serial number information
-
Navigate to the Serial Numbers window. The Find Serials window appears.
-
Enter search criteria. If you do not enter any search criteria, then the system queries for all serial numbers.Important: If you want to view serial numbers across organizations, you must clear the Organization column.
-
Click Find to display the serial number and item information in the Serial Numbers window.
To view location and job information
-
Click the Subinventory / Job tab.This region contains the serial number, item number, current organization, revision, subinventory, locator, job, current operation, current step, and lot. You cannot edit these fields.Important: The Job field displays only open jobs that are currently in the process of building the serial unit.
To view the serial information
-
Click the Serial Info tab.This region contains the serial state, status, receipt date, ship state, and associated attributes.The inventory state of the serialized unit can be: defined but not used, resides in stores, issued out of stores, or resides in intransit.
-
Modify the status if needed The available choices are:
-
Active
-
QC Hold
-
Quarantine
-
To update supplier information
-
Click the Supplier tab.
-
Enter the supplier name, lot number, and serial number information.
-
Save your work.
To view the unit number of a serialized item
-
If Oracle Project Manufacturing is installed, and you enabled end item model/unit effectivity, then you can click the Unit Number tab to view the unit number of a serialized item. See Model/Unit Effectivity, Oracle Project Manufacturing Implementation Manual.
To view the serial genealogy of a serialized item
-
Click View Genealogy. See Viewing Serial Genealogy.
To view material transactions for a serialized unit
-
Select a serialized item.
-
Click Transactions. See Viewing Material Transactions.
Related Topics
Overview of Creating Discrete Jobs, Oracle Work in Process User's Guide
Viewing Serial Genealogy
Serial genealogy tracks the transaction and multilevel composition history of any serial-controlled item from receipt to customer sale. The composition genealogy is captured through material transactions in Oracle Work in Process and Oracle Process Manufacturing.
The serial genealogy appears in a graphical display, and you can trace an assembly down through all of its components or from the component to an assembly. This genealogy tracing enables you to expedite problem isolation and improve customer response times. Serial genealogy also helps you to track and regulate supplier performance and quality.
You can view the transaction history of the serial across all organizations and view the current organization where the serial resides.
When issuing serialized components to serial controlled assemblies, you must associate the component serial number with the assembly serial number. See Issuing and Returning Specific Components, Oracle Work in Process User's Guide.
Note: If the component has a supply type of Push, the association occurs at WIP Issue. If the component has a supply type of Operation Pull, the association occurs at WIP Move. If the component has a supply type of Assembly Pull, the association occurs at WIP Completion.
If the item is under lot control, then you can also view the lot genealogy for the same item. When you view the genealogy of the item, the system lists the item number, followed by the lot number, and finally the serial number.
Prerequisites
- Define Serial Generation attribute
-
You must set the Serial Generation attribute in the Item Master window to at receipt or predefined for the component items.For assembly items, you must set the Serial Generation attribute in the Item Master window to Predefined. Before you issue material to WIP, you must generate the serial numbers. See Generating Serial Numbers.This rule includes any subassemblies for which you want to track the genealogy. See Updating Organization Level Items and Inventory Attribute Group.
To view the serial genealogy of a serialized item
-
Navigate to the Serial Numbers window. The Find Serial Numbers window appears.
-
Enter search criteria to locate the item or items for which you want to view the serial genealogy.
-
Click Find to display the serial number and item information in the Serial Numbers window.
-
Select the item serial number for which you want to view the serial genealogy.
-
Click View Genealogy. The Object Genealogy window appears. The source tab appears.
-
Click Genealogy to display the genealogy.The Genealogy window appears. The genealogy appears in a graphical display, allowing you to trace the serial history. The left pane is in a tree format containing two tabs for different views:
-
Source displays the source of the record that you are viewing. It is designated by assembly name, appended by the job name, at the top node of the tree. For example, you may be producing a specific job from components of a particular serial. Material used in this assembly-job combination is expanded under the top node.
-
Where Used displays the assembly where this material is used. It is designated by assembly name, appended by the job name, at the top node of the tree. The assembly and job combinations using this top record are expanded below it.
-
-
If the item is lot and serial controlled, then the system displays the lot and the associated serial number in the tree. The Item Details alternative region contains information about the item, such as the item number and organization where the item resides. The Serial Details alternative region contains information about the particular serial number such as the serial state, serial material status, current lot if the serial is under lot control, and WIP job information if the serial is part of a WIP job.
-
Click the Lot Attributes tab if the serial is under lot control. The Item Details alternative region displays details about the item, and the Lot alternative region displays information about the lot. It provides you with the lot number, and other associated lot information such as the lot grade and lot material status. The Origination alternative region provides you with information about where the lot was created, and the type of transaction you used to receive it in to inventory. It also provides you with the document type used to receive it in to inventory.
-
Click the Work Order details tab if the serial is associated with a WIP job. If the serial is not associated with a WIP job, then you cannot click the tab. The Work Order details alternative region displays information about the job, such as the job status and when it was released and completed. It also contains the job quantity, the scrapped quantity, and the remaining quantity to complete. The Product Details alternative region contains information about the product, such as the product name, description, and quantity planned for the job.
-
Click the Material Transactions tab to view the material transactions that are associated with the serial. The Item Details alternative region displays information about the item. The Transaction Details alternative region displays item transactional information, such as the transaction date, subinventory, and transaction type.
-
Click the Pending Transactions tab to view pending transactions for the serial. Pending transactions are actions that you performed on the serial, but are not completed by the transaction manager. The Item Details alternative region displays information about the item. The Transaction Details alternative region displays item transactional information, such as the transaction date, subinventory, and transaction type.
-
Click the Components tab to see the components used in the item production with their associated quantities. You can click this tab only if you view by Source. You can also restrict the Components tab to honor formula security. You can restrict formula security by user or responsibility. Three levels of security are available: Update, View-Only, and Hidden. When a user tries to access the genealogy of serial to which he or she does not have formula access, the system displays a warning message.The Item Details alternative region displays information about the item, such as the item number and organization where the item resides. The Component Details alternative region contains detailed component information, such as the associated job or batch if applicable, and the component item number and description.
-
Click the Products tab to view the products manufactured with this serial as an ingredient. You can click this tab only if you view by Where Used. The Item Details alternative region contains information about the item, such as the item description and the current organization where it resides. The Product Details alternative region displays details about the product manufactured with this serial as an ingredient, such as the product name and description.
-
Click the Quality Sample tab to view process manufacturing quality information. You enable process quality on the Item Master. The Item Details alternative region displays information about the item, such as the item number and the current organization where the item resides. The Quality Data alternative region displays information, such as the sample number, sample source, and quality results
-
If you have Oracle Quality installed, you can define serial number as a collection element. If the serial is not associated with the quality data, you cannot see it in the Quality Collections tab. The Item Details alternative region displays information about the item, such as the item number and the organization where the item currently resides. The Quality Data alternative region displays information about the quality collection plan.
-
If you have Oracle Shop Floor Management installed, you can see the Lot Based Job Transactions tab. The Lot Based Job Transactions tab displays the Oracle Shop Floor Management transactions, such as splitting, merging, bonus lots, and updating assemblies. It displays the previous values for WIP Lot Name, Start Quantity, and Assembly Number, and the resulting values after the transaction.
Related Topics
Maintaining Serial Number Information.
Serial Number Control Reports
Oracle Inventory provides the following inquiries and reports for tracking serial numbers.
Serial Number Transactions Register
You can use the Serial Number Transactions Register to report comprehensive details about material transactions for serial numbers 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 the primary or transacted unit of measure. See Serial Number Transaction Register.
Serial Number Detail Reports
You can use the Serial Number Detail report to report on information about current serialized units in your organization for a specific source type, serialized unit state, or both. Oracle Inventory lets you run the report for a range of serial numbers, items, suppliers, and supplier serial numbers. See Serial Number Detail.
Serial Number Control
Oracle Inventory provides complete serial number support for inventory transactions. You can enable serial number control for specific items. For items that are under serial number control, you assign unique serial numbers to individual units and reference the same serial numbers each time you perform a transaction on an individual unit. This enables you to have tight control over every unit of every item in your inventory. If you set up serial control at sales order issue, then at sales order issue, you can assign serial numbers only when you perform a shipment transaction in Oracle Shipping Execution.
Serial Number Validation
Oracle Inventory provides the profile option INV: Restrict Receipt of Serials to control the following validations for serial numbers that are used in Oracle Work in Process:
-
Validation of serialized components:If you enable the profile option, then you cannot receive the serial number through purchase order receipt, miscellaneous receipt, or account alias receipt, if that same serial number has been issued to Oracle Work In Process.
-
Validation of serialized end-assemblies:If you enable the profile option, then you cannot complete an end assembly item into Oracle Inventory, for a discrete job, repetitive schedule, flow schedule, and work order-less completion, if that same serial number has a state of issued out of stores.
Maintaining Serial Number
You can use the Serial Numbers window to update supplier information that is associated with your serial numbers. You can view all serial numbers that you created in your current organization and the state and supplier lot information that is associated with your serial numbers. See Maintaining Serial Number Information.
Issuing Material from Inventory
If you issue items with a serial number control type of dynamic entry at inventory receipt or predefined, then you must choose from the list of serialized units that you have already received into inventory. If you issue items with a serial number control type of dynamic entry at sales order issue, then you must assign serial numbers when you ship the item against a sales order. See Assigning Serial Numbers, Overview of Material Control, Oracle Work in Process User's Guide, and Overview of Shop Floor Control, Oracle Work in Process User's Guide.
Cycle Counting
Oracle Inventory supports cycle counting of items under serial number control.
Performing Physical Inventories
Oracle Inventory includes the serial numbers of the items to count in your physical inventory when it generates tags. You must assign serial numbers to all items under serial number control for which you enter counts in the Physical Inventory Tag Counts window. See Entering and Voiding Physical Inventory Tag Counts.
Pick Releasing Sales Orders with Serial Controlled Items
Note: The following behavior is valid only for serial controlled items whose serial control generation is defined as At Receipt or Predefined. (These values are set on the Master Item window > Inventory tab.)
In Oracle Inventory, suppose you have a sales order with multiple lines including a line with a serial-controlled item. (Also, at the organization level, the parameter Allocate Serial Numbers is set to No. This value is set on the Organization Parameters window > Revision, Lot, Serial And LPN tab.) If pick release is run with auto allocate and auto pick confirm set to Yes, then the pick release completes with a warning. All the lines will be processed except the line containing the serial control item. An error message appears in the pick release log. For the serial records, you then need to manually allocate the serial number in the Transact Move Orders window and then transact the move order line.
Assigning Serial Numbers to Assemblies
When you receive into inventory a completed assembly with a serial number control type of dynamic entry at inventory receipt or predefined, then you must assign a serial number in the WIP Completion Transaction window in Oracle Work in Process. You either accept the default serial number or enter another valid one. See Overview of Assembly Completions and Returns, Oracle Work in Process User's Guide.
Returning Serialized Units to Suppliers
You can return serialized units to the supplier in the Enter Returns and Adjustments window. Oracle Inventory updates the serial number information with the purchase order number and transaction date of the return so that the location of the serialized unit is known.
When you receive replacement units, you can issue new serial numbers. When you receive repaired units, you should reference the original serial numbers so that Oracle Inventory can properly update the existing serial numbers. See Entering Returns, Oracle Purchasing User's Guide.
Purging Serial Number Transactions
You can purge all transaction information about serial numbers from your current organization. Note that the transactions must occur within closed accounting periods. See Purging Transaction History.
Related Topics
Serial Number Restrictions for Transferring Between Organizations
The system places certain restrictions on serial controlled items that you transfer between organizations where the serial control in the source and destination organizations is different. The following tables explain the expected results.
Direct Inter organization Shipment
Source Org / Destination Org | At Receipt or Predefined | At Sales Order Issue | None |
---|---|---|---|
At Receipt of Predefined | Allowed, serial moved to destination. | Allowed, serial number created as sales order issue. | Allowed, serial entered at issue and set to issued from stores in source organization. No serial received in destination organization. |
At Sales Order Issue | Not allowed. | Allowed, serial number dynamic entered at issue. | Allowed, no serial created or moved. |
None | Not allowed. | Allowed, serial number created at sales order issue. | Allowed, no serial created or moved. |
Intransit Inter organization Shipment
Source Org / Destination Org | At Receipt or Predefined | At Sales Order Issue | None |
---|---|---|---|
At Receipt or Predefined | Allowed, user prompted for serial at receipt from the list of values of shipped serials, serials received to destination location. | Allowed, user prompted for serial at receipt from LOV of shipped materials, serial received to destination organization but set to defined but not used. | Allowed, serial entered at issue and set to issued from stores in source organization. No serial received in destination. |
At Sales Order Issue | Allowed, no serials issued. New serials generated at receipt. | Allowed, no serials issued or received. | Allowed, no serials issued or received. |
None | Allowed, no serials issued. New serials generated at receipt. | Allowed, no serials issued or received. | Allowed, no serials issued or received. |
Direct Internal Requisition
Source Org / Destination Org | At Receipt or Predefined | At Sales Order Issue | None |
---|---|---|---|
At Receipt or Predefined | Allowed, serial moved to destination. | Allowed, set serial to defined but not used in destination organization. | Allowed, serial set at issued from stores in source organization. |
At Sales Order Issue | Not allowed. | Allowed, serial moved to destination organization but set to defined but not used. | Allowed, serial set at issued from stores in source organization. |
None | Not allowed. | Allowed, not serial created or moved. | Allowed, no serial created or moved. |
Intranist Internal Requisition
Source Org / Destination Org | At Receipt or Predefined | At Sales Order Issue | None |
---|---|---|---|
At Receipt or Predefined | Allowed, user prompted for serial at receipt from LOV or shipped serials, serial received to destination location. | Allowed, user prompted for serial at receipt from LOV of shipped serials, serial received to destination organization, but set to defined but not used. | Allowed, serial set at issued from stores in source organization, user not prompted for serial at receipt. |
At Sales Order Issue | Allowed, user prompted for serial at receipt from LOV of shipped serials, serial received to destination location. | Allowed, user prompted for serial at receipt from LOV of shipped serials, serial received to destination organization, but set to defined but not used. | Allowed, serial set at issued from stores in source organization, user not prompted for serial at receipt. |
None | Allowed, serials generated at receipt. | Allowed, no serial issued or received. | Allowed, no serial issued or received. |
Related Topics
Customizing the Presentation of Data in a Folder, Oracle Applications User's Guide
Setting Up Serial Number Control
Before you can use serial number control, you must set the item attributes and organization parameters:
To set up serial number control
-
You define serial number control and other item attributes for an inventory item on the Item Master window. You can choose from No control, Predefined, At inventory receipt, or At sales order issue. See Inventory Attribute Group.Important: If you select Predefined as the serial number control type for an item, use the Generate Serial Numbers window to define serial numbers for the item. If you specified entry at inventory receipt or at sales order issue, then you can optionally predefine serial numbers for the item. Oracle Inventory uses the starting serial number prefix and the starting serial number that you specify in the Item Master to create predefined serial numbers. You can create as many serial numbers as you want for any item under serial number control.
-
Define the serial control parameters for the organization on the Revision, Lot, Serial And LPN tab on the Organization Parameters window. For more information, see Defining Revision, Lot, Serial, and LPN Parameters.Material classification code tagged items and serial controlled items with the At Receipt and Pre-defined options are mutually exclusive.
Related Topics
Generating Serial Numbers
If you specified predefined as the serial number control type for an item, you must predefine serial numbers for the item. If you specified entry at inventory receipt or at sales order issue, you can optionally predefine serial numbers for the item. If you are generating serial numbers for serial tagged items, the newly-created serial numbers will be in the status Defined but not used.
The process of generating serial numbers does not assign serial numbers to units in inventory, but 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.
Prerequisites
- Establish serial control for an item. See Defining Items and Inventory Attribute Group for information on creating items and establishing serial number control.
To generate serial numbers
-
Navigate to the Generate Serial Numbers window or All Reports window.
-
Enter Serial Generation in the Name field. The Parameters window opens.
-
Enter an item that is under serial number control.
-
Enter a quantity of serial numbers to define and reserve for the item. The quantity must be a positive integer.
-
Click Submit to launch the process.
Related Topics
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, then 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 assign serial numbers only 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
-
Resides intransit
-
-
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.
Related Topics
Overview of Serial Tagging Assignments
Serial tagging enables you to assign and track serial numbers when issuing and receiving material at the organization level. Serial tagging provides additional control and productivity by enabling serial tracking at material issue for the following transaction types:
Transaction Type | Description |
---|---|
WIP Issue | WIP (work in process) Issue |
Return to vendor | Return to vendor from stores. |
Sales Order Pick | Staging transfer on a sales order. |
Internal Order Pick | Staging transfer on an internal order. |
Field service usage | Field service usage. |
Serial numbers for serial tagged transactions can be entered for the following transactions in forms and mobile user interfaces (UI):
Transaction Type | Serial Tagging in Forms and Mobile UIs | Serial Tagging for APIs/Open Interface |
---|---|---|
Internal requisition receipt | Yes | Yes |
RMA Receipt | Yes | Yes |
Sales order /internal sales order picking | Yes | Yes |
Note: Serial tagging will be supported for seeded (system-provided) transaction types only.
Serial tagging is a complementary component of serial control, and depending on your business needs, enables you to define serial control for some items and serial tagging for others.
Serial tagging is used in industries (such as semiconductor industries) that need to assign and track the serial numbers when the components are issued (for example, to the WIP job), rather than tracking on-hand material.
For example, for an item that is serial tagged for WIP Issue, the system will prompt the operator during a WIP Issue transaction to enter a serial number which is then recorded in the serial history.
Serial tagging assignments can be accessed from the following windows:
-
Master Item
-
Organization Item
-
Item Template
Restrictions
-
If the organization is project reference enabled, then serial tagging will not be available for that organization and you cannot perform a serial tagging assignment. For more information on project-referenced organizations, see the Oracle Project Manufacturing Implementation Guide.
-
If any of the following applications is enabled for an organization (in the Organization Parameters window), then serial tagging is NOT applicable for all applications in that organization: Oracle Warehouse Management (WMS), Oracle Process Manufacturing (OPM), Oracle Shop Floor Management (OSFM), Oracle Enterprise Asset Management (Oracle eAM), and Oracle Project Manufacturing (PJM). For example, if you select the WMS Enabled option in the Organization Parameters window for organization M1, then serial tagging is not applicable for all applications in the M1 organization.
Returning Material to Inventory
When material from inventory is issued in a serial-tagged transaction, the serial numbers are recorded in the serial history. When the material is returned to inventory with reference to the original issue transactions, then the system requires that you return the same serial numbers that were issued.
Serial Tagged Items and Serial States
When items are serial tagged, their serial states will alternate between Defined but not Used and Issued Out of Stores. When an issue transaction occurs for a serial tagged item, its status changes to Issued Out of Stores, whereas the corresponding return/receipt transactions changes the status back to Defined but not Used. Therefore, while the serial remains in inventory, the status of the serial stays as Defined but not Used.
The following diagram demonstrates how the serial state changes from Defined but Not Used to Issued Out of Stores when an issue or return/receipt transaction is performed.
The following diagram shows the changes in serial status for serial numbers generated prior to component issue and those generated during component issue. For each activity listed beneath the Activity column, you can identify its corresponding serial status (and flow) by the small circle listed under the Serial Status row; for example, for the activity of Generate Serial the corresponding status is Defined but not Used (the corresponding flow is indicated by the directional arrow):
Related Topics
Setting Up Serial Tagging Assignments
Serial tagging assignments provide better control and improve productivity by enabling serial tracking only at material issues for the following transaction types: WIP issue, return to vendor, and field service usage. You can assign serial tagging for an item (typically when you create or update an item) in the Serial Tagging Assignments window. Serial tagging assignments can be defined at the following levels:
-
Master item
-
Organization item
-
Item template
After an item is serial tagged, whenever an eligible transaction for that item occurs such as a return to vendor issue, the system prompts the operator to enter the serial number for the item.
Note: After an item is set up for serial tagging transactions, the Serial tagging at Issue check box (a display-only field) appears as selected on the Inventory tab of the Master Item window.
Prerequisites
- When enabling serial tagging assignments at either the Master Item or Organization Item levels, either No Control or At Sales Order Issue must be selected in the Generation field (Serial region) on the Inventory tab (select the Inventory tab on the Master Item window or the Organization Item window).
To set up serial tagging assignments
-
Navigate to the Serial Tagging Assignments window.
-
Select the transaction type to identify when serial number tagging occurs for the selected item:
-
WIP IssueWhen WIP issue is serial tagged for an item, during WIP issue, the system will prompt you to enter serial numbers and the same numbers will be recorded in the serial history. If returning the material back to inventory (with reference to the original issue transactions), the original serial numbers need to be returned as well.
-
Return to VendorEnables you to tag serial numbers only at the time of returning the goods to supplier and not at receipt.
-
Sales Order Pick: Enables serial tagging for a staging transfer on a sales order.
-
Internal Order Pick: Enables serial tagging for a staging transfer on an internal order.
-
Field Service UsageEnables you to set the serial tagging at field service issue for the items with serial control.
-
-
Click Save to save the serial tagging assignment(s).
-
Serial tagging will be supported for seeded (system) transaction types only.
-
Oracle Project Manufacturing, Unit Number control is not supported.
-
To copy serial tagging assignments
Use the following procedures to copy items and their serial tagging assignments:
-
Copying item templates using the Copy From window.
-
Copying items /attributes using the Item Attribute Copy window.
The serial tagging feature is applicable only to non-WMS (Oracle Warehouse Management), non-OPM (Oracle Process Manufacturing), non-WSM (Oracle Web Services Manager), non-EAM ( Oracle Enterprise Asset Management), and non-PJM (Oracle Project Manufacturing) organizations. If any of the preceding applications is enabled for an organization, then serial tagging is NOT applicable for all applications in that organization. For example, if organization M1 is an WMS-enabled organization, then serial tagging is not applicable for all applications in the M1 organization.
Serial numbers are not tracked for material that is transacted within the organization from one subinventory to another.
Serial Tagging API
To support serial tagging, Oracle Inventory provides the following packages that contain public application program interfaces (APIs):
Note: For more information about APIs and specific parameters, see the Oracle Integration Repository. Public APIs and related details are maintained in the Oracle Integration Repository and are available from the Oracle E-Business Suite instance. The Oracle Integration Repository is an integral part of Oracle E-Business Suite, and provides a catalog of Oracle E-Business suite's business service interfaces.
Package: INV_SERIAL_NUMBER_PUB APIs (INVPSNB.pls)
This package includes the following APIs for serial tagging:
-
is_serial_controlled(…): Determines whether the transaction requires serial numbers to be entered or processed. If the system has already retrieved the serial number control code, then it is passed as p_serial_control. If not retrieved, the API queries mtl_system_items_b to retrieve it. If the transaction requires serial tagging, then the API returns the value of 2 for x_return_status . Otherwise, it returns the value of 1.
-
is_serial_tagged(…): Receives input parameters as inventory_item_id and organization_id. If serial tagging assignments already exist for the item, then the value of 2 is returned, otherwise the value of 1 is returned.
-
copy_serial_tag_assignments (…): This API copies serial tagging assignments from the source item-organization combination or template to the destination item- organization combination or template.
Package: INV_MO_LINE_DETAIL_UTIL APIs (INVUTLDB.pls)
This package includes the ARE_ALLOCATION_COMPLETE (…) API. If you press the Transact button and serials have not been allocated to a serial tagged item, then this API raises an error message and does not submit the transaction to the transaction manager.
Package: INV_TRANSFER_ORDER_PVT (INVVTROB.pls)
This package includes the FINALIZE_PICK_CONFIRM (…)API that ensures a serial number is assigned when an item is serial tagged.
Package: INV_CACHE APIs (INVCACHB.pls)
This package includes the RMA: GET_SERIAL_TAGGED (…) API to check serial tagging for RMAs.
Assigning Serial Numbers
Under serial number control, you must specify a serial number to each item that you issue or receive. In the Serial Number Entry window, you choose serial numbers for the item quantity to issue or receive. You can view this window only when you establish serial number control for the item that you issue or receive.
To assign serial numbers to the item quantity to issue or receive
-
Click the Lot/Serial button from a transaction window. The Serial Number Entry window appears displaying the item and transaction information.Note: If the lot is under lot and serial control, you must enter the lot information before you can assign serial numbers.The Serial Entry window displays the item, revision, lot, subinventory, locator, UOM, quantity, and quantity entered. The Quantity field displays the total transaction quantity, and the Quantity Entered field displays the item quantity you have assigned to serial numbers.
-
Indicate whether to enter a range of serial numbers, or individual serial numbers for each item or lot quantity.If you select a range of serial numbers, the system assigns each item in the line item or lot quantity to a serial number within the range.Note: You can enter a range of serial numbers only if the serial number ends in a number. If the serial number ends in a character, you must enter each serial number individually.
-
Enter a serial number for an individual item, or a beginning serial number for the range.
-
If you are using a serial number range, enter an ending serial number for the range. The default is the last serial number that was calculated from the starting serial number and transaction quantity.Note: The system automatically calculates the maximum valid contiguous serial number for the range. If a serial number within the range is already assigned to an item, then the system stops the range before that item, and you must enter a new beginning and ending range for the remaining quantity.
-
If you selected Individual for the serial number entry mode, enter the desired serial numbers.
-
Click Done to return to the Transaction Lines window.
Maintaining Serial Number Information
You can view location, job, and serial state information, as well as update supplier information that is associated with your serialized units. You can also query by serial numbers to find serial tagged items.
To display serial number information
-
Navigate to the Serial Numbers window. The Find Serials window appears.
-
Enter your search criteria. If no search criteria is entered, then the system queries for all serial numbers.Important: To view serial numbers across organizations, deselect the Organization column.
-
Click Find to display the serial number and item information in the Serial Numbers window.
To view location and job information
-
Click the Subinventory / Job tab.This region contains the serial number, item number, current organization, revision, subinventory, locator, job, current operation, current step, and lot. You cannot edit these fields.Important: The Job field displays only open jobs that are currently in the process of building the serial unit.
To view the serial information
-
Click the Serial Info tab.This region contains the serial state, status, receipt date, ship state, and associated attributes.The inventory state of the serialized unit can be: defined but not used, resides in stores, issued out of stores, or resides in intransit.
-
Modify the status if needed. The available choices are:
-
Active
-
QC Hold
-
Quarantine
-
To update supplier information
-
Click the Supplier tab.
-
Enter the supplier name, lot number, and serial number information.
-
Save your work.
To view the unit number of a serialized item
-
If Oracle Project Manufacturing is installed, and you enabled end item model/unit effectivity, then you can click the Unit Number tab to view the unit number of a serialized item. See Model/Unit Effectivity, Oracle Project Manufacturing Implementation Manual.
To view the serial genealogy of a serialized item
-
Click View Genealogy. See Viewing Serial Genealogy.
To view material transactions for a serialized unit
-
Select a serialized item.
-
Click Transactions. See Viewing Material Transactions.
Related Topics
Overview of Creating Discrete Jobs, Oracle Work in Process User's Guide
Viewing Serial Genealogy
Serial genealogy tracks the transaction and multilevel composition history of any serial-controlled item from receipt to customer sale. The composition genealogy is captured through material transactions in Oracle Work in Process and Oracle Process Manufacturing.
The serial genealogy appears in a graphical display, and you can trace an assembly down through all of its components or from the component to an assembly. This genealogy tracing enables you to expedite problem isolation and improve customer response times. Serial genealogy also helps you to track and regulate supplier performance and quality.
You can view the transaction history of the serial across all organizations and view the current organization where the serial resides.
When issuing serialized components to serial controlled assemblies, you must associate the component serial number with the assembly serial number. See Issuing and Returning Specific Components, Oracle Work in Process User's Guide.
Note: If the component has a supply type of Push, the association occurs at WIP Issue. If the component has a supply type of Operation Pull, the association occurs at WIP Move. If the component has a supply type of Assembly Pull, the association occurs at WIP Completion.
If the item is under lot control, then you can also view the lot genealogy for the same item. When you view the genealogy of the item, the system lists the item number, followed by the lot number, and finally the serial number.
Prerequisites
- Define Serial Generation attribute
-
You must set the Serial Generation attribute in the Item Master window to at receipt or predefined for the component items.For assembly items, you must set the Serial Generation attribute in the Item Master window to Predefined. Before you issue material to WIP, you must generate the serial numbers. See Generating Serial Numbers.This rule includes any subassemblies for which you want to track the genealogy. See Updating Organization Level Items and Inventory Attribute Group.
To view the serial genealogy of a serialized item
-
Navigate to the Serial Numbers window. The Find Serial Numbers window appears.
-
Enter search criteria to locate the item or items for which you want to view the serial genealogy.
-
Click Find to display the serial number and item information in the Serial Numbers window.
-
Select the item serial number for which you want to view the serial genealogy.
-
Click View Genealogy. The Object Genealogy window appears. The source tab appears.
-
Click Genealogy to display the genealogy.The Genealogy window appears. The genealogy appears in a graphical display, allowing you to trace the serial history. The left pane is in a tree format containing two tabs for different views:
-
Source displays the source of the record that you are viewing. It is designated by assembly name, appended by the job name, at the top node of the tree. For example, you may be producing a specific job from components of a particular serial. Material used in this assembly-job combination is expanded under the top node.
-
Where Used displays the assembly where this material is used. It is designated by assembly name, appended by the job name, at the top node of the tree. The assembly and job combinations using this top record are expanded below it.
-
-
If the item is lot and serial controlled, then the system displays the lot and the associated serial number in the tree. The Item Details alternative region contains information about the item, such as the item number and organization where the item resides. The Serial Details alternative region contains information about the particular serial number such as the serial state, serial material status, current lot if the serial is under lot control, and WIP job information if the serial is part of a WIP job.
-
Click the Lot Attributes tab if the serial is under lot control. The Item Details alternative region displays details about the item, and the Lot alternative region displays information about the lot. It provides you with the lot number, and other associated lot information such as the lot grade and lot material status. The Origination alternative region provides you with information about where the lot was created, and the type of transaction you used to receive it in to inventory. It also provides you with the document type used to receive it in to inventory.
-
Click the Work Order details tab if the serial is associated with a WIP job. If the serial is not associated with a WIP job, then you cannot click the tab. The Work Order details alternative region displays information about the job, such as the job status and when it was released and completed. It also contains the job quantity, the scrapped quantity, and the remaining quantity to complete. The Product Details alternative region contains information about the product, such as the product name, description, and quantity planned for the job.
-
Click the Material Transactions tab to view the material transactions that are associated with the serial. The Item Details alternative region displays information about the item. The Transaction Details alternative region displays item transactional information, such as the transaction date, subinventory, and transaction type.
-
Click the Pending Transactions tab to view pending transactions for the serial. Pending transactions are actions that you performed on the serial, but are not completed by the transaction manager. The Item Details alternative region displays information about the item. The Transaction Details alternative region displays item transactional information, such as the transaction date, subinventory, and transaction type.
-
Click the Components tab to see the components used in the item production with their associated quantities. You can click this tab only if you view by Source. You can also restrict the Components tab to honor formula security. You can restrict formula security by user or responsibility. Three levels of security are available: Update, View-Only, and Hidden. When a user tries to access the genealogy of serial to which he or she does not have formula access, the system displays a warning message.The Item Details alternative region displays information about the item, such as the item number and organization where the item resides. The Component Details alternative region contains detailed component information, such as the associated job or batch if applicable, and the component item number and description.
-
Click the Products tab to view the products manufactured with this serial as an ingredient. You can click this tab only if you view by Where Used. The Item Details alternative region contains information about the item, such as the item description and the current organization where it resides. The Product Details alternative region displays details about the product manufactured with this serial as an ingredient, such as the product name and description.
-
Click the Quality Sample tab to view process manufacturing quality information. You enable process quality on the Item Master. The Item Details alternative region displays information about the item, such as the item number and the current organization where the item resides. The Quality Data alternative region displays information, such as the sample number, sample source, and quality results
-
If you have Oracle Quality installed, you can define serial number as a collection element. If the serial is not associated with the quality data, you cannot see it in the Quality Collections tab. The Item Details alternative region displays information about the item, such as the item number and the organization where the item currently resides. The Quality Data alternative region displays information about the quality collection plan.
-
If you have Oracle Shop Floor Management installed, you can see the Lot Based Job Transactions tab. The Lot Based Job Transactions tab displays the Oracle Shop Floor Management transactions, such as splitting, merging, bonus lots, and updating assemblies. It displays the previous values for WIP Lot Name, Start Quantity, and Assembly Number, and the resulting values after the transaction.
Related Topics
Maintaining Serial Number Information.
Serial Number Control Reports
Oracle Inventory provides the following inquiries and reports for tracking serial numbers.
Serial Number Transactions Register
You can use the Serial Number Transactions Register to report comprehensive details about material transactions for serial numbers 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 the primary or transacted unit of measure. See Serial Number Transaction Register.
Serial Number Detail Reports
You can use the Serial Number Detail Reports to report on information about current serialized units in your organization for a specific source type, serialized unit state, or both. Oracle Inventory lets you run the report for a range of serial numbers, items, suppliers, and supplier serial numbers. See Serial Number Detail.