Load DWH full error: "ORA-01735: invalid ALTER TABLE option"

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse (DWH) full is failing with error: ORA-01735: invalid ALTER TABLE option
Full error below:
ClarityDB - isOracle? - An error occurred executing this job entry : 
Couldn't execute SQL: BEGIN
  FOR I IN (SELECT TABLE_NAME, CONSTRAINT_NAME 
 FROM USER_CONSTRAINTS
 WHERE  CONSTRAINT_TYPE = 'P' 
    AND    STATUS = 'DISABLED')
 LOOP
 EXECUTE IMMEDIATE 'ALTER TABLE ' ||I.TABLE_NAME|| ' ENABLE CONSTRAINT ' ||I.CONSTRAINT_NAME || ' EXCEPTIONS INTO DWH_FK_PK_EXCEPTIONS';
  END LOOP I; 
END;

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 7

Environment

Release : All

Resolution

Rebuild the DWH. See steps at When to rebuild the Data Warehouse (DWH) database