Oracle Forms Generic Utp

Forms Generic UTP.doc Author: Date: Version:

Brendan Furey ([email protected]) 29 January 2008 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

Introduction

1

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 Execution Steps Queryable 1 Do Enter and Execute Query Query Find 1 Do Query Find #

1 2 3

1 2 4 1 2 5 1

Insert Insert a record and save Requery the record Update Update a record and save Requery the record Delete Delete a record and save

2 6

Requery the record Order By 1 Query records

7 1 8

Uniqueness Insert duplicate record

Dynamic property setting Go to block where properties set to off conditionally 2 Go to block where properties not set conditionallyy 1

Expected / Obtained Results Succeeds Succeeds Succeeds

Result / Comments Result / Comments

St

S Check function allowed/not as expected S Check function allowed/not as expected S Check function allowed/not as expected

Insert saved Succeeds

S Check function allowed/not as expected

Updates saved Succeeds

S Check function allowed/not as expected If allowed, check not allowed when detail record exists

Record gone S Order matches expected order Rejected

S Check rejected at item/record level or at save as appropriate Where applicable S

Verify non-updateable or deletable as applicable Check that properties do not remain at settings from previous block

2.2 Query Find # #

Test Case Execution Steps

Expected / Obtained Results

Result / Comments Result / Comments

Page 2 of 7

St

1 1

2

Query Find – single field – repeat for each field Enter a single field and Result set matches criterion click Find

Query Find – several fields Enter several fields and click Find 2 Check ordering 1

3 1 2 4 1 2 5 1 2 6 1 2 3 4

S Range pairs tested below in #4. Enter %string% for wildcard fields S

Result set matches criteria

Order matches expected order Clear button clears block (but not list block) Run query with at least one criterion to obtain records in target block Click Clear Query block cleared, but not target block Check range criteria - repeat for each range Enter invalid pair Error message Enter valid pair and Result set matches criterion query Visible Field dependencies Set both fields Null the master field Dependent field nulls Hidden Field dependencies Set descriptive field Click Find Record number of records Change descriptive field Dependent field nulls Click Find Check if number of records changes

S

S

S S

2.3 Insert # # 1 1 2 3 2 1 2 3 3 1

Test Case Execution Steps Insert - minimal Insert new record entering mandatory fields only and save Requery the record Check fields Insert - maximal Insert new record entering all fields possible and save Requery the record Check fields Who columns Check values using Help/Record History

Expected / Obtained Results

Result / Comments Result / Comments

St S

Succeeds Insert saved Fields match those input S Succeeds Insert saved Fields match those input S Should be current user, date

2.4 Querying #

Test Case Result / Comments St Execution Steps Expected / Obtained Results Result / Comments 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 #

1

Page 3 of 7

possible 2 4

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

S S

2.5 Update # # 1 1 2 3 2 1 2 3 3 1

Test Case Execution Steps Update - maximal Update record entering all fields possible and save Requery the record Check fields Record locking Open form twice Query same record in each instance Try to update record in both instances Who columns Check values using Help/Examine

Expected / Obtained Results

Result / Comments Result / Comments

St S

Succeeds Update saved Fields match those input S

Second attempt gives locking error

Should offer to retry S

2.6 Keys Function

Key

Block Menu Clear Block Clear Field Clear Form Clear Record Commit Count Query Delete Record Display Error Down Duplicate Field Duplicate Record Edit Enter Query Execute Query Exit Help

Ctrl+B F7 F5 F8 F6 Ctrl+S F12 Ctrl+Up Shift+Ctrl+E Down Shift+F5 Shift+F6 Ctrl+E F11 Ctrl+F11 F4 Ctrl+H

Insert Record List of Values List Tab Pages Next Block

Ctrl+Down Ctrl+L F2 Shift+PageDown

Unavailable

Note

X

X

Key works, but page problem

Page 4 of 7

Next Primary Key Next Record Previous Block Print Scroll Down Scroll Up Show Keys Up #

Shift+F7 Down Shift+PageUp Ctrl+P PageDown PageUp Ctrl+K Up

Test Case Execution Steps All keys work 1 Try each function key/menu item #

1

2

Check function availability

X

Suppress

Expected / Obtained Results

Result / Comments Result / Comments

St S

Works as expected

Try all on at least one normal and one modal block

Expected functions only available

2.7 Item Tests – for each item in block # # 1 1 2 2 1 3 1 4 1 5 1 6 1

Test Case Execution Steps Tab order Tab through the block Tab backwards through the block Insertable Enter field in new record Updateable Update field in queried record Queryable Enter field in Enter Query mode Mandatory Leave field null and change record or save LOV Check availability

2 3

Check title Check columns

4 5

Check ordering Check inactive records excluded on LOVs

Result / Comments Result / Comments

St S

Fields visited in logical order Fields visited in logical order S Allowed/not allowed

Per design

Allowed/not allowed

Per design

Allowed/not allowed

Per design

Allowed/not allowed

Per design

S S S

Available/not available Meaningful Correct columns, widths, titles Sensible Poplists, inactive included but listed last with INACTIVE identifier

S Per design. Query Find may have wildcards instead of LOV

Except Query Find blocks

6 7 8

Check records restricted by any master fields set Validation 1 Check validation Format mask 1 Check mask

Expected / Obtained Results

S Per design S Amounts 2dp

Page 5 of 7

9

10 11

appropriate Field length 1 Enter as many characters as possible and try to save Case 1 Check appropriate Dependent fields 1 Check nulled when master set

12 1

3

Dates standard 11-char S Should not get Oracle error S Codes UC

Description fields with hidden code Check code nulled Use Help/Examine when description nulled

S See LOV tests. Other forms of dependency in specific UTP S See LOV tests. Other forms of dependency in specific UTP

Forms Level Tests

3.1 Tab/Window Tests – for each in form #

Test Case Execution Steps Button functionality 1 Check enabled/disabled #

1 2

1

Layout Check prompts

2 3 3

Check all fields present Object appearance Modal window 1 Function keys unavailable

Expected / Obtained Results As required

Result / Comments Result / Comments

St

S May be conditional, per design S

Sensible and consistent system-wide Per design Apps property classes used S Ok and Cancel only (usually)

3.2 Navigation Tests #

Test Case Execution Steps Next Block/Previous Block 1 Do Next Block sequentially starting at first 2 Do Previous Block sequentially starting at last #

1

2

Expected / Obtained Results

Result / Comments Result / Comments

St S

Should navigate (logically) only within window or tab Should navigate (logically) only within window or tab

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

S

1 3

S

3.3 Version Tests # # 1

Test Case Execution Steps Version info correct

Expected / Obtained Results

Result / Comments Result / Comments

St S

Page 6 of 7

1

Click Help/About Oracle Applications

Form version and date should be sensible

Not copied from template form

Page 7 of 7