Determining maximum z68_order_number

• 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