AnsweredAssumed Answered

Is there any table to capture the Activity form given comments at approval Phase/ Fulfillment Phase?

Question asked by Viswanath Reddy on May 14, 2018
Latest reply on May 15, 2018 by Viswanath Reddy

Is there any table to capture the Activity form given comments at approval Phase/ Fulfillment Phase?

 

Given comment is captured in run time data

 

Tried to fetch the comments using below query but no success

select OPTIONAL_COMMENTS from (SELECT OPTIONAL_COMMENTS FROM V_AV_WFWORKITEM_HISTORY

            WHERE ACTI_ID=(select acti_id from wp_proci_node where proci_id || ':' || proci_db = '316707:WPDS'

            and NAME = 'New Asset classification approval')

            AND OPTIONAL_COMMENTS IS NOT NULL

            ORDER BY LU_DATE DESC) WHERE ROWNUM = 1;

Actions taken:

  1. Observed, comments are capturing only if we give the comments at item level and in the history subtab and also reassigning comments if any escalation trigger.
  2. Used {OptionalComments} or {AllOptionalComments} and same result. Not capturing approval activity comments, it is capturing reassigned details from approval phase and fulfillment activity comments (it should display only approval activity comments and fulfilment activity comments not reassigned comments)

Please suggest is there any other approach or method to fetch activity form comments?

Also, is there any place to see the captured comments given in Activity forms (Perform button) in UI?

Outcomes