Acq client crashes in displaying particular order (or associated invoice)

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

Problem Symptoms:
Acquisitions client crashes trying to display Invoice -- or order 123456-2 which is connected to this invoice.

Cause:
Acq is reading the order record's z601 (budget transaction) records to display amounts committed/spent.
A particular z601 causes the crash. {When the z601_rec_key_3 (the order number) was temporarily changed, the order and invoice displayed without problem.}

Resolution:
Run the following SQL to display the z601 records connected to the order:

SQL> select Z601_REC_KEY, Z601_REC_KEY_2, Z601_ACTIVE_SUM from z601 where z601_rec_key_3 = '00012345600002' order by Z601_ACTIVE_SUM;

{where 00012345600002 is the order key (ADM# + sequence)}.

Examine the results to see if any seem odd/defective.