Friday, August 8, 2014

Understanding MTL_SERIAL_NUMBERS.CURRENT_STATUS

So here I am after a long time with a very short post..don’t mind !!!

We often came across using serial number in oracle applications though its shipping the serial for a sales order, a repair order or receiving a serial into inventory. There would be many cases where we have a device in hand with a serial number ready to be shipping but system didn’t allow its saying some error message.. I am not going deep in what all error message comes but the bottom line is where is the serial and what is its current status.
If we query mtl_serial_numbers.current_status it gives back some number which represents its actual status. So lets find out what those numbers represent.
Serial Status
Meaning
1
Defined but not used
3
Resides in stores
4
Issued out of stores
5
Resides in intransit
7
Resides in receiving
8
Resides in WIP



Following transactions can be done one  a serial controlled unit / serialized unit in a given status : -
Serial Status
Transactions
1
Received into or Issued out of stores in any transaction.
3
Issue out of stores in any transaction.
4
Receive into stores in any transaction.
5
Receive into stores by an intransit receipt transaction.

There are two ways to go for its, Functional way or Technical Way.. lets see first Functional Way.
Functional Way :-
  • Login to Oracle Applications
  • Navigate to responsibility – Inventory –> Setup –> Lookups
  • Query for ‘SERIAL_NUM_STATUS’
Image 447

Technical Way :-
Just run the following query and it will give you the details :-

SELECT   lookup_type, lookup_code, meaning
    FROM mfg_lookups
   WHERE lookup_type = 'SERIAL_NUM_STATUS'
ORDER BY lookup_code;

2 comments :

SeachBox