CareWell clinic / patients-query

patients-query

Query by example through the menu module: Records > Enter Query, a last name in the block, Records > Execute Query. File > Exit then closes CW_PATIENTS and returns to the home page.

0defects

317values match

18tolerated by policy

9waived

0unmapped

Three runs from a fresh database gave byte-identical diffs. Behaviour that looks odd in the migrated app but is the original's: faithful to the original and waivers. Files: scenario, golden record, target record, diff (JSON).

Scenario steps

Items are addressed by their Forms name (BLOCK.ITEM[row]), the same name in the original and, through the mapping, in the migrated app.

#	Step	Action	Checked on the original
0		Open form `cw_login`
1		Type `CTL.USERNAME` = ADMIN
2	sign in	Click `CTL.SIGN_IN`
3	patients	Click `HOME.PATIENTS`
4	enter query	Step {"label": "enter query", "menu": "RECORDS.QUERY"}
5		Type `PATIENTS.LAST_NAME[0]` = Banerjee
6	execute query	Step {"label": "execute query", "menu": "RECORDS.EXECUTE"}
7	exit	Step {"label": "exit", "menu": "FILE.EXIT"}

Screens, step by step

Left: the original Oracle Forms application, recorded on a virtual display. Right: the migrated application in headless Chromium. Screenshots are evidence only; the comparison works on the recorded values.

No step screenshots of the original were kept for this app; the comparison uses the recorded values, which are in the golden record below.

Step 0: open cw_login

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 00-open — Migrated (.NET, PostgreSQL)

Step 1: type

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 01-type — Migrated (.NET, PostgreSQL)

Step 2: sign in

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 02-sign-in — Migrated (.NET, PostgreSQL)

Step 3: patients

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 03-patients — Migrated (.NET, PostgreSQL)

Step 4: enter query

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 04-enter-query — Migrated (.NET, PostgreSQL)

Step 5: type

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 05-type — Migrated (.NET, PostgreSQL)

Step 6: execute query

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 06-execute-query — Migrated (.NET, PostgreSQL)

Step 7: exit

no screenshot

Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 07-exit — Migrated (.NET, PostgreSQL)

Golden record of the original

After each step: the focus, the displayed values that changed, the message line and any alert. The full record (every item of every step, windows, lists of values) is in the JSON file.

