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

    ARC: Error RQP-DEF-0177 selecting Price parameter

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

    Problem Symptoms:
    * Error RQP-DEF-0177 is displayed in Query Report selecting Price parameter

    Cause:
    * The item Price field was added to the ETL process by rep_change 2373 in Aleph 20.
    * In Aleph 18 the ETL process is not extracting this field.
    * Since there is a mismatch between the Aleph and ARC versions, this field only exist in the new ARC version but is not actually extracted from Aleph 18.

    Resolution:
    * The item Price field was added to the ETL process by rep_change 2373 in Aleph 20

    Description: ARC - The following fields have been added to the ARC Presentation Layer:

    1) Check in Note (z16_check_in_note)
    2) Discard Bind (z16_discard_bind)
    3) Item Total No. of Loans (z30_no_loans)
    4) Item Price (z30_price)
    5) OPAC Note (z30_note_opac)
    6) Item Cataloger (z30_cataloger)
    7) Process Status Update Date (z30_process_status_date)
    8) Process Status Filter (z37_filter_process_status)
    9) Library Note (z68_library_note)
    10) Shipment Cost (z77_i_ship_amount)
    11) Overhead Cost (z77_i_over_amount)
    12) Insurance Cost (z77_i_insu_amount)
    13) Discounted Amount (z77_i_disc_amount)
    14) Invoice Note (z77_i_note)
    15) Note (z601_note)
    16) Gender (z303_gender)
    17) Address Type (z304_address_type)

    Category: Reports (ARC)


    • Article last edited: 10/8/2013