Production Ticket(ST) #11956
GOLDCREST - collection 301U/012 didn't reflect to autocount
1) requested user to upload database
2) checked in the DB
Root cause- user enquiry and clarification
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#2 Updated by Rashdan Hussin 4 months ago
- Subject changed from Goldcrest- Hi, collection 301U/012 didn't reflect to autocount to GOLDCREST - collection 301U/012 didn't reflect to autocount
- Due date changed from 08/06/2024 to 11/06/2024
- Priority changed from P2 - High to P3 - Medium
- Type set to Support Request
- SLA Delivery set to 11/06/2024
#3 Updated by Rashdan Hussin 4 months ago
- Status changed from Assigned To to Support In Progress
select * from txn_mobile_collection_header where col_no = 'CCJNL001853-240606'
select * from txn_mobile_collection_invoice where col_id = 'e32baffc-a528-4bb6-8211-a5ec4c8787fd'
select * from txn_invoice_history_header where invoice_id = '5dbb5498-a605-4423-9d5b-029740b5ac11'
select * from txn_invoice_history_header where invoice_id = '1b167895-f220-4464-917d-84b6ddd86bee'
select * from customer where customer_id = '7A481C11FA284D86A4A29064EB48F8C1'
-sync date is null
-need to further check at autocount
#4 Updated by Rashdan Hussin 4 months ago
- Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen
#5 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Support In Progress to Pending Client Feedback
#6 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_header_13062024_
from DMS_EcoSystem.dbo.txn_mobile_collection_header
select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_invoice13062024_
from DMS_EcoSystem.dbo.txn_mobile_collection_invoice
update txn_mobile_collection_header set status = 'Cancelled', updated_by = 'Support', updated_date = getdate() where col_id='e32baffc-a528-4bb6-8211-a5ec4c8787fd'
update txn_mobile_collection_invoice set status = 'Cancelled', updated_by = 'Support', updated_date = getdate() where col_id='e32baffc-a528-4bb6-8211-a5ec4c8787fd'
#7 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Pending Client Feedback to Pending Client Verification
- Resolution updated (diff)
#8 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Actual Initial Response set to 13/06/2024