Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. update_cursor_z700

    update_cursor_z700

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    [This article duplicates Article 000040326 ("Oracle error: update_cursor z700; ... table or view does not exist") and has been archived.]

    Problem Symptoms:
    Error message from Oracle appears when trying to save or load a patron record (z303):

    Oracle error: update_cursor z700
    ORA-00942: table or view does not exist

    Cause:


    Resolution:
    Version 19-up: [tab100 ILL-MODE obsolete:]
    The check_z303 program calls io_z700 (Z700 = ILL partner) only if the z303_ill_library (field "Ill Unit" in patron record) is not blank. If the z303_ill_library is blank (-- which it *should* be if you are not using ILL), check_z303 will not look for an associated z700.

    You may ignore this error message or delete the information from field "Ill unit" in patron record (Circulation module).

    If you are getting this error in running p_file_20, consult KCS 17986.

    Additional Information

    Version 18:
    The check_z303 program calls io_z700 only if the z303_ill_library is not blank and TAB100-ILL-MODE = "2" (indicating that use of the "New GUI" ILL). If TAB100-ILL-MODE does not = 2, then the program checks the z303_ill_library against tab_sub_library, looking for a matching sublibrary code, type "6" (ILL unit). If the z303_ill_library is blank (-- which it *should* be if you are not using ILL --), check_z303 will not look for an associated z700.

    Category: Circulation/ALEPH

    Subject: ALEPH - 500


    • Article last edited: 4/4/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Update AIK and Upgrade Express docs to prevent Demo Libs load problems
      • Update date is earlier than open date
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. ALEPH - 500
      3. Circulation/ALEPH
      4. contype:kba
      5. Prod:Aleph
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved