Depreciation Reporting Table PS_DEPR_RPT is out of synch. Need help to rebuild.

DEPR_RPT is out of synch (includes only partial data). We have truncated the DEPR_RPT table and all related temporary tables in a non-prod environment and tried to run AMDPREPT.

Initially I tried to run AMDPREPT for 2017 to 2018 for all business units with only Process Current Activity checked. It abended with ORA-08006 error.

Next I ran AMDPREPT for 2016 only for all business units with Process Current Activity checked. It abended with the following error: File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1708 Error Position: 28 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_DEPR_RP4_TMP4"."TRANS_CODE") to NULL Failed SQL stmt: UPDATE PS_DEPR_RP4_TMP4 SET TRANS_CODE = ( SELECT MIN(A.TRANS_CODE) FROM PS_DEPR_RP6_TAO4 A WHERE A.PROCESS_INSTANCE = PS_DEPR_RP4_TMP4.PROCESS_INSTANCE AND A.ASSET_ID = PS_DEPR_RP4_TMP4.ASSET_ID AND A.DTTM_STAMP = ( SELECT MIN(B.DTTM_STAMP) FROM PS_DEPR_RP6_TAO4 B WHERE B.PROCESS_INSTANCE = A.PROCESS_INSTANCE AND B.ASSET_ID = A.ASSET_ID AND B.DTTM_STAMP <= A.DTTM_STAMP)) WHERE PROCESS_INSTANCE = 2812243