Clarity Service Management

Expand all | Collapse all

service catalog usm_request_pending_action table query

  • 1.  service catalog usm_request_pending_action table query

    Posted 03-14-2017 08:47 AM

    In usm_request_pending_action table we have process_instance_id ,want to know what value will get stored in it. In our test environment this table is filled with subscription detail id but in production its null(no value). Object type is 1,so want to know what is this process instance id and what value it should store



  • 2.  Re: service catalog usm_request_pending_action table query

    Posted 03-14-2017 11:13 AM

    Good Afternoon Shubha.
     
    The following information is related to your current question.
     
    Status:
    0 - deleted
    1 - active
    2 - completed by assigned user
    3 - completed by another user
    4 - delegated
    5 - transferred
    6 - terminated.
     
    ObjectId:
    The value is either subscription detail id or offering id
     
    Objecttype:
    0 - means object id is subscription detail id and
    1 - means offering id
     
    Thanks and kind regards, Louis van Amelsfort.



  • 3.  Re: service catalog usm_request_pending_action table query

    Posted 03-15-2017 02:53 AM

    Thanks for the reply Louis. But I was asking about "process_instance_id" column. What values should get stored in this column



  • 4.  Re: service catalog usm_request_pending_action table query

    Posted 03-15-2017 05:12 AM

    Good Morning Shubha.

     

    The info I provided was what I could discover for this table.

    Perhaps other people in the community can assist in finding the description about the "process_instance_id" column.

     

    Thanks and kind regards, Louis.