• 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.