Production Ticket(ST) #10874
Daily Fresh-Sel17 mobile , above transactions is not capture in the database.vwe had uploaded the database too for your checking. Kindly be reminded , any update version need to be informed in the main communication channel. I just had a surprise we nee
Job Remark:
Ticket Logged Date:
30/01/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
30/01/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
30/01/2024
Resolution:
Patching work has been done
Root Cause- Deadlock when user upload transaction
** Azhar: no user response as we asked to verify
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 8 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 8 months ago
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
--Check if sales order and invoice total amount tally
select * from (
select h.ord_hdr_id, h.order_no, ROUND/20 as so_amt, ROUND/20 as si_amt, h.org_id, h.status from txn_sales_order_header h
inner join txn_invoice_history_header ih on h.ord_hdr_id = ih.sales_order_id
where h.order_web_net_amount <> ih.currency_value and year(h.created_date) >= 2023 and month(h.created_date) >= 11
group by h.ord_hdr_id,h.order_no, h.org_id, h.order_web_net_amount, ih.currency_value,h.status
) x where x.so_amt <> x.si_amt
#3 Updated by Muhammed Azhar Mohamed Maideen 7 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 30/01/2024
- Resolution updated (diff)