Receive below error for Full and incremental Load Data Warehouse job.
ERROR: ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_LOOKUP_LOAD DWH_LKP_CSK_RPT_ENTITY_F_00. ON CONFLICT DO UPDATE command cannot affect row a second time
Where: PL/pgSQL function inline_code_block line 21 at RAISE
This is an Out of the Box lookup
Some out of the box lookups are not meant to be included in the data warehouse.
This lookup was used in an attribute in the Investment object.
Release : 15.9
Component : CA PPM SAAS APPLICATION
Unchecked 'Include in Data Warehouse' in the attribute and re-ran the Full Load Data Warehouse job