Skip to main content

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 ;

Hi ​@Ukhalid,

The error "ORA-20110: InventoryPartBarcode.BARCODEREPEMPT: No data found." suggests that the barcode data is missing or not generated for the given part number and shop order.

Check if a barcode exists for the part by running:

SELECT * FROM INVENTORY_PART_BARCODE WHERE PART_NO = 'DE' AND CONTRACT = 'MT';

Also, confirm that 'InventoryPartBarcodeStandard.rpl' is the correct layout for barcode printing.


Reply