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