Hi Nika
Thank you so much for your reply. Your response really helped!
Yes, it was having weird constraint names and I removed them with the help of our DBA.
Then I tried running a full load; it did not fail with the same error but with a different error now.
ERROR 2017-06-29 07:17:29,603 [dwh_etl_interface_dim - User Defined Java Class] dwh.event User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_STATUS_REPORT
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "SR_COST_EFFORT_STATUS_KEY": invalid identifier
I think this is somethinng related to a system field - Cost and Effort Status in the system sub object - Status Report but I could not further analyse or able to fix this issue.
Can you please advise?