Basically, a user needs to be able to enter a row into TA_BOM_BUF. Create a simple web page that would allow the user to insert the necessary data, perform a quick validation to make sure the data is valid, and enter the row into the buffer table.
Table Definition (TA_BOM_BUF)
AWEB_ROW_ID NOT NULL NUMBER
DTTM_STAMP NOT NULL DATE
INIT_LOAD_IND NOT NULL NUMBER
BOM_ID NOT NULL VARCHAR2(25)
MFG_LOC NOT NULL VARCHAR2(3)
Table created with the description provided above.
HTML page with all basic validations supporting the table schema.
Flow service which takes these inputs and inserts a row into the table.
A detailed description document for the assignment.