This topic provides the systematic instructions if there are any workflow errors w.r.t. to Finance, Recon, and Instrument transactions.

1. Run the following query for the respective transaction workflows.
   1. Finance

      Query: select * from workflow where json_value(json_data, '$.workflowName') = 'FINANCE' and json_value(json_data, '$.input.transactionReferenceNo') = 'Finance Transaction Reference Number';

   2. Recon

      Query: select * from workflow where json_value(json_data, '$.workflowName') = 'MANUALRECON'and json_value(json_data, '$.input.reconTxnRefNo') = 'Recon Transaction Reference Number';

   3. Instrument

      Query: select * from workflow where json_value(json_data, '$.workflowName') = 'INSTRUMENT' and json_value(json_data, '$.input.invoiceNumber') = 'Invoice Number';

   The Workflow ID gets retrieved.
2. Use the Workflow ID and run the following query to check the status of the transaction in the task list.

   Query: select * from task where task_id in (select task_id from workflow_to_task where workflow_id = 'abbd7374-3404-4eaA-adda-2e870a48b247')

3. Review the tasks and take further action accordingly.