Production Ticket(ST) #11916
Snekku- Hi @Azhar13 why collection number CCMS0... 7 less 1 zero?
There is no resolution as we check this user do onbehalf transaction
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
SELECT * FROM txn_mobile_collection_header where col_no like '%CCMS000007-240604%'
SELECT * FROM txn_mobile_collection_header_at where col_no like '%CCMS000007-240604%' order by at_date desc
exec sp_executesql N'SELECT * FROM txn_collection_approval_history WHERE collection_id= @collection_id_23975ba11cce4fa6ba6f7d787d7a9fe3 AND org_id= @org_id_23975ba11cce4fa6ba6f7d787d7a9fe3 ',N'@collection_id_23975ba11cce4fa6ba6f7d787d7a9fe3 nvarchar(36),@org_id_23975ba11cce4fa6ba6f7d787d7a9fe3 nvarchar(6)',@collection_id_23975ba11cce4fa6ba6f7d787d7a9fe3=N'f8b9e158-438d-4625-a754-d7c85bb6d0f4',@org_id_23975ba11cce4fa6ba6f7d787d7a9fe3=N'SNEKKU'desc
Already requested user to upload database
#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- File Collection_2.png Collection_2.png added
I f found that we this particular collection is not found in the mobile database.
in the at table also there was no delete action has been made.
Root cause- user enquiry and clarification
#3 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Assigned To to Support In Progress
#4 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Support In Progress to Ticket Resolved
- Type set to User Enquiry & Clarification
- Actual Initial Response set to 05/06/2024
- Resolution updated (diff)