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

    ue_08: ORA-00904: "Z01_CATEGORY": invalid identifier -- for USM01

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

    Description:
    We have the problem described in KB 8192-938, but in the usm01/usm10 libraries:

    ue_08: ORA-00904: "Z01_CATEGORY": invalid identifier -- for USM01

    The Z01_CATEGORY was created fine in the production instances.

    Resolution:
    I find that, despite your having run p_manage_01 for usm10, the usm10 z01 is still incorrect: when I do util f/4 for the z01, I get:

    Oracle error: fetch z01
    ORA-01007: variable not in select list

    Same for the usm01 z01.

    But after doing util a/17/1 for the usm10 z01 and usm01 z01, and sending a record to the server (with util f/1/13) to populate the z01. Both of these z01's now display in util f/4 without error.

    Now, p_manage_01 and p_manage_17 need to be run for usm10. And then p_manage_102, _02, _17, _32, and _35 need to be run for usm01.


    [Jerry Specht]
    [11/26/2006 4:53:22 AM Jerry Specht]

    Additional Information

    usm01, usm10, z01-category


    • Article last edited: 10/8/2013