The incremental DWH load job is failing with the following error in the DWH log:
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_FIN_PLAN_PERIOD_FACTS. SQLERRM : ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INTERNAL_MD. SQLERRM : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at "PPM_DWH.DWH_FIN_PLAN_PER_FACTS_LOAD", line 141
This is a known defect (DE41718) which is resolved in 15.4.1 and above. As a workaround, the FULL Load Data Warehouse job can be run, which will temporarily resolve the issue for some time, however the issue may return.