orders-add-new

Query the orders, press ADD NEW, fill a header and save; ORDER_ID is mandatory and empty, so the save stops.

0defects

115values match

216tolerated by policy

0waived

62unmapped

Unmapped values are recorded on the original but have no counterpart the mapping names in the migrated app, so they are listed, not compared, and are not defects. Here: alert titles (6); the Forms record indicator ("Record: 1/2" in the status bar) (8); ORDER_ITEMS.ORDER_ID_FK, a Forms item with no field in the migrated screen (40); the list of open Forms windows (8).

Arabic text in this scenario is the original source's, kept word for word in the migrated app: حصل مشكلة في الحفظ، اتأكد من البيانات (roughly: Saving failed, check the data).

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 `ORDERS`
1	execute query	Click `Toolbar.Execute Query`
2	do not save	Answer the alert No
3	add new	Click `ORDERS.PUSH_BUTTON8`
4	header	Type `ORDERS.CUSTOMER_ID` = 1, `ORDERS.EMPLOYEE_ID` = 1, `ORDERS.TABLE_NUMBER` = 9
5	save	Click `ORDERS.PUSH_BUTTON10`	alert FRM-40202: Field must be entered.
6	acknowledge	Answer the alert OK	alert FRM-40222: Disabled item 'ORDERS.ORDER_ID' failed validation.
7	acknowledge validation	Answer the alert OK

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.

Step 0: open ORDERS

Original (Oracle Forms 14.1.2), step 00-open — Original (Oracle Forms 14.1.2)

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

Step 1: execute query

Original (Oracle Forms 14.1.2), step 01-execute-query — Original (Oracle Forms 14.1.2)

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

Step 2: do not save

Original (Oracle Forms 14.1.2), step 02-do-not-save — Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 02-do-not-save — Migrated (.NET, PostgreSQL)

Step 3: add new

Original (Oracle Forms 14.1.2), step 03-add-new — Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 03-add-new — Migrated (.NET, PostgreSQL)

Step 4: header

Original (Oracle Forms 14.1.2), step 04-header — Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 04-header — Migrated (.NET, PostgreSQL)

Step 5: save

Original (Oracle Forms 14.1.2), step 05-save — Original (Oracle Forms 14.1.2)

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

Step 6: acknowledge

Original (Oracle Forms 14.1.2), step 06-acknowledge — Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 06-acknowledge — Migrated (.NET, PostgreSQL)

Step 7: acknowledge validation

Original (Oracle Forms 14.1.2), step 07-acknowledge-validation — Original (Oracle Forms 14.1.2)

