Tuesday, August 19, 2014

Setting Up Serial Number Control in Oracle Inventory

Oracle Inventory provides robust serial control for your organization. Before you start using serial number control, you must set the item attributes and organization parameters:
  • Setting Up Serial Number Control for an item :-
    We establish serial number control for an inventory item when you define it on the Item Master. If we don’t want to control serial attribute at Master Organization level we can set at child / transaction organization. You can choose from No control, Predefined, At inventory receipt, or At sales order issue.
    • No Control – If set to ‘No Control’, item will be termed as Non-Serial controlled
    • Predefined – If set to ‘Predefined’, serial number will be set for item before its used. In this case we generate the serial number first and then use it.
    • At Inventory Receipt – If set to ‘At Inventory Receipt’, serial number will be generated when the device is received into that organization. This is mostly used in Service/Repair business.
    • At Sales Order Issue – If set to ‘At Sales Order Issue’, serial number will be generated when we ship device for the organization. Serial Number will be generate based on the prefix and suffix setup.
 
  • Serial Number Uniqueness :-
    We use organization parameter 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:
    Image 464Image 465 
    • 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 TAN0100 to item XTA900, you cannot assign serial number TAN0100 to any other instance of item XTA900 in any organization. This also includes CTO/ATO items derived from base model XTA900. However you could receive item XTB900 with serial number TAN0100 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 TAN0100 to item XTA900, you cannot receive item XTB900 with the serial number TAN0100 in the same organization. You can, however, receive item XTB900 with the serial number TAN0100 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 TAN0100 to item XTA900 you cannot receive item XTB900 with the serial number TAN0100 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.
    • Within Inventory Model and Items : When uniqueness is Within Inventory Items, you cannot create 2 serial numbers for the same item. But you can have same serial for 2 items. In CTO/ATO scenario, sometimes this is a problem. So Oracle introduced the new option "Within Inventory Model and Items". In this case, Oracle generates a serial number by using the prefix defined at the Model level. This helps you maintain the uniqueness within all */config item numbers created for a given model.
  • Serial Control - Generation : – It control the level where serial will be controlled.
    • At Item Level : Serial generation will be controlled at item level, define the starting serial number prefix and the starting serial number when you define the item.
    • At Organization Level: Serial will be controlled 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.
  • Allocate Serial Number : -
    • Yes - Select ‘Yes’ if you want the system to suggest serial numbers as part of the move order line allocating process.
    • No – Select ‘No’ If you don’t want serial to be suggested by system. In such case you must manually enter the serial numbers to transact the move order.
ref - Oracle Inventory User Guide

2 comments :

  1. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete
  2. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete

SeachBox