So here I am after a long time with a very short post..don’t mind !!!
Following transactions can be done one a serial controlled unit / serialized unit in a given status : -
There are two ways to go for its, Functional way or Technical Way.. lets see first Functional Way.
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’
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;
Great post! Thanks!!
ReplyDelete