#	Step	Action (by name)	Focus after	Displayed values that changed	Message line	Alert	Expect
0		`Open form cw_login`	`CTL.USERNAME[0]`
1		`Type CTL.USERNAME = ADMIN`	`CTL.USERNAME[0]`	`CTL.USERNAME[0]` = ADMIN
2	sign in	`Click CTL.SIGN_IN`	`HOME.SCHEDULE[0]`	`HOME.CHECKED_IN[0]` = <any> `HOME.OPEN_AMOUNT[0]` = 15,015 `HOME.OPEN_INVOICES[0]` = 180 `HOME.TODAY_TOTAL[0]` = <any> `HOME.WELCOME[0]` = Welcome, Clinic Administrator
3	patients	`Click HOME.PATIENTS`	`PATIENTS.MRN[0]`	`CTL.COUNTER[0]` = Patient 1 of 240 `PATIENTS.CITY[0]` = Noida `PATIENTS.CITY[1]` = Gurugram `PATIENTS.CITY[2]` = Delhi `PATIENTS.CITY[3]` = Bengaluru `PATIENTS.CITY[4]` = Delhi `PATIENTS.CITY[5]` = Pune `PATIENTS.CITY[6]` = Hyderabad `PATIENTS.CITY[7]` = Gurugram `PATIENTS.CITY[8]` = Chennai `PATIENTS.FIRST_NAME[0]` = Adam `PATIENTS.FIRST_NAME[1]` = Meera `PATIENTS.FIRST_NAME[2]` = Riya `PATIENTS.FIRST_NAME[3]` = Samuel `PATIENTS.FIRST_NAME[4]` = Sara `PATIENTS.FIRST_NAME[5]` = Aisha `PATIENTS.FIRST_NAME[6]` = Aisha `PATIENTS.FIRST_NAME[7]` = Arjun `PATIENTS.FIRST_NAME[8]` = David `PATIENTS.LAST_NAME[0]` = Ali `PATIENTS.LAST_NAME[1]` = Ali `PATIENTS.LAST_NAME[2]` = Ali `PATIENTS.LAST_NAME[3]` = Ali `PATIENTS.LAST_NAME[4]` = Ali `PATIENTS.LAST_NAME[5]` = Banerjee `PATIENTS.LAST_NAME[6]` = Banerjee `PATIENTS.LAST_NAME[7]` = Banerjee `PATIENTS.LAST_NAME[8]` = Banerjee `PATIENTS.MRN[0]` = CW100686 `PATIENTS.MRN[1]` = CW100791 `PATIENTS.MRN[2]` = CW100427 `PATIENTS.MRN[3]` = CW100014 `PATIENTS.MRN[4]` = CW100084 `PATIENTS.MRN[5]` = CW100350 `PATIENTS.MRN[6]` = CW100847 `PATIENTS.MRN[7]` = CW100966 `PATIENTS.MRN[8]` = CW101547 `PATIENTS.PHONE[0]` = +91 9714247138 `PATIENTS.PHONE[1]` = +91 9747265671 `PATIENTS.PHONE[2]` = +91 9319917758 `PATIENTS.PHONE[3]` = +91 9239366764 `PATIENTS.PHONE[4]` = +91 9231537636 `PATIENTS.PHONE[5]` = +91 9698396784 `PATIENTS.PHONE[6]` = +91 9078161038 `PATIENTS.PHONE[7]` = +91 9550902396 `PATIENTS.PHONE[8]` = +91 9732765917 `PATIENTS.PLAN_ID[1]` = 5 `PATIENTS.PLAN_ID[3]` = 6 `PATIENTS.PLAN_ID[5]` = 6 `PATIENTS.PLAN_ID[8]` = 1
4	enter query	`Step {"label": "enter query", "menu": "RECORDS.QUERY"}`	`PATIENTS.MRN[0]`		Enter a query; press Ctrl+F11 to execute, F4 to cancel.
5		`Type PATIENTS.LAST_NAME[0] = Banerjee`	`PATIENTS.LAST_NAME[0]`	`PATIENTS.LAST_NAME[0]` = Banerjee	Enter a query; press Ctrl+F11 to execute, F4 to cancel.
6	execute query	`Step {"label": "execute query", "menu": "RECORDS.EXECUTE"}`	`PATIENTS.MRN[0]`	`CTL.COUNTER[0]` = Patient 1 of 240 `PATIENTS.CITY[0]` = Pune `PATIENTS.CITY[1]` = Hyderabad `PATIENTS.CITY[2]` = Gurugram `PATIENTS.CITY[3]` = Chennai `PATIENTS.CITY[4]` = Hyderabad `PATIENTS.CITY[5]` = Noida `PATIENTS.CITY[6]` = Gurugram `PATIENTS.CITY[7]` = Bengaluru `PATIENTS.CITY[8]` = Delhi `PATIENTS.FIRST_NAME[0]` = Aisha `PATIENTS.FIRST_NAME[1]` = Aisha `PATIENTS.FIRST_NAME[2]` = Arjun `PATIENTS.FIRST_NAME[3]` = David `PATIENTS.FIRST_NAME[4]` = Fatima `PATIENTS.FIRST_NAME[5]` = Imran `PATIENTS.FIRST_NAME[6]` = Julia `PATIENTS.FIRST_NAME[7]` = Leila `PATIENTS.FIRST_NAME[8]` = Leo `PATIENTS.LAST_NAME[1]` = Banerjee `PATIENTS.LAST_NAME[2]` = Banerjee `PATIENTS.LAST_NAME[3]` = Banerjee `PATIENTS.LAST_NAME[4]` = Banerjee `PATIENTS.LAST_NAME[5]` = Banerjee `PATIENTS.LAST_NAME[6]` = Banerjee `PATIENTS.LAST_NAME[7]` = Banerjee `PATIENTS.LAST_NAME[8]` = Banerjee `PATIENTS.MRN[0]` = CW100350 `PATIENTS.MRN[1]` = CW100847 `PATIENTS.MRN[2]` = CW100966 `PATIENTS.MRN[3]` = CW101547 `PATIENTS.MRN[4]` = CW101302 `PATIENTS.MRN[5]` = CW100770 `PATIENTS.MRN[6]` = CW100945 `PATIENTS.MRN[7]` = CW100826 `PATIENTS.MRN[8]` = CW100903 `PATIENTS.PHONE[0]` = +91 9698396784 `PATIENTS.PHONE[1]` = +91 9078161038 `PATIENTS.PHONE[2]` = +91 9550902396 `PATIENTS.PHONE[3]` = +91 9732765917 `PATIENTS.PHONE[4]` = +91 9918174827 `PATIENTS.PHONE[5]` = +91 9424835202 `PATIENTS.PHONE[6]` = +91 9681383364 `PATIENTS.PHONE[7]` = +91 9559794159 `PATIENTS.PHONE[8]` = +91 9946103776 `PATIENTS.PLAN_ID[0]` = 6 `PATIENTS.PLAN_ID[3]` = 1 `PATIENTS.PLAN_ID[4]` = 5 `PATIENTS.PLAN_ID[5]` = 5 `PATIENTS.PLAN_ID[6]` = 3 `PATIENTS.PLAN_ID[7]` = 5
7	exit	`Step {"label": "exit", "menu": "FILE.EXIT"}`	`HOME.SCHEDULE[0]`	`HOME.WELCOME[0]` = Welcome,