Migrated (.NET, PostgreSQL), step 07-acknowledge-validation — 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 ORDERS`	`ORDERS.CUSTOMER_ID[0]`	`ORDERS.ORDER_ID[0]` = 16
1	execute query	`Click Toolbar.Execute Query`	`FWindow/PushButton:Yes`		Press Tab to move between choices, Return to select.	Do you want to save the changes you have made?
2	do not save	`Answer the alert No`	`ORDERS.CUSTOMER_ID[0]`	`ORDERS.CUSTOMER_ID[0]` = 1 `ORDERS.DISCOUNT[0]` = 0 `ORDERS.EMPLOYEE_ID[0]` = 1 `ORDERS.FINAL_AMOUNT[0]` = 165 `ORDERS.ORDER_DATA[0]` = 03-OCT-2026 `ORDERS.ORDER_ID[0]` = 901 `ORDERS.ORDER_TYPE[0]` = Takeaway `ORDERS.STATUES[0]` = Delivered `ORDERS.TABLE_NUMBER[0]` = 3 `ORDERS.TOTAL_AMOUNT[0]` = 165 `ORDER_ITEMS.ITEM_ID[0]` = 901 `ORDER_ITEMS.ITEM_ID[1]` = 902 `ORDER_ITEMS.ORDER_ID_FK[0]` = 901 `ORDER_ITEMS.ORDER_ID_FK[1]` = 901 `ORDER_ITEMS.PRODUCT_ID_FK[0]` = 1 `ORDER_ITEMS.PRODUCT_ID_FK[1]` = 1 `ORDER_ITEMS.QUANTITY[0]` = 2 `ORDER_ITEMS.QUANTITY[1]` = 1 `ORDER_ITEMS.TOTAL_PRICE[0]` = 110 `ORDER_ITEMS.TOTAL_PRICE[1]` = 55 `ORDER_ITEMS.UNIT_PRICE[0]` = 55 `ORDER_ITEMS.UNIT_PRICE[1]` = 55	Customer Id1
3	add new	`Click ORDERS.PUSH_BUTTON8`	`ORDERS.CUSTOMER_ID[0]`	`ORDERS.ORDER_DATA[0]` = <date>	Customer Id1
4	header	`Type ORDERS.CUSTOMER_ID = 1, ORDERS.EMPLOYEE_ID = 1, ORDERS.TABLE_NUMBER = 9`	`ORDERS.TABLE_NUMBER[0]`	`ORDERS.CUSTOMER_ID[0]` = 1 `ORDERS.EMPLOYEE_ID[0]` = 1 `ORDERS.TABLE_NUMBER[0]` = 9	Customer Id1
5	save	`Click ORDERS.PUSH_BUTTON10`	`FWindow/PushButton:OK`		FRM-40202: Field must be entered.	FRM-40202: Field must be entered.	pass
6	acknowledge	`Answer the alert OK`	`FWindow/PushButton:OK`		FRM-40222: Disabled item 'ORDERS.ORDER_ID' failed validation.	FRM-40222: Disabled item 'ORDERS.ORDER_ID' failed validation.	pass
7	acknowledge validation	`Answer the alert OK`	`ORDERS.PUSH_BUTTON10[0]`		حصل مشكلة في الحفظ، اتأكد من البيانات

Database effects

sequence ORD_SEQ: next 16 -> 17, drawn [16]

Classified diff against the migrated app

Diff: orders-add-new
counts: match 115, tolerated 216, waived 0, defect 0, unmapped 62, harness 0
generated-id pairs (source -> target): ORD_SEQ#1 -> ORD_SEQ#1 (draw order)

waivers:
  W1 [proposed] ORDER_DATA saved as NULL: applied to 0 value(s)
  W2 [proposed] Order number consumed when the form opens: applied to 0 value(s)
  W3 [proposed] Line ITEM_ID typed by the user: applied to 0 value(s)
  W4 [proposed] Two modal alerts after saving: applied to 0 value(s)
  W5 [proposed] Key debug message on record navigation (single-table forms): applied to 0 value(s)
  W6 [proposed] Customer debug message in ORDERS: applied to 0 value(s)
  W7 [proposed] Placeholder alert on leaving Employees: applied to 0 value(s)
  W8 [proposed] Error message when the application starts: applied to 0 value(s)
  W9 [proposed] Keyboard hint of the Forms client while a question is open: applied to 0 value(s)
  W10 [proposed] An order added with Add cannot be saved: applied to 0 value(s)

[tolerated] ui.values.ORDERS.DISCOUNT  rule=money  x1
[tolerated] ui.values.ORDERS.FINAL_AMOUNT  rule=money  x1
[tolerated] ui.values.ORDERS.ORDER_DATA  rule=mask:default-date  x5
[tolerated] ui.values.ORDERS.ORDER_TYPE  rule=text  x7
[tolerated] ui.values.ORDERS.STATUES  rule=text  x7
[tolerated] ui.values.ORDERS.TOTAL_AMOUNT  rule=money  x1
[tolerated] ui.values.ORDER_ITEMS.ITEM_ID  rule=blank_rows  x38
[tolerated] ui.values.ORDER_ITEMS.PRODUCT_ID_FK  rule=blank_rows  x38
[tolerated] ui.values.ORDER_ITEMS.QUANTITY  rule=blank_rows  x38
[tolerated] ui.values.ORDER_ITEMS.TOTAL_PRICE  rule=blank_rows  x38
[tolerated] ui.values.ORDER_ITEMS.TOTAL_PRICE  rule=money  x2
[tolerated] ui.values.ORDER_ITEMS.UNIT_PRICE  rule=blank_rows  x38
[tolerated] ui.values.ORDER_ITEMS.UNIT_PRICE  rule=money  x2
[unmapped] ui.alert.title  (browser dialogs have no title)  x3
[unmapped] ui.record  (no target counterpart)  x8
[unmapped] ui.seen.alert.title  (browser dialogs have no title)  x3
[unmapped] ui.values.ORDER_ITEMS.ORDER_ID_FK  (no target item)  x40
[unmapped] ui.windows  (no target counterpart)  x8

Waivers

No waiver applies to this scenario: every compared value matches or is within the tolerance policy.