Production Ticket(ST) #11880
SNEKKU - this collection will cancel in mysoft ya, due to cheque got issue, please assist
1) Patch the collection data in all related table.
2) Done patch but the approval history could not display in the portal.
3) Escalate to level 3. https://app.clickup.com/t/86epg15dr
Root cause: Front end issue.
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Assigned To to Support In Progress
select * from txn_collection_approval_history where collection_id= '06e63163-950e-4115-bd0b-e4cfc9d5d182'
select * from txn_mobile_collection_header where col_no= 'CCMC000010-240521'--06e63163-950e-4115-bd0b-e4cfc9d5d182
select * from txn_mobile_collection_detail where col_id= '06e63163-950e-4115-bd0b-e4cfc9d5d182'
select * from txn_mobile_collection_invoice where col_id= '06e63163-950e-4115-bd0b-e4cfc9d5d182'
select * from txn_invoice_history_header where invoice_id = 'D6C20BC1F03240639A3B4F02FBB0979A'
select * from txn_invoice_history_header where invoice_id = '874499C02F8045D0880854F0528AD99E'
select * from txn_invoice_history_header where invoice_id = 'EEF032991DEE41CDA5E67A62D08904D9'
---- Update txn_collection_approval_history table
--UPDATE txn_collection_approval_history SET status = 'cancelled', updated_by = 'Support', updated_date = GETDATE WHERE collection_id = '06e63163-950e-4115-bd0b-e4cfc9d5d182';
---- Update txn_mobile_collection_header table
--UPDATE txn_mobile_collection_header SET status = 'cancelled', updated_by = 'Support' WHERE col_id = '06e63163-950e-4115-bd0b-e4cfc9d5d182';
---- Update txn_mobile_collection_detail table
--UPDATE txn_mobile_collection_detail SET status = 'cancelled', updated_by = 'Support', updated_date = GETDATE WHERE col_id = '06e63163-950e-4115-bd0b-e4cfc9d5d182';
---- Update txn_mobile_collection_detail table
--update txn_invoice_history_header set invoice_status='cancelled' ,invoice_balance='9859.50', updated_by='',updated_date=GETDATE where invoice_id = 'D6C20BC1F03240639A3B4F02FBB0979A'
--update txn_invoice_history_header set invoice_status='cancelled' ,invoice_balance='5054.80', updated_by='',updated_date=GETDATE where invoice_id = '874499C02F8045D0880854F0528AD99E'
--update txn_invoice_history_header set invoice_status='cancelled' ,invoice_balance='4653.60', updated_by='',updated_date=GETDATE where invoice_id = 'EEF032991DEE41CDA5E67A62D08904D9'
--Done Backup
--Back up
select * into DMS_Ecosystem_Backup_Table.dbo._txn_collection_approval_history_30052024
from DMS_EcoSystem.dbo.txn_collection_approval_history
select * into DMS_Ecosystem_Backup_Table.dbo.txn_invoice_history_header_30052024
from DMS_EcoSystem.dbo.txn_invoice_history_header
#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#3 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
https://app.clickup.com/t/86epg15dr
As the patching already done but the approval history could not display in the portal Already escalated to technical team to further checking to find the root cause
#4 Updated by Rashdan Hussin 4 months ago
- Subject changed from Snekku-hi @Azhar13 this collection will cancel in mysoft ya, due to cheque got issue, please assist, thanks to SNEKKU - this collection will cancel in mysoft ya, due to cheque got issue, please assist
- Status changed from Support In Progress to Escalated to Level 3
- % Done changed from 0 to 50
- Type set to Support Request
- Resolution updated (diff)
#6 Updated by Rashdan Hussin 4 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
#7 Updated by Rashdan Hussin 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 50 to 100
- Actual Initial Response set to 30/05/2024
Shuern:
@Arif Ibrahim This issue is caused by the patched status is in lower case 'cancelled' while the valid status should be 'Cancelled', data is patched on 7/6/2024 and will close this issue