Database effects

None: the scenario changes no row and draws no sequence value.

Classified diff against the migrated app

Diff: patients-query
counts: match 317, tolerated 18, waived 9, defect 0, unmapped 0, harness 0
generated-id pairs (source -> target): none

waivers:
  C1 [proposed] Oracle's frame title before sign-in: applied to 2 value(s)
  C2 [proposed] The home page's collected-today gauge reads empty: applied to 6 value(s)
  C3 [proposed] Help > About names nobody: applied to 0 value(s)
  C4 [proposed] The home page forgets the user after File > Exit of a module: applied to 1 value(s)
  C5 [proposed] No item has the focus after a fetched record is refused: applied to 0 value(s)
  C6 [proposed] The second payment of billing-pay is lost: applied to 0 value(s)

[tolerated] ui.values.HOME.CHECKED_IN  rule=mask:today-counts  x6
[tolerated] ui.values.HOME.OPEN_AMOUNT  rule=text  x6
[tolerated] ui.values.HOME.TODAY_TOTAL  rule=mask:today-counts  x6
[waived] ui.values.HOME.COLLECTED  rule=waiver:C2  x6
    step02.values.HOME.COLLECTED[0]: source '' | target '83'
    step03.values.HOME.COLLECTED[0]: source '' | target '83'
    step04.values.HOME.COLLECTED[0]: source '' | target '83'
    step05.values.HOME.COLLECTED[0]: source '' | target '83'
    step06.values.HOME.COLLECTED[0]: source '' | target '83'
    step07.values.HOME.COLLECTED[0]: source '' | target '83'
[waived] ui.values.HOME.WELCOME  rule=waiver:C4  x1
    step07.values.HOME.WELCOME[0]: source 'Welcome,' | target 'Welcome, Front Desk One'
[waived] ui.windows  rule=waiver:C1  x2
    step00.windows: source [["FRAME", "Oracle Fusion Middleware Forms Services"], ["MAIN_WIN",... | target [["FRAME", "CareWell Clinic"], ["MAIN_WIN", "CareWell Clinic - Sign...
    step01.windows: source [["FRAME", "Oracle Fusion Middleware Forms Services"], ["MAIN_WIN",... | target [["FRAME", "CareWell Clinic"], ["MAIN_WIN", "CareWell Clinic - Sign...

Waivers

Id	Waiver	Values	Reason
C1	Oracle's frame title before sign-in	2	Until CW_NAV.START_FORM sets the MDI title, the Forms frame shows the runtime's own title "Oracle Fusion Middleware Forms Services". The target's frame reads "CareWell Clinic" from the start: the web page is the clinic's application, not Oracle's runtime. From sign-in on, both show the same title.
C2	The home page's collected-today gauge reads empty	6	HOME.COLLECTED is a display item drawn as a half gauge on the original canvas; the Forms client's component tree exposes no text for it, so the source records '' at every step. The target shows the amount REFRESH_HOME computes (the same query as the source), as a number with a bar.
C4	The home page forgets the user after File > Exit of a module	1	CW_PATIENTS, opened with OPEN_FORM after the NEW_FORM from CW_LOGIN, signs in its own library instance (P_USER); when it exits, CW_MAIN's WHEN-FORM-NAVIGATE (REFRESH_HOME) finds the library's package data empty and shows "Welcome," without a name. The target keeps the signed-in user's name on the home page.