APP-SQLAP-10380: You can not select this payment document because it is in use by another payment batch

This issue is related to the data fixed I mean some of transaction are pending..

What I do is that
I took the backup using the below query

create table ap_inv_selection_criteria_all_backup
as select *
from ap_inv_selection_criteria_all
where checkrun_name = '&batch_name'
and status != 'CANCELED'
And Status != 'CONFIRMED'
and status != 'QUICKCHECK';

it will create the table and copy  all the payment batch which has a pending transactions
Now  check the status of the batch and update the status using below Update statement
and pass the below 3 Parameters from ap_inv_selection_criteria_all_backup table


update ap_inv_selection_criteria_all
set status = 'QUICKCHECK'
where checkrun_name ='&batch_name'
And Bank_Account_Name ='&bank_account_name'
and currency_code ='&currency_code';