Production Ticket(ST) #12125
DailyFresh- The above are the 4 invoices for 28/6
Job Remark:
Ticket Logged Date:
01/07/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
01/07/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
01/07/2024
Resolution:
1) checked DMS database
2) checked mobile database
3) Root cause--> user operational
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
Pls advise on how to capture these in system
History
#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
select * from txn_invoice_history_header where invoice_no= 'INPNG07000327-240628'
select * from txn_invoice_history_header_at where invoice_no= 'INPNG07000327-240628'
select * from sync_mobile_token where login_id= 'png07' order by created_date desc
select * from sync_mobile_activity_log where token_id= 'E259BECF-2815-444D-A587-B36F793445C5' order by created_date desc
select * from sync_mobile_activity_log where member_id= '4DBC3AB4-4BC5-4617-8570-F310206A4E5B'
and cast (created_date as date) ='2024-06-28' --and action_type ='upload'
order by created_date desc
#4 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 01/07/2024