Production Ticket(ST) #11548: GOLDCREST - different customers have the same collection number - Datanory - GOLDCREST - Redmine

Production Ticket(ST) #11548

GOLDCREST - different customers have the same collection number

Added by Rashdan Hussin 5 months ago. Updated 5 months ago.

Status:

Ticket Resolved

Priority:

P2 - High

Assignee:

Muhammad Arif

Start date:

24/04/2024

Due date:

29/04/2024

% Done:

100%

Estimated time:

Job Remark:

Ticket Logged Date:

24/04/2024

Ticket No.:

Related Ticket ID:

Type:

Support Request

SLA Initial Response:

24/04/2024

SLA Delivery:

26/04/2024

Esclation Time:

Issue Reoccurance#:

Actual Initial Response:

Resolution:

solution: patch the collection number and then re-integrate the collection.

Root cause: technical team wrongly patch the collection number

Requester ExpectedDeliveryDate:

Delay Justification:

Priority Seq:

Effort (Hour):

External Ticket #:

None

Description

can help to check why different customers have the same collection number?

a41ec6f7-8143-4133-be05-a5fd70a0e631.jpg (184 KB) a41ec6f7-8143-4133-be05-a5fd70a0e631.jpg

Rashdan Hussin, 24/04/2024 11:13 AM

History

#1 Updated by Rashdan Hussin 5 months ago

Status changed from Assigned To to Support In Progress
Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen

select * from member where member_cd = 'mcj'
select * from customer where customer_code = '302p/247'
select * from customer where customer_code = '302k/214'

select * from txn_mobile_collection_header where col_no = 'ccmcj000102-240420'
select * from txn_mobile_collection_invoice where col_id = 'e87e9bb8-11ca-40dc-b52a-9a8fa9cbc128'
select * from txn_invoice_history_header where invoice_id = 'd3519525-6c97-433c-966b-c097fa3101bc'

select * from txn_invoice_history_header where invoice_no = 'INMCJ000116-240420'
select * from txn_mobile_collection_invoice where inv_id = '364527b7-6cb7-4f64-acdf-248461d2b49e'
select * from txn_mobile_collection_header where col_id = '4afe9c32-5ca1-4490-b402-cfa943ec750c'

select at_type, * from txn_mobile_collection_header_at where col_id = '4afe9c32-5ca1-4490-b402-cfa943ec750c' order by at_date

escalate to azhar
end shift

#2 Updated by Muhammed Azhar Mohamed Maideen 5 months ago

select at_type, * from txn_mobile_collection_header_at where col_id = '4afe9c32-5ca1-4490-b402-cfa943ec750c' order by at_date

select * from txn_invoice_history_header_at where invoice_no = 'INMCJ000115-240420' order by at_date desc

select * from txn_invoice_history_header_at where invoice_no = 'INMCJ000116-240420' order by at_date desc

select * from customer_at where customer_code= '302p/247' order by at_date desc
select * from customer_at where customer_code= '302k/214'order by at_date desc

My finding based on the simulation
Customerat table did not change ay thing yet

Need to dice in further more