ORA-00904: "TEAM_DEF_KEY": invalid identifier on DWH job full load

Document ID : KB000125144
Last Modified Date : 23/01/2019
Show Technical Document Details
Question:
Upgraded PPM environment to 15.5.1.240 and faced the error ORA-00904: "TEAM_DEF_KEY": invalid identifier on DWH job full load.

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_RES_RESOURCE). SQLERRM : ORA-00904: "TEAM_DEF_KEY": invalid identifier
ORA-06512: at line 31

Please provide the resolution for the error.

 
Environment:
PPM 15.5.1
Answer:
 'TEAM_DEF_KEY' and 'IS_TEAM' columns on DWH_RES_RESOURCE table are used for New User interface(UI). 

Then check for 'Activate New User Experience' on New User Experience under Administration -> General Settings -> System Options and run the DWH job full load again.