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. Order record without ADM?

    Order record without ADM?

    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: 18.01

    Description:
    If a record DOES NOT have an ADM linked to it, then does this positively mean that an order record is not attached?

    Resolution:
    Though a z68 record could theoretically exist without an ADM record, that would be an error and such a record would not be usable.

    You can do this to see if such cases exist:

    s+ abc50
    SQL-abc50> select substr (z68_rec_key,1,9) from z68 minus select z00_doc_number from z00;

    If the ADM record exists but is deleted ("DEL Y" field), the record will not be found by the preceding SQL. The following SQL will find it:

    SQL-abc50> select to_number(substr(z68_rec_key,1,9)) from z68 minus select Z103_LKR_DOC_NUMBER from z103 where Z103_LKR_LIBRARY='ABC50';

    And the following SQL can be done to locate Z601 records whose ADM doc record does not exist or is deleted:

    SQL-abc50> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ substr(Z601_REC_KEY_3,1,9) from z601 where substr(Z601_REC_KEY_3,1,9) ^= '000000000' minus select substr (z103_rec_key,6,9) from z103 where Z103_LKR_LIBRARY='ABC50';

    Note: As described in KB 8192-3738, this condition can cause z13 errors in running p_acq_06.

    Additional Information

    order, adm, faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Order purge
      • Order records deleted -- any way to tell how?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. 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