FUJ00171918
FUJ00171918
Peak Incident Management System
Call Reference PC0275564 Call Logger _ Mail Manager_ -- EDSC
Release Reported In -- HNG-X Rel. Ind. Top Ref PC0275563
Call Type Operational (SSC) Priority C -- Progress restricted
Contact EDSC Call Status Closed -- Avoidance Action Supplied
Target Date 03/12/2018 Effort (Man Days) 0
Summary Receipts & Payments mismatch Branch 133131 12th September 2018.
All References Type Value
External Email "Mark.Wright2¢_ GRO.
Call reference PC0275563
Collections Name User Date
-SSCCBA Chad Daborn 28-Nov-2018 10:23:28
Progress Narrative
pate: 28-Nov-2018 09:55:04 User: Mail Manager_
CALL PC0275564 opened
Details entered are:-
sommary:Receipts & Payments mismatch Branch 133131 12th September 2018.
call Type:0
call Priorit
target Rele:
outed to:E!
=
HNG-X Rel. Ind.
_Unassigned_
Date: 28-Nov-2018 09:55:04 User:
MAIL GENERATED INCIDENT
Date/Time Raised: 2018-11-28 09:55:04
Priority: C
Requested Team: EDSC
Requested Product: SSC Adhoc Request
kequested Release: HNG-X Rel. Ind.
email attachments: 0
riginator Email: "Mark.Wright:
[Daté:28-Nov-2018 09:55:03 User: Mail Manager
lAdded evidence item 'OriginalEmail.eml' from Email attachment
external Progress Update Ri B
riginator : "Mark.Wright2\_
sent Date : Wed Nov 28 09 o GMT 2078
subject : Receipts & Payments mismatch Branch 133131 12th September 2018.
fice 133131 had a ReP mismatch on the 12th September 2018
lest Winch FAD 1331310 Page 1
9:17 12/09/2018 TP 05
Final Branch Trading Statement - Office Copy From 15/08/18 To 12/09/18
Branch Total Suspense SU AA
cash On Hand B Fwd 17441.14 17441.14
11 Currencies Awaiting Collection B Fwd 0.00 0.00
suspense B Fwd 0.00 0.00
ther MOP B Fwd 0.00 0.00
rorkx B Fwd 3488.28 3488.28
ther Postage B Fwd 2365.00 2365.00
Remittances In Total 7350.00 7350.00
lAll Currency Rems from SUs 591.58 591.58
Gains to/from Suspense 0.00 0.00 0.00
11 Currency Pouches Despatched 591.58 591.58
FUJ00171918
FUJ00171918
<<
FUJ00171918
FUJ00171918
and Large x 4 76
sas bk 1st x 12 10
ISAS bk 2nd x 12 25
sas bk Ist x 6 113
lew POTeleCrd £5 7
lewPOTeleCrd £10 9
lewPOTeleCrd £20 10
Poca Cards
jew Postal Order 133
transaction Corrections 0
It certify that the content of this balancing and trading statement is an accurate reflection of the cash and stock on hand at
this branch.
signature:
** END OF REPORT ***
egards,
rk.
Date:28-Nov-2018 i
[Start of Response]
IPRESCAN
comments:
KEL Reference
5:20 User:Chad Daborn
ssigned User:Venkata
[End of Response]
Response code to call type 0 as Category 40 -- Pending -- Incident Under Investigation
[Date:28-Nov-2018 10:25:25 User:Chad Daborn
[the Call record has been assigned to the Team Member: Venkata Subbarao Konakalla
IDate:03-Dec-2018 09:25:17 Uscr:Venkata Subbarao Konakalla
Investigation details are captured under the peak call PC0275563 as both the calls are of the same issue.
jDate:14-Dec-2018 10:18:52 User:Chad Daborn
{fhe Call record has been assigned to the Team Member: Sirous Sattar
JDate:19-Dec-2018 13:26:07 User:John Simpkins
this has been affected by the same issue as Peak PC0275563. It is an EUM issue whilst rolling the branch TP whilst attached to a
lstock unit in the last TP.
Jat e:19-Dec-2018 13:26:19 User:John Simpkins
Reference Added: Call PCO275563
jbate:21-Dec-2018 11:52:04 User:John Simpkins
checking the suspense for TP 5 roll
select * from ops$brdb.brdb_su_opening balance
here branch accounting code = 133131
land stock unit = 'DEF'
land trading period = 5
land balance period = 1;
suspense B Fwd 0.00 0.00
FUJ00171918
FUJ00171918
Buspense © Fwa 0:00 0.00
select rsd.prod_id, rsd.amount, rsd.quantity
from brdb_rx_rep session data rsd
inner join BRDB_FAD HASH OUTLET MAPPING bfhom on rsd.BRANCH AC
fhom.FAD_HASH
inner join rdds products p on rsd.prod_id = p.prod_id
here rsd.branch accounting code = 133131
land rsd.stock unit != ‘DE!
land (p.12 = 490 or p.12-740)
land rsd.trading period = 5;
UNT ING
fhom.BRANCH ACCOUNTING CODE and rsd.PAD_HASH =
6842 -16.78
6864-348
Ib610 40
610-500
6509 401
6509-5001
6981 «16.78 170
71003 34.8 860
these total to zero.
select * from ops$brdb.brdb_su_opening balance
here branch_accounting code = 133131
land stock unit = 'DEF"
land trading period = 6
land balance period = 1;
PAD HASH" " “INSERT.
u
36
"BRANCH ACCOUNTING CODE" "STOCK UNIT" "TRADING PERIOD" “BALANCE PERIOD" "PROD_ID" "BRANCH COD}
"133131" “DEF
"133131" "12-SEP-18 19.21.33.118200000" "0" "0"
this shows the new opening to be Zero
1so from BTS
suspense B Fwd 0.00 0.00
This all looks to be correct.
Daterdi-dan-2019 08:51:43 User:John Simpkins
[Start of Response]
Development have recreated this issue in test. It is related to the BUM locking changes recently released to live.
h) Do some transactions in the SU e.g. that change the cash position
b) Lock counter A
3) Login as same HUID on counter B
a) Rollover stock unit into new TP
Is) Lock B
6) Unlock A with same HUID, same SU
7) A think SU is in old TP
ls) Roll branch
Is) BANG! Non zero trading position. CFwd figures wrongly-BFwd
jote that the BT
figures written to the BRDB are correct, and the next SU balance report and BTS trading statement are fine.
Until the fix has completed development and release to live we have implemented a couple of monitors.
Ht) A core hours monitor in HORIce which will identify and alert to any non-zero TP. (KEL wbra254M)
2) An overnight report that lists all occurrences the previous day and identifies if the cash BF = cash CF. This is emailed to
the Ssc manager for progressing.
le have checked that the suspense figures are correct for this branch (details above). The ‘corrupted’ BTS reprint has been
lshared with the Post Office.
[this call may now be closed.
[End of Response]
Response code to call type O as Category 70 -- Final -
routing to Call Logger following Final Progress update.
Defect cause updated to 14 -- Development - Code
Avoidance Action Supplied
Jbate:11-Jan-2019 08:51:48 User:John Simpkins
CALL PC0275564 closed: Category 70 Type 0
Root Cause Development - Code
Logger _Mail Manager_ -- EDSC
Subject Product General/Other/Misc -- SSC Adhoc Request (version unspecified)
Assignee _Mail Manager_ -- EDSC
Last Progress 11-Jan-2019 08:51 -- John Simpkins