Forms Generic UTP.

doc

Author: Brendan Furey ([email protected])

Date: 29 January 2008
Version: 1.4

Contents
1 Introduction.................................................................................................................2
2 Block Tests – for each block.......................................................................................2
2.1 Block Properties...................................................................................................2
2.2 Query Find............................................................................................................2
2.3 Insert.....................................................................................................................3
2.4 Querying...............................................................................................................3
2.5 Update..................................................................................................................4
2.6 Keys......................................................................................................................4
2.7 Item Tests – for each item in block......................................................................5
3 Forms Level Tests........................................................................................................6
3.1 Tab/Window Tests – for each in form..................................................................6
3.2 Navigation Tests...................................................................................................6
3.3 Version Tests.........................................................................................................6

Page 1 of 7
1 Introduction
This test plan is intended for use on any new form. It takes the form of a check list for testing
standard forms functionality, and should be executed in addition to (or as part of) a test plan
specific to the form.

2 Block Tests – for each block

Copy the table below for each block, filling in the desired properties, before executing
the block tests.
Q QF I U D Order By Uniqueness

2.1 Block Properties

# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments
1 Queryable S
1 Do Enter and Execute Succeeds Check function
Query allowed/not as expected
2 Query Find S
1 Do Query Find Succeeds Check function
allowed/not as expected
3 Insert S
1 Insert a record and Succeeds Check function
save allowed/not as expected
2 Requery the record Insert saved
4 Update S
1 Update a record and Succeeds Check function
save allowed/not as expected
2 Requery the record Updates saved
5 Delete S
1 Delete a record and Succeeds Check function
save allowed/not as expected
If allowed, check not
allowed when detail
record exists
2 Requery the record Record gone
6 Order By S
1 Query records Order matches expected
order
7 Uniqueness S
1 Insert duplicate record Rejected Check rejected at
item/record level or at
save as appropriate
8 Dynamic property setting Where applicable S
1 Go to block where Verify non-updateable or
properties set to off deletable as applicable
conditionally
2 Go to block where Check that properties do not
properties not set remain at settings from
conditionallyy previous block

2.2 Query Find

# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments

Page 2 of 7
1 Query Find – single field – repeat for each field S
1 Enter a single field and Result set matches criterion Range pairs tested
click Find below in #4.
Enter %string% for
wildcard fields
2 Query Find – several fields S
1 Enter several fields and Result set matches criteria
click Find
2 Check ordering Order matches expected
order
3 Clear button clears block (but not list block) S
1 Run query with at least
one criterion to obtain
records in target block
2 Click Clear Query block cleared, but not
target block
4 Check range criteria - repeat for each range S
1 Enter invalid pair Error message
2 Enter valid pair and Result set matches criterion
query
5 Visible Field dependencies S
1 Set both fields
2 Null the master field Dependent field nulls
6 Hidden Field dependencies S
1 Set descriptive field
2 Click Find Record number of records
3 Change descriptive field Dependent field nulls
4 Click Find Check if number of records
changes

2.3 Insert
# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments
1 Insert - minimal S
1 Insert new record Succeeds
entering mandatory
fields only and save
2 Requery the record Insert saved
3 Check fields Fields match those input
2 Insert - maximal S
1 Insert new record Succeeds
entering all fields
possible and save
2 Requery the record Insert saved
3 Check fields Fields match those input
3 Who columns S
1 Check values using Should be current user, date
Help/Record History

2.4 Querying
# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments
1 Enter Query – single field – repeat for each queryable May use maximal S
field insert record from
above
1 Enter a single field and Result set matches criterion Check case-insensitivity
Execute Query by mixing case if

Page 3 of 7
 possible
2 Enter Query – several fields S
1 Enter several fields and Result set matches criteria
Execute Query
4 Querying does not update records S
1 Execute Query from an Records returned
unchanged form state
2 Exit form No save changes prompt

