Retail order system / orders-save-fails
orders-save-fails
Enter an order with a line whose ITEM_ID already exists, press SAVE; the commit fails.
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 (2); the Forms record indicator ("Record: 1/2" in the status bar) (8); the list-of-values column Price (1); list-of-values window titles (1); 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); قائمه المشروبات
(Drinks list).
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 | header | Type ORDERS.CUSTOMER_ID = 1, ORDERS.EMPLOYEE_ID = 1 | |
| 2 | line id | Type ORDER_ITEMS.ITEM_ID[0] = 901 | |
| 3 | line product | List of values on ORDER_ITEMS.PRODUCT_ID_FK[0], pick Name = Latte | |
| 4 | line quantity | Type ORDER_ITEMS.QUANTITY[0] = 1 | |
| 5 | leave quantity | Press Tab | |
| 6 | save | Click ORDERS.PUSH_BUTTON10 | alert FRM-40508: ORACLE error: unable to INSERT record. |
| 7 | acknowledge insert error | 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
Step 1: header
Step 2: line id
Step 3: line product
Step 4: line quantity
Step 5: leave quantity
Step 6: save
Step 7: acknowledge insert error
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 | header | Type ORDERS.CUSTOMER_ID = 1, ORDERS.EMPLOYEE_ID = 1 | ORDERS.EMPLOYEE_ID[0] | ORDERS.CUSTOMER_ID[0] = 1ORDERS.EMPLOYEE_ID[0] = 1 | |||
| 2 | line id | Type ORDER_ITEMS.ITEM_ID[0] = 901 | ORDER_ITEMS.ITEM_ID[0] | ORDER_ITEMS.ITEM_ID[0] = 901ORDER_ITEMS.ORDER_ID_FK[0] = 16 | |||
| 3 | line product | List of values on ORDER_ITEMS.PRODUCT_ID_FK[0], pick Name = Latte | ORDER_ITEMS.PRODUCT_ID_FK[0] | ORDER_ITEMS.PRODUCT_ID_FK[0] = 1ORDER_ITEMS.UNIT_PRICE[0] = 55 | |||
| 4 | line quantity | Type ORDER_ITEMS.QUANTITY[0] = 1 | ORDER_ITEMS.QUANTITY[0] | ORDER_ITEMS.QUANTITY[0] = 1 | |||
| 5 | leave quantity | Press Tab | ORDER_ITEMS.ITEM_ID[0] | ORDER_ITEMS.TOTAL_PRICE[0] = 55 | |||
| 6 | save | Click ORDERS.PUSH_BUTTON10 | FWindow/PushButton:OK | ORDERS.ORDER_ID[0] = 17ORDER_ITEMS.ORDER_ID_FK[0] = 17 | FRM-40508: ORACLE error: unable to INSERT record. | FRM-40508: ORACLE error: unable to INSERT record. | pass |
| 7 | acknowledge insert error | Answer the alert OK | ORDER_ITEMS.ITEM_ID[0] | حصل مشكلة في الحفظ، اتأكد من البيانات |
Database effects
sequence ORD_SEQ: next 16 -> 18, drawn [16, 17]
Classified diff against the migrated app
Diff: orders-save-fails counts: match 135, tolerated 194, waived 0, defect 0, unmapped 60, harness 0 generated-id pairs (source -> target): ORD_SEQ#1 -> ORD_SEQ#1 (draw order), ORD_SEQ#2 -> ORD_SEQ#2 (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.ORDER_TYPE rule=text x8 [tolerated] ui.values.ORDERS.STATUES rule=text x8 [tolerated] ui.values.ORDER_ITEMS.ITEM_ID rule=blank_rows x34 [tolerated] ui.values.ORDER_ITEMS.PRODUCT_ID_FK rule=blank_rows x34 [tolerated] ui.values.ORDER_ITEMS.QUANTITY rule=blank_rows x34 [tolerated] ui.values.ORDER_ITEMS.TOTAL_PRICE rule=blank_rows x34 [tolerated] ui.values.ORDER_ITEMS.TOTAL_PRICE rule=money x3 [tolerated] ui.values.ORDER_ITEMS.UNIT_PRICE rule=blank_rows x34 [tolerated] ui.values.ORDER_ITEMS.UNIT_PRICE rule=money x5 [unmapped] ui.alert.title (browser dialogs have no title) x1 [unmapped] ui.record (no target counterpart) x8 [unmapped] ui.seen.alert.title (browser dialogs have no title) x1 [unmapped] ui.seen.lov.column.Price (column not shown in the target) x1 [unmapped] ui.seen.lov.title x1 [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.