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

    Uniqueness of Additional Order No. 2 / z68_order_number_2

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

    Description:
    In the Order form, we have a field for Order Number 3 - we have labeled it Accession Number, actually.

    In v15, this field did not allow for duplicate entries - it requires unique values. However, in v18, it is allowing for duplicate entries. We need to change this.

    Note: In the as-distributed GUI Acq this field appears as "Additional Order No. 2". In Oracle, it is z68_order_number_2.

    Resolution:
    There are 2 parts to requiring uniqueness of the z68_order_number_2:

    1. You need to have this line in your aleph_start:

    setenv unique_order_number_2 Y

    This is true from v15-up.

    2. The z68_id6 needs to be defined. The z68_id6 is built on the Z68_ORDER_NUMBER_2.
    This Oracle index was added with v18 rep_ver 11486.

    In this case, the z68_id6 was in the file_list but did not exist. Doing util a/17/2 to create it corrected the problem.


    • Article last edited: 10/8/2013