F_JD21B4 which indicates ORA-00942 table or view not found

Problem Summary: F_JD21B4 which indicates ORA-00942 table or view not found

Description:

This is a screenshot of the error when we tried to initialize the replication set.

Along with the error from the log file

  2019-5-21T13:37:15+200: all-integ-edtrg: F_JD21B4: 
  DBMS error [Invalid object name 'hvr_stisall_edtrg'. Statement(s) could not be prepared]. 
  Last query select 
  HVR_CAP_LOC                        NOT NULL VARCHAR2(5)
  HVR_TX_SEQ                         RAW(24)
  HVR_TX_COUNTDOWN                   NOT NULL NUMBER
  INTEG_ROWS_DONE                    NOT NULL NUMBER
  INTEG_BLOCKED                      NOT NULL NUMBER
  INTEG_UNBLOCKED                    NOT NULL NUMBER
  HISTORY_SCAN_START_TSTAMP          NOT NULL NUMBER
  HISTORY_SCAN_START_ADDR            NOT NULL VARCHAR2(50)
  HISTORY_EMIT_SEQ                   NOT NULL VARCHAR2(24)

Answer:

Each transaction performed by an integrate job contains an update statement to an integrate state table (named hvr_stin* or hvr_stis*). This allows log-based capture jobs to recognize the session name defined by an integrate job, but this is ignored by trigger-based capture jobs.

HVR_STINPLTABLES_<ABCD> is a hvr technical table or as refer to a state table.

If this table was not found in the target, re-initializing for the integrate location for the channel with options “Scripts and Jobs” and “State Tables” selected. This will recreate it then it will resolve your issue.