2.5 Update
# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments
1 Update - maximal S
1 Update record entering Succeeds
all fields possible and
save
2 Requery the record Update saved
3 Check fields Fields match those input
2 Record locking S
1 Open form twice
2 Query same record in
each instance
3 Try to update record in Second attempt gives Should offer to retry
both instances locking error
3 Who columns S
1 Check values using
Help/Examine

2.6 Keys
Function Key Unavailable Note
Block Menu Ctrl+B X
Clear Block F7
Clear Field F5
Clear Form F8
Clear Record F6
Commit Ctrl+S
Count Query F12
Delete Record Ctrl+Up
Display Error Shift+Ctrl+E
Down Down
Duplicate Field Shift+F5
Duplicate Record Shift+F6 X
Edit Ctrl+E
Enter Query F11
Execute Query Ctrl+F11
Exit F4
Help Ctrl+H Key works, but page
problem
Insert Record Ctrl+Down
List of Values Ctrl+L
List Tab Pages F2
Next Block Shift+PageDown

Page 4 of 7
Next Primary Key Shift+F7 X Suppress
Next Record Down
Previous Block Shift+PageUp
Print Ctrl+P
Scroll Down PageDown
Scroll Up PageUp
Show Keys Ctrl+K
Up Up

# Test Case Result / Comments St

# Execution Steps Expected / Obtained Results Result / Comments
1 All keys work S
1 Try each function Works as expected Try all on at least one
key/menu item normal and one modal
block
2 Check function Expected functions only
availability available

2.7 Item Tests – for each item in block

# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments
1 Tab order S
1 Tab through the block Fields visited in logical order
2 Tab backwards through Fields visited in logical order
the block
2 Insertable S
1 Enter field in new Allowed/not allowed Per design
record
3 Updateable S
1 Update field in queried Allowed/not allowed Per design
record
4 Queryable S
1 Enter field in Enter Allowed/not allowed Per design
Query mode
5 Mandatory S
1 Leave field null and Allowed/not allowed Per design
change record or save
6 LOV S
1 Check availability Available/not available Per design. Query Find
may have wildcards
instead of LOV
2 Check title Meaningful
3 Check columns Correct columns, widths,
titles
4 Check ordering Sensible
5 Check inactive records Poplists, inactive included Except Query Find
excluded on LOVs but listed last with INACTIVE blocks
identifier
6 Check records
restricted by any master
fields set
7 Validation S
1 Check validation Per design
8 Format mask S
1 Check mask Amounts 2dp

Page 5 of 7
 appropriate Dates standard 11-char
9 Field length S
1 Enter as many Should not get Oracle error
characters as possible
and try to save
10 Case S
1 Check appropriate Codes UC
11 Dependent fields S
1 Check nulled when See LOV tests. Other
master set forms of dependency in
specific UTP
12 Description fields with hidden code S
1 Check code nulled Use Help/Examine See LOV tests. Other
when description nulled forms of dependency in
specific UTP

3 Forms Level Tests

3.1 Tab/Window Tests – for each in form
# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments
1 Button functionality S
1 Check enabled/disabled As required May be conditional, per
design
2 Layout S
1 Check prompts Sensible and consistent
system-wide
2 Check all fields present Per design
3 Object appearance Apps property classes used
3 Modal window S
1 Function keys Ok and Cancel only (usually)
unavailable

3.2 Navigation Tests

# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments
1 Next Block/Previous Block S
1 Do Next Block Should navigate (logically)
sequentially starting at only within window or tab
first
2 Do Previous Block Should navigate (logically)
sequentially starting at only within window or tab
last

2 Tab changing from valid item S

1 Click new tab Should navigate to first block
in new tab
3 Tab changing from invalid item S
1 Click new tab Should remain in current
item with current tab still
visible

3.3 Version Tests

# Test Case Result / Comments St
# Execution Steps Expected / Obtained Results Result / Comments
1 Version info correct S

Page 6 of 7
1 Click Help/About Oracle Form version and date Not copied from
Applications should be sensible template form

Page 7 of 7