Production Ticket(ST) #12051
Goldcrest- Morning, why user JNL yesterday ady key in the collection but the unpaid columm still showing outstanding? this collection didn't reflect to salesman activity report and autocount
1) checked user database
2) checked in the DMS database
3) checked SP
4) escalate to 2nd level support
Root cause- the data was in the di_table
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Assigned To to Support In Progress
- Priority changed from P3 - Medium to P2 - High
select * from txn_invoice_history_header where invoice_no= 'INJNL002193-240619'
select * from txn_mobile_collection_invoice where inv_id= '0984597d-27db-4f61-b396-dfed046c66ee' -- collection in actual table
select * from di_mobile_txn_collection_invoices where invoice_id= '0984597d-27db-4f61-b396-dfed046c66ee' -- there is collection_ invoice in di_table
select * from txn_mobile_collection_invoice where inv_id= '0984597d-27db-4f61-b396-dfed046c66ee'-- not in the actual table
select * from txn_mobile_collection_invoice where inv_id= '0984597d-27db-4f61-b396-dfed046c66ee' -- not in the actual table
select * from di_mobile_txn_collection_header where collection_id= '8ae00b72-1ea4-4849-8fa8-baf4c46c51c0'--has in the di_table
select * from txn_mobile_collection_header where col_id= '8ae00b72-1ea4-4849-8fa8-baf4c46c51c0'-- Not in actual table
HAve to run SP on this
#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- File Goldcrest_Sp.txt Goldcrest_Sp.txt added
#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Muhammad Arif
HI arif I have been attached the SP script to further check
As I mentioned the collection has been stucked in the di_table and has not flow to the actual table
Please assist on this ticket.
#4 Updated by Muhammad Arif 3 months ago
- Status changed from Support In Progress to Pending Client Verification
- Assignee changed from Muhammad Arif to Muhammed Azhar Mohamed Maideen
Hi Azhar, please verify with customer. the collection already reflected into Datanory.
The root cause is one of the inv (in same collection) is cancelled.
#5 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 26/06/2024
- Resolution updated (diff)