When reviewing the job has completed, there is an example error that
Total investments processed: 1
Investments deleted : 0
Investments with errors : 1
Job Completed 11/4/21 6:47 PM
Message 11/4/21 6:47 PM
PRJXXX(5xxxxx) cannot be deleted because it has associated Time Entries.
Release : All
Timesheets need to be in the 'Open' or 'Returned' status in order for investments to be deleted.
Use one of the following methods:
Method 1: Use Query to check time entries are associated with the investment being deleted with the following query:
--(Oracle)
select TP.PRSTART, TP.PRFINISH-1,TP.PURGE_FLAG TP_PURGE,
TP.PRISOPEN TPOPEN_OR_CLOSED, TP.PRID TPID, TS.PRID current_tsid, TS.PRADJUSTEDID prior_id,
TS.PRSTATUS TS_STATUS, TS.PRISADJUSTMENT, TE.USER_LOV1,
TO_CHAR(TS.POSTED_TIME, 'mm-dd-yyyy hh:mi:ss AM') POSTED_TIME,
TO_CHAR(TS.PRMODTIME, 'mm-dd-yyyy hh:mi:ss AM') PRMODTIME,
srmr.id RES_ID, srmr.UNIQUE_NAME RES, srmr.FIRST_NAME, srmr.LAST_NAME,
srmr.EMAIL, srmr.DATE_OF_HIRE, srmr.DATE_OF_TERMINATION, srmr.MANAGER_ID,
srmr.IS_ACTIVE RES_ACTIVE, R2.PRISOPEN RES_OFTE, srmr.is_external,
R2.PRTRACKMODE RES_TRACKMODE, srmr.ENTITY_CODE RES_ENTITY_CODE,
srmr.LAST_UPDATED_DATE RES_LAST_UPDATED_DATE,
srmr.LAST_UPDATED_BY RES_LAST_UPDATED_BY, TE.PRID TE, TE.PRTYPECODEID TE_ITC,
TE.PRCHARGECODEID TE_CC, TE.PRACTSUM/3600 TE_HOURS, PA.PRESTSUM/3600 ETC,
pa.PRPENDESTSUM/3600 PENDING_ETC, TE.PRRMEXPORTED, P3.ODF_OBJECT_CODE,
P3.name INV_NAME, p3.code, P3.IS_ACTIVE INV_ACTIVE, P2.STATUS INV_FIN_STATUS,
p2.last_updated_date inv_lud, p2.last_updated_by inv_lub,
P3.TRACK_MODE INV_TRACK_MODE, P2.APPROVED INV_APPROVED, P2.TYPE_,
P3.CHARGECODEID INV_CC, P3.IS_OPEN_FOR_TE INV_OFTE, TSK.PRNAME TASK_NAME,
TSK.IS_OPEN_TE TSK_OFTE, PA.PRSTATUS NOTSTARTEDCOMPLETE, PA.PRACTTHRU,
PA.PRPENDESTSUM PENDETC
FROM
PRTASK TSK, INV_INVESTMENTS P3, PRASSIGNMENT PA, PRTIMEENTRY TE,
PRTIMESHEET TS, SRM_RESOURCES srmr, PRTIMEPERIOD TP, PAC_MNT_PROJECTS P2,
PRJ_RESOURCES R2, PAC_MNT_RESOURCES R3
WHERE TP.PRID = TS.PRTIMEPERIODID
AND TS.PRID = TE.PRTIMESHEETID AND TE.PRASSIGNMENTID = PA.PRID
AND PA.PRTASKID = TSK.PRID AND srmr.ID = PA.PRRESOURCEID AND TSK.PRPROJECTID = P3.ID
and P2.id = P3.id and R2.PRID = SRMR.id and R3.id = SRMR.id
and p3.code = 'YOUR_INV_CODE'
order by TS.PRID, TS.PRADJUSTEDID desc
Method 2: Use the Timesheets Grid Page