INFORMATION SERVICES DIVISION

User Acceptance Testing – Example Script Template

DOCUMENT INFORMATION

Project Name

Project Number

Project Account Code

Author

Issue Date

DOCUMENT HISTORY

Version Date Summary of change Author

1.0 12/08/2014 Release version Pete Castle

APPROVALS

Name Title Signature Escalation

DOCUMENT CIRCULATION

Version Date Person/Group Author

This document may include information that is CONFIDENTIAL and shall not be disclosed outside
UCL and shall not be duplicated, used, or disclosed in whole or in part for any purpose other than to
evaluate and implement procedures defined within this document.
User Acceptance Testing – Example Script Template v1.0
INFORMATION SERVICES DIVISION

CONTENTS
1. ACCEPTANCE TESTING SCOPE........................................................................................................2
1.1 Testing and Acceptance Criteria – Stage 1 Tests....................................................................2
1.2 Sign-off Criteria......................................................................................................................3
2. MILESTONES..................................................................................................................................3
3. RISK AND CONTINGENCIES............................................................................................................3
4. SIGN OFF........................................................................................................................................3

Page 2 of 8 Project Delivery Framework UCL©2014

 User Acceptance Testing – Example Script Template v1.0
INFORMATION SERVICES DIVISION

1. ACCEPTANCE TESTING SCOPE

Testing and acceptance of the proposed solution will be performed as follows:

1.1 Testing and Acceptance Criteria – Stage 1 Tests

Stage 1 Tests

Test Category of ITT Details Pass criteria Owner Comment

Ref Test Ref.

1. Verification of 3.1.1 Verification that all As per T. Ester

equipment equipment is supplied kit
supplied supplied as specified list.
in the tender. Any
variations to
equipment (including
components) shall
only be accepted by
prior agreement
with the Buyer.

2. Compliance 3.1.2 Confirmation that As per ITT [Link]

with UCL’s the running
requirements & equipment complies
constraints with all UCL’s stated
environmental and
infrastructural
requirements and
constraints.

3. Verification 3.1.3 Verification that all Sign off from A.N.

that equipment units have passed Q Associates Other
has passed the Seller’s own
seller’s diagnostics, set at
diagnostic tests their most rigorous
levels.

4. Accommodatio 3.1.4 Confirm hardware To match A.N.

n fits within the Tender Other
proposed response
accommodation\
cabinet space In KLB
and Wolfson House
as per the
information in the
Tender. Confirm
hardware access on
slide rails.

Page 3 of 8 Project Delivery Framework UCL©2014

 User Acceptance Testing – Example Script Template v1.0
INFORMATION SERVICES DIVISION

5. Uninterrupted, 3.1.5 Uninterrupted, Sign off from [Link]

continuous continuous running Q Associates
running of of the equipment for
equipment 48 hours without a
hardware failure
becoming apparent.

1.2 Testing and Acceptance Criteria Stage 2 Tests

 Testing will be conducted by UCL staff with support from the Tenderer where required.
 Overall responsibility for sign-off of stage 2: Quentin North (Database Infrastructure Group
Manager)
 Owners of individual tests (where known) are detailed in the table below

Stage 2 Tests

Test Category of ITT Details Pass criteria Owner Comment

Ref Test Ref.

1. Oracle 3.1.1 Successful An empty T. Ester

Installation installation of a database shall
single Oracle successfully
Database Server be created
Enterprise Edition using Oracle
[Link] onto the DBCA with
solution. Should Oracle default
partitioning of the tablespaces
solution be flexible, and schemas
then the partition
configured for this
An SQL*Plus
purpose will have
session shall
not more than
be
1/60th, or 1 unit of
successfully
measure where no
opened to the
further division is
new
possible, of the
overall total CPU, database
disk and memory
intended for the
The Oracle
operation of Oracle
Net Listener
databases within the
starts
solution. This is
successfully
based on benchmark
requirements to
support the current A remote
quantity of database session shall
instances in use at successfully
UCL with equal be
resources. established to
Page 4 of 8 Project Delivery Framework UCL©2014
User Acceptance Testing – Example Script Template v1.0
INFORMATION SERVICES DIVISION

