The Load Data Warehouse (DWH) Job fails. The error log shows the following: ORA-04020: deadlock detected while trying to lock object XXXXXX.
Example:
CA Clarity][Oracle JDBC Driver][Oracle]ORA-04020: deadlock detected while trying to lock object PPM_DWH.DWH_INV_INVESTMENT
Typically when the deadlock error occurs it is because two different database sessions each attempt to update rows in the same table.
Rerun the Load DWH job. Usually, the job will not fail again.
There is a defect DE50236 that can cause this which is fixed in 15.9
The following scenarios are potential reasons for deadlock issues:
See also: Load DWH job frequently reported issues