Support #8815
SCP ID :##4747##] : bulk status not update
| Status: | Work Completed-End life cycle | Start date: | October 12, 2018 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | BIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
Bulk payment status not updated. Please check
History
#1
Updated by Stephanie Sufrapto almost 6 years ago
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
- Assignee changed from Stephanie Sufrapto to Zahir Abd Latif
- % Done changed from 0 to 100
Provide query :
select
select * from BIB_BULK_PAYMENT_HISTORY where BATCH_ID in (
'11828301147',
'11828301146',
'11828301143',
'11828301142',
'11828301141',
'11828301135');
update
update BIB_BULK_PAYMENT_HISTORY set ACTION_STATUS = '3' where BATCH_ID = '11828101135'
or BATCH_ID = '11828301143';
update BIB_BULK_PAYMENT_HISTORY set ACTION_STATUS = '6' where BATCH_ID = '11828301141'
or BATCH_ID = '11828301142'
or BATCH_ID = '11828301146'
or BATCH_ID = '11828301147';