Production Ticket(ST) #11666
OROMEO - Update Chain Code For KK Supermart
Job Remark:
Ticket Logged Date:
09/05/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
09/05/2024
SLA Delivery:
13/05/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
09/05/2024
Resolution:
1) Patch the chain_id for all KK Supermart
Root cause: Update the KK Supermart chain.
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
Ada 2 KK Supermarket, KK Supermarket total outlet 760. Assign all to KK Mart Chain
History
#1 Updated by Rashdan Hussin 5 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 5 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 09/05/2024
- Resolution updated (diff)
select * from customer where org_id = 'oromeo' and customer_name like '%KK SUPERMART%'
select * from chain where org_id = 'oromeo' --KK Mart 1f3bcb5a2081404ca30c07e78a6ab026
--select * into DMS_Ecosystem_Backup_Table.dbo._customer_20240509
--from DMS_EcoSystem.dbo.customer
--update customer set chain_id = '1f3bcb5a2081404ca30c07e78a6ab026', updated_date = GETDATE, updated_by = 'Support'
--where org_id = 'oromeo' and customer_name like '%KK SUPERMART%'
#3 Updated by Rashdan Hussin 5 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100