By Lukasz Romaszewski-Oracle on Mar 08, 2013
I have been recently helping one of Oracle Partners in migrating their Forms application to the ADF technology. It was a retail store solution and one of the main requirements was to provide quick and automatic way to scan and enter the items at the cashier desk. The bar code scanner is a relatively simple device and can be treated simply as an additional keyboard attached to the cashier’s computer. To automate entering consequential items at the desk we need to have a web page with a form which is able to dynamically create new rows (for new items) detecting some kind of key sequence e.g. enter. This way the cashier does not have to even touch the keyboard to repetively add new items to current transaction.
I have created a simple demo application based on the famous HR schema where the roles of the transaction items play the rows in the REGIONS table – this is just for sake of simplicity to reproduce it without creating additional schemas or tables.[Read More]