Production Ticket(ST) #11766: DAILYFRESH - Van Goods Request Approval for SRB07 whose should be approve? - Datanory - DAILYFRESH - Redmine

Production Ticket(ST) #11766

DAILYFRESH - Van Goods Request Approval for SRB07 whose should be approve?

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:

29/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:

29/05/2024

Esclation Time:

Issue Reoccurance#:

Actual Initial Response:

21/05/2024

Resolution:

1) Check the approval flow.
2) Check the user branch.
3) Check the van request approval history.
4) Escalate to level 3. https://app.clickup.com/t/86epd425n

Root cause: There are two approval flow for this user.

Requester ExpectedDeliveryDate:

Delay Justification:

Priority Seq:

Effort (Hour):

External Ticket #:

None

Description

Hi Technical Team. For Van Goods Request Approval for SRB07 whose should be approve? SRB01 right? But this 2 days, the approval need SRB01 & SHA02. Why Ya?? Please assist urgently.

History

#1 Updated by Rashdan Hussin 4 months ago

Status changed from Assigned To to Support In Progress

Based on checking, SRB07 was assigned to two branches, SRB and SHA. And there is approver for both branches.
VanGoodsRequestApproval_SRB: SRB01
VanGoodsRequestApproval_SHA: SHA02

#2 Updated by Rashdan Hussin 4 months ago

select * from approval_flow where org_id = 'A000003' and activity = 'Van Goods Request'
select * from approval_flow_approver where org_id = 'A000003'
select * from approval_flow_branch where org_id = 'A000003'

select * from mst_branch where org_id = 'A000003'
select * from member where member_cd = 'SRB07'
select * from member_branch where org_id = 'A000003' and member_id = 'C86F03A8-9D9B-4772-B5AB-A63EABB25C03'

select * from txn_mobile_van_goods_request_header where salesman_id = 'C86F03A8-9D9B-4772-B5AB-A63EABB25C03' order by updated_date desc
select * from txn_van_goods_request_approval_history where van_goods_request_id = '139fb6c7-a38d-45de-99a0-f5613384003f'

select * from txn_van_goods_request_approval_history where approval_mode is null