Ex1:
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)
SALES_ORD_ID VARCHAR2(15)
PLANNED_SHIPMENT_NBR VARCHAR2(1)
CURR_BILL_LETTER VARCHAR2(2)
PARENT_BOM_ID VARCHAR2(25)
STATUS VARCHAR2(1)
DTTM_STAMP_ORIGINAL DATE
Output required:
-
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.