Barclays-Claims Manager-Payment error investigation

Scenario:

1. the payment is still not processed
2. duplicate payment
3. Anything related to payment, once the payment is initiated trhough, Claims → payment + settlement → Pay Items button click

Refer for more details 5 MSGS Flow

Technical info: 

1. On payment initiation, 
   1. Claim will get closed, with a audit trail as below
      
   2. A entry will be added in Payadv table, with MRT_KEY format "PL"+Date as YYYYMMDD + ":" + "Time" +":" +"username"
   3. 1 + n entries will be added in Journal table
2. On Payment Approval
   1. PayAdv record's Maker Checker status  column will get Approved status, and there will be values for Verified, Authorized columns ( can be verified using query 3.a.)
   2. With Maker/Checker status = "APPROVED" , MSGS service will start initiating the Payment process, which include payment message creation, updating BRIDGE Tables, Reading and updating ACK etc( can be verified using query 3.a.)
   3. Write payment message to CM_MQMSGS_OUT_BRIDGE with CMOB_STATUS = NOT. ( can be verified using query 3.c.)
      1. Barclays system will read it from there. On reading a payment records, their system will update CMOB_STATUS = PRO
   4. Read ACK added by Barclays system, from CM_MQMSGS_IN_BRIDGE with CMOB_STATUS = NOT. Once read by CM, CM will update CMOB_STATUS = PRO ( can be verified using query 3.e.)
   5. The ACK information on payment will be updated on the payadv table  ( can be verified using query 3.a.)
   6. Send the settlement message, ie write settlement message to CM_SETTLEMENT_DETAIL_BRIDGE & CM_SETTLEMENT_SUMMARY_BRIDGE tables. Barclays system read it from there. 
3. Below are the relevant queries
   1. SELECT * FROM MRT_BCCLAIMSJOURNAL WHERE MRTTIMESTAMP IN ('20210924:04355503:svcMSGS');  –  payment advise MRT KEY, with PL removed from it. This key is found in Claim's Audit Trail. Check the above screenshot.
   2. SELECT * FROM MRT_BCCLAIMSPAYADV WHERE MRT_KEY IN ('PL20210924:04355503:svcMSGS');
   3. SELECT * from CM_MQMSGS_OUT_BRIDGE where CMOB_DATA like '%2021092404355503%'
   4. SELECT MRT_KEY,MRT_CLOSEDATE,MRT_CLOSED,MRTID,MRTASCLMFLAGS,MRTCLMFLAGS,MRTNUMSETTS,MRT_FLAGS,MRTLASTSETTDATE,MRTMSF_P_STATUS,MRT_NARRATIVE,MRTMSF_P_NARRATIVE,MRT_CLOSEDFLD, MRTAMOUNT,MRTALREADYPAID,MRTALREADYPAIDTBU,MRTPAIDBY,MRTSETTBY,MRTVALUEDATE,MRTUNIQUEREF,MRT_IMPORTDATE,MRT_LASTUPDATE FROM MRT_BCCLAIMS WHERE MRT_KEY IN (SELECT MRTCMJREF FROM MRT_BCCLAIMSJOURNAL  HERE MRTTIMESTAMP IN ('20210924:04355503:svcMSGS'));
   5. select * from cm_mqmsgs_in_bridge where CMIB_DATA like '%2021092404355503%'
4. For duplicate payment, 
   1. Query 3 b will have multiple results. 
   2. In such scenarios,
      1. take the claims' audit trail. If the settlement cash of 2nd payment is 0, then there is no issue
      2. In query results of 3 b.', check ACK column. In query 3.c check the CMOB_STATUS column. If it is NOT, then barclays have not yet read the payment.