Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    p_cir_03: "ITEM NOT LOANED TO DEPOSITORY " message

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    Why is the "ITEM NOT LOANED TO DEPOSITORY " message generated for items being returned to the depository (offsite storage) after a patron loan?

    Resolution:
    The message "ITEM NOT LOANED TO DEPOSITORY" occurs when the ./butil/b_cir_03_a program goes to look for a z36 (loan) record for a barcode from the input file and either

    (a) doesn't find any z36 or
    (b) finds a z36 whose z36_id doesn't match the item's z30_depository_id field.

    In this case, it is occurring because it is not finding any z36 loan record.

    In the case of barcode 31142000039571, which gets the message "ITEM BARCODE SUCCESSFULY IMPORTED", we see this:

    abc50@ALEPH1> select z30_rec_key from z30 where z30_barcode = '31142000039571';
    **** Hit return to continue ****

    Z30_REC_KEY
    ---------------
    002937515000010


    abc50@ALEPH1> select z36h_loan_date from z36h where z36h_id = 'ABCRS' and z36h_rec_key = '002937515000010';
    **** Hit return to continue ****

    Z36H_LOAN_DATE
    --------------
    20080915
    20090507


    But in the case of barcode 31142045505800, which gets the "ITEM NOT LOANED TO DEPOSITORY", we see this:

    abc50@ALEPH1> select z30_rec_key from z30 where z30_barcode = '31142045505800';
    **** Hit return to continue ****

    Z30_REC_KEY
    ---------------
    000373992000730


    abc50@ALEPH1> select z36h_loan_date from z36h where z36h_id = 'ABCRS' and z36h_rec_key = '000373992000730';

    no rows selected

    abc50@ALEPH1> select z36_loan_date from z36 where z36_id = 'ABCRS' and z36_rec_key = '000373992000730';

    no rows selected

    It *seems* that these barcodes were, for some reason, included in the input file when the items were not actually on loan.


    • Article last edited: 10/8/2013