POL00001568
POL00001568
OCP 25316 Withdrawn
This OCP withdrawn 02/02/2010 19:36 because OCP timings delayed until Thursday 04-feb
Fix BTS Data for More Pilot branches (Peak
193823)
The first HNG-X Branch (Coton) attempted to balance its accounts and when producing its BTS Report an
accounting mismatch was reported. The Counter team have examined the data and have identified
problems with the way in which the BRDB In Day migration package is writing data to
BRDB_RX_BTS_DATA.
The data in BRDB_RX_BTS_DATA for all Pilot branches has to be corrected, so accounts can reconcile.
The data in Coton and Warwick barnches has been fixed. This OCP is to correct the data for the next 6
Pilot branches.
The following 6 branches will be fixed :
268246 Bristnall Fields
296246 Lapworth
401246 Brownsover
354217 Three Pots
313227 Sawley
198247 Ombersley Road
This should not be applied on LST, as the branches do not exist on LST.
Justification: To allow the Pilot branches to balance their accounts.
When: Planned for 03/02/2010 07:30 with a duration of 10 minutes
Extra detail: There will be a script for each branch, added as separate attachments to this OCP. The script
name will include the Fad_Code of the branch e.g. BDB_268246_BTS_Fix.sql LOGIN to brdb node I as
unix user brdb Sqlplus / @<script name> ; exit;
Regression: Development can provide scripts to correct any issues.. Regression will take 10 minutes.
Comments
Gaby Reynolds (POL) wrote at 02/02/2010 16:10: From: emma.langfiel
[mailto: On Behalf Of Duty_Manag
Sent: 02 February 2010 15:14
To: POL.changecontr
Cc: RMGA Operational
GRO
F/571.1/1
POL00001568
POL00001568
Release_Implementation!
barry.r.evan{"
antonio,jamasI
scott.somer:
manny.dilworth
john.wheeler¢ GRO}
Subject: Re: Please approve OCP 25316 : Fix BTS Data for More Pilot branches (Peak 193823)
Afternoon
As this is a requirement POL approve this change
Jean Woolley (HNG-X RMGA Security) wrote at 02/02/2010 18:13: From: Clark Jason
Sent: 02 February 2010 18:01
To: RMGA Operational Change
Subject: RE: OCP 25316 URGENT THIS IS REQUIRED FOR 07:30 TOMORROW
Approved
Other details ,
Raised by: Steve Goddard 02/02/2010 12:57
Monitored by: Steve Goddard
Peak: PC0193823
Priority and risk
Priority: High
Risk: Low
Properties
New equipment: No
System build affected: No
Required on LST rigs: No
F/571.1/2
POL00001568
POL00001568
Required on Lewes rigs: No
Approval status
POA Operations Action status
Core Services SMC
Core Services NT Support
POA Development
‘Network and VPN
POL HING-X RMGA Security
F/571.1/3