Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Determining maximum z68_order_number

    Determining maximum z68_order_number

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    This incident is regarding the Order Number Counter from the Acquisition/Serials module. Since the library upgraded to version 18, the Acquisition staff is adding manually the number for the "Order Number" to new orders. However, according to the experience of people that are working with the system longer than me, (in ALEPH previous version) the number was added automatically by the system.

    So, I believe that the problem is that during the upgrade someone forgot to change the following parameter in the ACQ.INI file:

    From:
    [OrderNumber]
    EnablePrefix=N
    PrefixString=uarcv

    To:
    [OrderNumber]
    EnablePrefix=Y
    PrefixString=ABC

    This part of the problem I can fix by updating the ACQ.INI file from the libraries PCs. But now there is a need to reset the order number counter in the server side (util g/2). According to the acquisition personal, the last number that was used is FHL-1377.

    We need to determine if there is any z68_order_number which is higher than this.

    Resolution:
    The highest order number with the prefix "ABC-" is ABC-2027:

    SQL> select max(z68_order_number) from z68 where z68_order_number like 'ABC-%' and substr (z68_order_number,5,25) > 1377;
    **** Hit return to continue ****

    MAX(Z68_ORDER_NUMBER)
    ------------------------------
    ABC-2027


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Determine Version of OpenSSL Software used by an Ex Libris Product
      • Determining Number of Patrons Added to Database Since a Certain Date
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved