• 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