Serials are not available in Mtl_serials table after WIP completion
Problem:
Serials are not available in Mtl_serials table after WIP completion. Old
SR number is 3-6930862081, for the previous SR, Oracle has provided the
below action plan:
Before inserting records into mtl_serial_numbers_interface.
Do a validation using following SQL:
Select Count(1)
From Mtl_Serial_Numbers
Where Inventory_Item_Id = &p_Inventory_Item_Id
And Current_Organization_Id = &p_Organization_Id
And Serial_Number = &p_Serial_Number;
If this SQL return 1, then you insert records into the interface table.
Otherwise, raise an exception.
If you did this validation.
I think exception 'WMS_CONT_INVALID_X_QTY' will not be raised any more.
Before inserting records into mtl_serial_numbers_interface.
Do a validation using following SQL:
Select Count(1)
From Mtl_Serial_Numbers
Where Inventory_Item_Id = &p_Inventory_Item_Id
And Current_Organization_Id = &p_Organization_Id
And Serial_Number = &p_Serial_Number;
If this SQL return 1, then you insert records into the interface table.
Otherwise, raise an exception.
If you did this validation.
I think exception 'WMS_CONT_INVALID_X_QTY' will not be raised any more.
0