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. p_acq_06 skips records

    p_acq_06 skips records

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

    Description:
    Our year end rollover of budgets worked with one glaring exception. All of our YBP monograph orders that were outstanding (not invoiced) did not rollover. All other orders, mono and serial, did roll as expected.

    Examples:
    German, Poland and Post-Memorial Relations -- #1828359
    Into the breech at Pusan -- #1828360

    parameters used in acq_06:
    start ABC50,mono_2012,Y,00,2012,M,Y,,000,

    Resolution:
    z68_rec_key's 001828373 and 001828374 (the orders for these two bib records) both have z68_invoice_status "C" .

    The b_acq_06_a program calls ./acq/order_active_for_commitment, which has this logic:

    IF INVOICE-STATUS = "C" OR
    INVOICE-STATUS = "D" OR
    Z68-ORDER-STATUS = "CLS" OR
    Z68-ORDER-STATUS = "NEW" OR
    Z68-ORDER-STATUS = "LC" OR
    Z68-ORDER-STATUS = "VC" OR
    Z68-ORDER-STATUS = "DNB" OR
    Z68-ORDER-STATUS = "CNB"
    THEN
    MOVE "N" TO SW-ACTIVE

    This is why p_acq_06 is skipping these orders.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • acq-06-b, Standing orders have an open encumbrance and non-zero Active Amount
      • p_acq_06: "Oracle error: fetch z78 ORA-00600: internal error code ..."
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      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