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. How to get VAT_TYPE and UNFIED_CATALOGING data loaded into ARC via ETL

    How to get VAT_TYPE and UNFIED_CATALOGING data loaded into ARC via ETL

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

    Description:
    In our p_arc_01.log files, we are noticing that three components are "successfully loaded" with "0 of 0" records, indicating that they are not getting included in the ARC ETL load. The three relevant lines from our p_arc_01.log file are:
    Table mrr_opac Successfully Loaded 0 of 0
    ...
    Table mrr_unfied_cataloging Successfully Loaded 0 of 0
    Table mrr_vat_type Successfully Loaded 0 of 0
    It appears that the OPAC table is empty because we had not created the Z69 table and index in ALEPH. We have now done this, and are hoping that this will solve that issue.
    We are not as clear how to resolve the other two lines. If you have any information on what needs to be done to get these tables populated with data, we would appreciate it.

    Resolution:
    In document “Aleph to MRR Mapping.pdf”, are found:
    [1] source table = tab_vat_percent.lng
    Destination table = MRR_VAT_TYPE
    [2] source table = Z106
    Destination table = MMR_UNFIED_CATALOGING
    Since neither of these options are activated in ALEPH, this explains the lack of data in the ARC tables.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to get USMnn Oracle tables / Demo libraries
      • How to give staffers rights to work in 2 different ADM's; z66_user_library
    • Was this article helpful?

    Recommended articles

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