Job chains not visible in JOC Cockpit when used with an Oracle database. Missing Sequence REPORTING_IJC_ID_SEQ

Current Situation

• The Oracle create script inventory.sql creates a sequence with the wrong name REPORTING_II_IJC_SEQ
• This problem results in the JobScheduler Master main log stating an errror message such as:

  org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  

• This results in job chains not being processed, i.e. not being visible, by the inventory plugin. The JOC Cockpit therefore does not show any job chains from the inventory.

Desired Behavior

• The Oracle create script inventory.sql should creates a sequence with the name REPORTING_IJC_ID_SEQ
• All job chains are visible from the JOC Cockpit.

Workaround
Either

rename the already existing Sequence REPORTING_II_IJC_SEQ to REPORTING_IJC_ID_SEQ

or
create the sequence with the following DB Script:

DECLARE c number; BEGIN SELECT COUNT(*) INTO c FROM USER_SEQUENCES WHERE "SEQUENCE_NAME"='REPORTING_IJC_ID_SEQ'; IF c = 0 THEN EXECUTE IMMEDIATE '
CREATE SEQUENCE REPORTING_IJC_ID_SEQ
   INCREMENT BY 1 
   START WITH 1 
   MAXVALUE 999999999 
   MINVALUE 1 CYCLE
'; END IF; END;
/