Hi @Shuchi_Gupta, I hope you are doing well.
The answer will be First option.
*Successful/Failed----done by workflow set transaction status activity as you said i.e. by the workflow.
*Abandoned status is done automatically by UIPath orchestrator because of below mentioned reason. Abandoned - the item remained in the In Progress status for a long period of time (approx.24 hours) without being processed;
Thanks & Regards,
Shubham Dutta