am1

CLRT-80823 DE29608 - Linking a Process based on the Timesheet Object to Resource's Updated By / Approved By / Submitted By will not work as expected if the Resource ID does not match the User ID

Discussion created by am1 Champion on Apr 12, 2017
Latest reply on Apr 13, 2017 by Prashank Singh

I couldn't find anything posted about this problem, let us know if this was useful.

Linking a Process based on the Timesheet Object to Resource's Updated By / Approved By / Submitted By will not work as e… 

 

Summary

Linking a Process based on the Timesheet Object to Resource's Updated By / Approved By / Submitted By will not work as expected if the Resource ID does not match the User ID

 

Overview

When creating a process around the Timesheet object, there is the option to link to other objects using the following four fields:

 

  • Resource (based on the prresourceid column in prtimesheet table)
  • Approved By (based on the prapprovedby column in prtimesheet table)
  • Submitted By (based on the prsubmittedby column in prtimesheet table)
  • Updated By (based on the prmodbycolumn in prtimesheet table)

 

However, there is an error when the objects are linked.  The Resource link is fine, because the prresourceid column uses the srm_resources table id column.

However, the Approved By, Submitted By and Updated By links are incorrect, because the columns in prtimesheet use the user_id value for the user performing the action, but the link is still established on the srm_resources id column, instead of the correct user_id column.


Resolution:
CLRT-80823/DE29608. Fixed in 15.3.

Outcomes