DWH Incremental Job is failing while population DWH_LKP_OBS_UNIT table.
V_SQL_TEXT := 'MERGE INTO DWH_LKP_OBS_UNIT TGT USING ......
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_LKP_OBS_UNIT). SQLERRM : ORA-01407: cannot update ("PPM_DWH"."DWH_LKP_OBS_UNIT"."OBS_UNIT") to NULL
ORA-06512: at line 24
Release : 15.5.1
Component : CA PPM APPLICATION
This is caused by a OBS UNIT having a null name. Find out the issue causing OBS Unit by running the below query on PPM schema.
select * from DWH_LKP_OBS_UNIT_V where OBS_UNIT is null.
After identifying the problematic OBS Unit, login to the application and modify it's name.