Challenge Overview
Web Order and Invoice (WOI) is a supplier-facing Web application, accessible by enabled Suppliers via the Internet and manages the exchange of Order Management & Accounts Payable Business Transactions with suppliers via standard web browser interface. WOI is part of the PeS application suites that follows a typical development (Dev) and release cycle.
In the upcoming releases, WOI is implementing security remediation affecting how the system will be configured and how errors will be generated and displayed. As such, WOI is looking for a set of mini-utilities that can be put together as a single cohesive tool in support of these remediation functions. This is the first series of utility creation competitions in this area. This series include
- this (design) competition – dealing with Java graphical user interface for error code and error message retrieval from a new database table
- a ‘sister’ (design) competition – WOI Security Scan Configuration Update and Validation Utility – dealing with Java graphical user interface in validating configuration from the database table and the ability to retrieve, update, insert, and delete data from the table.
These design competitions will be followed by the actual utility development competitions that can then be integrated together as a single tool. In addition, this error code and message utility may be expanded to load System log files and retrieve a specific section of the log file base on the user input error code.
As part of the remediation work, there will be a new set of error codes mapped to new messages defined in a new database table. In this competition, we are looking for a standalone Java graphical interface utility that follows a defined set of rules in retrieving the corresponding error message given an error code from the database table. This utility may be used by different levels of personnel including developers, testers and helpdesk as a quicker way of error code and message retrieval with similar intelligence offered by the application without manually performing the logic with tool such as IBM DB2 client.
Final Submission Guidelines
N/A