Missing Inventory Barcode id

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 

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.  

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,

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;