Project

General

Profile

Production Ticket(ST) #11763

GOLDCREST - didn't reflect to datonory SA report

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

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
21/05/2024
Due date:
24/05/2024
% Done:

100%

Estimated time:
Spent time:
2.00 h
Job Remark:
Ticket Logged Date:
21/05/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
21/05/2024
SLA Delivery:
23/05/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
23/05/2024
Resolution:

1) Check the customer branch and area.
2) Found that the branch and area not match based on area master setup.
3) So, when filter by branch, the collection and invoice mentioned not showed.
4) This issue related to customer integration. Recently integration change the branch and area for customer.
5) Shanyou already fix the integration.

Root cause: Branch and area mismatch.

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

Hi pls check, didn't reflect to datonory SA report INWWX001257-240520
CCWWX001287-240520

c7cddc4c-0ce9-4681-ad8a-f9c9b39cd331.jpg (99.5 KB) c7cddc4c-0ce9-4681-ad8a-f9c9b39cd331.jpg Rashdan Hussin, 23/05/2024 10:05 AM

History

#1 Updated by Muhammad Arif 4 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Muhammad Arif 4 months ago

  • Assignee changed from Muhammad Arif to Rashdan Hussin

issue SA report:
1. branch tcw - should be under user tcw , but user WWX perform the txn, hence not match member id

next action:
- need to simulate if possible to user from different branch can help to perform the txn

#4 Updated by Rashdan Hussin 4 months ago

select * from mst_area where org_id = 'goldcrest' and branch_id = 'a263d06e9a504ebe9f52a430f298b1ad'
select * from mst_branch where branch_id = 'a263d06e9a504ebe9f52a430f298b1ad'

--302K/332
select * from customer where customer_id = 'A043F013D2D64780BDE9B9B0FFAA5D40'
select * from customer_at where customer_id = 'A043F013D2D64780BDE9B9B0FFAA5D40' order by at_date desc
select * from mst_customer_branch where customer_id = 'A043F013D2D64780BDE9B9B0FFAA5D40'
select * from mst_branch where branch_id = 'a263d06e9a504ebe9f52a430f298b1ad'
select * from mst_area where area_id = 'F8E61ABFB7D043C49E4FBEE127D54A34'

select * into DMS_Ecosystem_Backup_Table.dbo._customer_20240523
from DMS_EcoSystem.dbo.customer

--update customer set branch_id = 'a263d06e9a504ebe9f52a430f298b1ad', updated_by = 'Support', updated_date = getdate()
--where customer_id = 'A043F013D2D64780BDE9B9B0FFAA5D40'

select * into DMS_Ecosystem_Backup_Table.dbo._mst_customer_branch_20240523
from DMS_EcoSystem.dbo.mst_customer_branch

--update mst_customer_branch set branch_id = 'a263d06e9a504ebe9f52a430f298b1ad', updated_by = 'Support', updated_date = getdate()
--where customer_id = 'A043F013D2D64780BDE9B9B0FFAA5D40'

--305C/008 issue settle
select * from customer where customer_id = '1050F9CF7D51402C97201AA01CC33AF3'
select * from mst_customer_branch where customer_id = '1050F9CF7D51402C97201AA01CC33AF3'
select * from mst_branch where branch_id = '0a05ab339b0b402bb9912affe5772e41'
select * from mst_area where area_id = '17A545F15BD74219A6B531D012D030EC'
select * from customer_at where customer_id = '1050F9CF7D51402C97201AA01CC33AF3' order by at_date desc

select * from txn_invoice_history_header where invoice_no = 'INWWX001257-240520'

select * from txn_mobile_collection_header where col_no = 'CCWWX001287-240520'
select * from txn_mobile_collection_invoice where col_id = '8b9a540b-90ea-43e7-bc02-ff88f2bde88a'
select * from txn_invoice_history_header where invoice_id = '366A8CA77F984960B6F22F5181ECC1CC'

select * from member where member_cd = 'wwx'
select * from member_branch where member_id = 'dc954dfdc1db4e2aaf9d2759a1522725'
select * from mst_branch where branch_id = 'a263d06e9a504ebe9f52a430f298b1ad'

#5 Updated by Rashdan Hussin 4 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 90
  • Actual Initial Response set to 23/05/2024
  • Resolution updated (diff)

#6 Updated by Rashdan Hussin 4 months ago

  • Status changed from Pending Client Verification to Escalated to Level 3

Hi pls check, didn't reflect to datonory SA report INWWX001257-240520
CCWWX001287-240520
Hi pls check, Invoice and Collection didn't reflect to datanory SA report
INWWX001293-240522
CCWWX001319-240522
Hi pls check, Invoice and Collection didn't reflect to datanory SA report
INWWQ000701-240522
CCWWQ000730-240522

- All transaction mentioned above already reflect to SA report except CCWWX001287-240520.
- Pending shanyou to check the integration.

#7 Updated by Rashdan Hussin 4 months ago

  • Due date changed from 23/05/2024 to 24/05/2024
  • Status changed from Escalated to Level 3 to Pending Client Verification
  • Resolution updated (diff)

#8 Updated by Rashdan Hussin 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • % Done changed from 90 to 100

Also available in: Atom PDF