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

    ANA: Incorrect report results (MFHD Title)

    • Article Type: General
    • Product: Voyager
    • Product Version: 7.2.3

    Description:
    Bug Report Form for Issue 16384-13186
    Module(s): Analyzer
    Server platform(s) affected: Solaris
    Browser & version (if applicable): IE7

    Release(s) replicated in: Voyager 7.2.0

    Expected results:
    All line items should be listed on a report regardless of the data items added.

    Actual results:
    Some line items are not listed in a report when adding [Invoice Line Item Copy Funds].[MFHD Title Details].[Title] to the report.

    Workflow implications: Reports with this data item are inaccurate.

    Replication steps:
    1. Create a report with the following Report Items making sure one of the results returned has multiple mfhds and that the min(mfhd_id) does not have an entry in line_item_copy_status:
    [Invoice Line Item Copy Funds].[Ledgers/Funds].[Fiscal Period Name]
    [Invoice Line Item Copy Funds].[Invoice Line Item Copy Funds].[Line Item Bib ID]
    [Invoice Line Item Copy Funds].[Ledgers/Funds].[Ledger Name]
    [Invoice Line Item Copy Funds].[Invoice Line Item Copy Funds].[Fund ID]
    [Invoice Line Item Copy Funds].[Ledgers/Funds].[Fund Name]
    [Invoice Line Item Copy Funds].[Ledgers/Funds].[Parent Fund ID]
    [Invoice Line Item Copy Funds].[Invoice Line Item Copy Funds].[Invoice Amount (Base Currency)]
    [Invoice Line Item Copy Funds].[Invoice Line Item Copy Funds].[Copy Invoicing Status Date]
    [Invoice Line Item Copy Funds].[Vendor].[Vendor Code]
    2. Add [Invoice Line Item Copy Funds].[MFHD Title Details].[Title] and some lines will be removed if the lowest mfhd_id associated with the bib record does not have an entry in line_item_copy_status.

    Other information:
    See related bug, issue 16384-12945.
    The problem with the query used by Analyzer to make this report: The difference when MFHD Title is added is slight. Mainly, there is an added clause at the end of 2 to get the title. This is done by linking from LINE_ITEM_COPY_STATUS.MFHD_ID to a MFHD_ID from BIB_MFHD. There are two min() function calls, one of them on the MFHD_ID. So, for each BIB_ID (and its associated title), only the lowest MFHD_ID is preserved. The join with the LINE_ITEM_COPY_STATUS MFHD_ID is done with an INNER JOIN, which means there must be a match or the record will be dropped. So, if the one MFHD that is preserved doesn't happen to be the MFHD that a line item is attached to, the entire record will be dropped. The other min() function is on the Title itself and makes no sense: get the first title in alphabetical order for a given BIB_ID, but there will only ever be one, since it's always the same BIB_TEXT record.

    Resolution:


    • Article last edited: 10/8/2013