Acq-06: "Error: Unable to read Z76 record"

Description

Running the job "Renew Order Encumbrances for Monographs/Serials and Standing Orders (acq-06-a/b)" Order Type=Monograph results in error messages such as the following:

  Error: Unable to read Z76 record - KORFD-2020 .

Resolution

Though there's no KORFD-2020  z76 (budget) record, there *are* z601 (budget transaction) records which have "KORFD-2020" as the z601_rec_key (the budget). These are what the acq-06 Service is reading. And these z601 records have a z601_rec_key_3's (order records) which do exist (-- and are connected to actual xxx50 ADM records).

  SQL> select z601_rec_key_3 from z601 where z601_rec_key like 'KORFD-2020%';

In this case, "KORFD-2020" was used when KORFD4-2020 should have been used.  The z601 budget transactions which had "KORFD-2020"  needed to be corrected to "KORFD4-2020".
 

• Article last edited: 24-Jun-2020