Skip to main content
Kofax

MarkView Oracle Integration - Events Not Processing Due to ORA-20858: Error (-904) while querying unique record: ORA-00904: -CUSTOMERTRXID-: invalid identifier error

Summary

4184

Applies To

  • ERP System: Oracle
  • MarkView Version: MarkView 5.10

Behavior

  • The Process (SQL*Flow) Manager is unable to process events out of the SF_EVENT_ALERT table, so events start backing up. The Manager log file shows the following error:
    09/03/2007 04:08:44: Firing Rule Instance: 374
    09/03/2007 04:08:44: Encountered the following error while firing rule (rule instance id = 374):
    09/03/2007 04:08:44: ORA-01403: no data found
    ORA-20858: Error (-904) while querying unique record: ORA-00904: "CUSTOMERTRXID": invalid identifier

Known Causes

Resolution

  • Download the attached hotfix and apply it per the Patch Instructions.

Keywords: 20858, 904, 00904