CA Identity governance result.cancel flag in Submitted Result.

[Vignesh Natarajan]

Hi Team,

When we execute sql query to fetch the details for the things certified , we could see values of the selected result coloumn and submitted coloumn result.

here selected result column is "result.certification.approve" and the submitted result coloumn is "result.cancel" we want to understand why are them are different.

What is the meaning of result.cancel.

Regards,
Vignesh N

[Yuan Heng Lin]

Here are the scenario that I can think of which will cause the cancel stat

1. When there are multiple approvers and one person's approval is enough, the other tasks are marked cancelled. This is when workflows are customized or weighing method is used for approval.
2. When tasked get expired after the overdue expiry date is reached.
3. When tasks are delegated and the delegate has cancelled the share my work.

------------------------------
------------------------------
And, as always Perhaps there are others in the communities who have experience in doing this and we invite them to comment here also.
Another option may be to reach out to our partner HCL Technologies to see in what way they can assist further. The Enterprise Studio team of HCL can be reached at [e-mail]. https://www.hcltech.com/enterprise-studio
------------------------------

[Vignesh Natarajan]

Hi Yuan,

Thank you very much for the quick response.

Could you please let us know how can make this records as similar as submitted results of the reviewer. Because this has created some confusion during the auditing.

[Yuan Heng Lin]

Where did you retrieve result column and submitted result columns?  In general, for data integration, we don't recommend to alter the result as this is by designed to show the action that has been taken. 

------------------------------
------------------------------
And, as always Perhaps there are others in the communities who have experience in doing this and we invite them to comment here also.
Another option may be to reach out to our partner HCL Technologies to see in what way they can assist further. The Enterprise Studio team of HCL can be reached at [e-mail]. https://www.hcltech.com/enterprise-studio
------------------------------

[Vignesh Natarajan]

hi Yuan,

We are getting the above data by executing a sql query with the oracle database.

on BusinessFlowTasks and BusinessFlowEntity Tables.