Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Order record without ADM?

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

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

    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
    • Was this article helpful?