Question

Missing Inventory Barcode id

  • 15 June 2021
  • 5 replies
  • 213 views

Userlevel 6
Badge +14

Can anyone explain why there is missing numbers the inventory barcode sequence?

 

What happened to 39501 ?


This topic has been closed for comments

5 replies

Userlevel 4
Badge +7

Hi Hans,

 

If you RMB on Inventory Part in stock window and assign a Barcode or “Print Barcode Label” it should assign the barcode ID in sequential Order.

The reason which I can imagine is a data repair.

Because, even we scrap the part, Inventory part barcode analysis window or INVENTORY_PART_BARCODE view should get the data.

 

Thanks,

Jagath 

Userlevel 6
Badge +14

Thanks @Jagath Dharmakeethi ,

 

The reason which I can imagine is a data repair.

 

I am not sure what you mean, but the database has never been restore. Only upgrade  from 9 udp 6 to 10 udp 10.

I have a printed barcode label with a number that does not exists in the database. That is a serious problem.  

Userlevel 6
Badge +14

Mystery solved. If creation of a barcode part label is rolled back (e.g. inventory_part_barcode_api.New), then the resulting barcode_id will be skipped on next call.

Userlevel 7
Badge +20

Mystery solved. If creation of a barcode part label is rolled back (e.g. inventory_part_barcode_api.New), then the resulting barcode_id will be skipped on next call.

Hi @Hans Andersen , can you give an example to re-create this / to roll back a part label in the application ?

 

Thanks,

Userlevel 6
Badge +14

 

 

code:

declare 
-- Local variables here
barcode_id_ number;
begin

inventory_part_barcode_api.New(

barcode_id_ => barcode_id_,
contract_ => '1',
part_no_ => '100007',
lot_batch_no_ => '*',
serial_no_ => '*',
eng_chg_level_ => '1',
waiv_dev_rej_no_ => '*',
origin_pack_size_ => 1
);

dbms_output.put_line(barcode_id_);

end;