Problem Summary: F_JD21B4 which indicates ORA-00942 table or view not found
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_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)
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.