Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

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

  • 1.  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

    Posted Apr 12, 2017 12:04 PM

    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.



  • 2.  Re: 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

     


  • 3.  Re: 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

    Broadcom Employee
    Posted Apr 13, 2017 05:56 AM

    Thanks Andrew for sharing this.

    Related KB Article (TEC1693514): Linking a Process based on the Timesheet Object to Resource's Updated By / Approved By / Submitted By will not work as e… 



  • 4.  Re: 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

    Posted Apr 13, 2017 06:06 AM

    Thanks for sharing:)