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

    Bulk Arrival, v20, "General Invoice ABC/123 failed to be created"

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

    Description:
    I received the error “General Invoice Blackwell/2 failed to be created” for Bulk Arrival, with this scenario:

    1. Order Search tab / Bulk Arrival node
    2. Select an order (sublibrary ULINC has a few non-arrived “Sent” orders)
    3. Activate the “Arrive” button
    4. Select the “Create Invoice” option
    5. The “Arrival” record was successfully created, but the system alerted that: “General Invoice Blackwell/2 failed to be created”.

    The pc_server log showed this error:

    SERVICE : C0543
    MODULE : Acquisition Services
    DESCRIPTION: No Description Available
    ACTION : ARRIVE
    PROGRAM : pc_acq_c0543

    Oracle error: io_z77_write
    ORA-00001: unique constraint (USM50.Z77_ID) violated

    Resolution:
    Update the Util/G 2 Counter for last-invoice-no; create a unique new sequential numbering for the invoice.

    You may want to include a prefix, such as:

    Sequence Name Value Suppress Type Prefix
    -------------------- --------- -------- ---- --------------------
    last-invoice-no 2009 y S BULK


    • Article last edited: 10/8/2013