I need to write an event to print Inventory Part Barcode Label report (no of copies = no of parts received) when parts are received on a Shop Order. I have below code that is working fine for reports without barcodes like Order Confirmation.
I am getting Barcode not created error. Can someone help what other parameters are required to get the barcode
ERROR at line 1:
ORA-20110: InventoryPartBarcode.BARCODEREPEMPT: No data found.
ORA-06512: at "IFSAPP.ERROR_SYS", line 140
ORA-06512: at "IFSAPP.ERROR_SYS", line 354
ORA-06512: at "IFSAPP.INVENTORY_PART_BARCODE_RPI", line 70
ORA-06512: at line 1
Declare
layout_name_ VARCHAR2(300) := 'InventoryPartBarcodeStandard.rpl';
report_id_ VARCHAR2(30) := 'INVENTORY_PART_BARCODE_REP';
report_attr_ VARCHAR2(2000) := '';
parameter_attr_ VARCHAR2(2000) := '';
instance_attr_ VARCHAR2(2000) := '';
print_attr_ VARCHAR2(2000) := '';
attr_ VARCHAR2(2000) := '';
distribution_list_ VARCHAR2(2000) := '';
print_job_id_ VARCHAR2(2000) := '';
printer_id_ VARCHAR2(2000) := 'No Printout,SERVER,NO_PRINTOUT';
result_key_ VARCHAR2(2000) := '';
attr_cf_ VARCHAR2(20000) := '';
info_ VARCHAR2(2000);
BEGIN
client_sys.clear_attr(report_attr_);
client_sys.add_to_attr('REPORT_ID', report_id_, report_attr_);
client_sys.add_to_attr('LAYOUT_NAME', layout_name_, report_attr_);
client_sys.clear_attr(parameter_attr_);
client_sys.add_to_attr('SHOP_ORDER_NO', '9', parameter_attr_);
--client_sys.add_to_attr('BARCODE_ID', 1, parameter_attr_);
client_sys.add_to_attr('RELEASE_NO', '*', parameter_attr_);
client_sys.add_to_attr('SEQUENCE_NO', '*', parameter_attr_);
client_sys.add_to_attr('LINE_ITEM_NO', '-1', parameter_attr_);
client_sys.add_to_attr('PART_NO', 'DE', parameter_attr_);
client_sys.add_to_attr('CONTRACT', 'MT', parameter_attr_);
-- client_sys.add_to_attr('NUMBER_OF_COPIES', 2, parameter_attr_); --Update per requirement
client_sys.clear_attr(print_attr_);
archive_api.new_client_report(result_key_, report_attr_, parameter_attr_, distribution_list_, print_attr_);
archive_api.get_info(instance_attr_, parameter_attr_, result_key_);
client_sys.clear_attr(attr_);
client_sys.add_to_attr('PRINTER_ID', printer_id_, attr_);
print_job_api.new(print_job_id_, attr_);
client_sys.add_to_attr('PRINT_JOB_ID', print_job_id_, instance_attr_);
client_sys.add_to_attr('RESULT_KEY', result_key_, instance_attr_);
print_job_contents_api.new_instance(instance_attr_);
print_job_api.print(print_job_id_);
END ;