the database
The instance shall be
started successfully
with 5Gb of SGA
memory

2. Oracle Import Test The database . All schemas [Link]

previously installed and their
shall be successfully objects will
populated with a have been
complete export of created and
the current SITS populated
production database without error.
using the Oracle The elapsed
Import utility and time for the
UCL developed import to
scripts execute will
not exceed
the current
benchmark
time using the
existing UCL
database
environment.

3. Oracle Load Set Oracle processes Success will A.N.

Test 1 to 600 and make have been Other
300 simultaneous achieved if
connections to the each metric is
previously created within the 2σ
database using a of benchmark
bespoke script that μ.
has been created to
launch multiple
All processes
SQL*Plus sessions as
terminate
background
without error
processes. Each
and non-zero
script will run a
iteration
payload of inserts,
count.
updates and deletes
for a specified
period. Before All sessions
exiting the number must have
of iterations, the target
elapsed time in max sessions
seconds and active at the
contents of mid-point in
V$SESS_IO for the iterations of
sessions are the test, as
recorded. These recorded by

Page 5 of 8 Project Delivery Framework UCL©2014

User Acceptance Testing – Example Script Template v1.0
INFORMATION SERVICES DIVISION

results will be the test

compared to script.
benchmarks
conducted using the
The test
existing UCL
completes
database
successfully
environment.
whether
executed on
the local host
or from a
remote client
over the
network.

1. Oracle 3.1.1 Successful An empty T. Ester

Installation installation of a database shall
single Oracle successfully
Database Server be created
Enterprise Edition using Oracle
[Link] onto the DBCA with
solution. Should Oracle default
partitioning of the tablespaces
solution be flexible, and schemas
then the partition
configured for this
An SQL*Plus
purpose will have
session shall
not more than
be
1/60th, or 1 unit of
successfully
measure where no
opened to the
further division is
new
possible, of the
overall total CPU, database
disk and memory
intended for the
The Oracle
operation of Oracle
Net Listener
databases within the
starts
solution. This is
successfully
based on benchmark
requirements to
support the current A remote
quantity of database session shall
instances in use at successfully
UCL with equal be
resources. established to
the database

The instance shall be

started successfully
with 5Gb of SGA
memory

Page 6 of 8 Project Delivery Framework UCL©2014

User Acceptance Testing – Example Script Template v1.0
INFORMATION SERVICES DIVISION

2. Oracle Import Test The database . All schemas [Link]

previously installed and their
shall be successfully objects will
populated with a have been
complete export of created and
the current SITS populated
production database without error.
using the Oracle The elapsed
Import utility and time for the
UCL developed import to
scripts execute will
not exceed
the current
benchmark
time using the
existing UCL
database
environment.

1.3 Sign-off Criteria

Sign-off Criteria

Item Acceptance Criteria Responsibility

1. All stage 1 Acceptance Criteria signed off as complete [Link] Senior

2. All stage 2 Acceptance Criteria signed off as complete [Link] Senior

2. MILESTONES

Date Milestone

Not Known Contract Awarded

Not Known Installation Start Date

Not Known Installation Completion Date

Not Known Start of Acceptance Testing

Not Known Vendor Sign off (to be agreed)

Page 7 of 8 Project Delivery Framework UCL©2014

 User Acceptance Testing – Example Script Template v1.0
INFORMATION SERVICES DIVISION

3. RISK AND CONTINGENCIES

Identifier Risk Contingency

1. UCL resources unavailable to 1. Publish schedules as early as possible to identify any resource
undertake testing shortfall.
2. Ensure a back-up resource is identified and available during
the required test period.

2. Delay in hardware installation 1. Ensure that test resources are informed of expected UAT
dates on a regular basis – schedule published on SharePoint.
2. Ensure Tenderer fully aware of UCL testing schedule.

4. SIGN OFF

Required signatures for sign off UAT Test Plan (this document).

Name Title/Responsibility Signature

Page 8 of 8 Project Delivery Framework UCL©2014