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. ARC: Error RQP-DEF-0177 selecting Price parameter

    ARC: Error RQP-DEF-0177 selecting Price parameter

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ARC: DWH_FACT_REQUEST.TIME_STAMP missing
      • ARC: error viewing ETL status reports: "You are not authorized to access the object ..."
    • Was this article helpful?

    Recommended articles

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