Adding an Employees Report and Form

In this exercise, you add a report to display employee information and a form to create, update, and delete employee information.

To add an employee report and form:

1. Click the Application link on the Developer toolbar (at the bottom of the page).

   The Application home page appears.

2. Click Create Page.

3. For Page:

   1. Select Form and click Next.

   2. Select Form on a Table with Report.

      This option creates two pages, a report and form, based on a single table or view.

   3. Click Next.

4. For Identify Table or View:

   1. For Table/View Owner, accept the default and click Next. This specifies the schema owner.

   2. For Table/View Name, select OEHR_EMPLOYEES and click Next.

5. For Define Report Page, make these changes:

   1. Implementation - Select Classic.

   2. Page Name - Change to Employees.

   3. Region Title - Change to Employees.

   4. Breadcrumb - Select Breadcrumb.

      The Create Breadcrumb Entry section appears.

   5. For Select Parent Entry, click the Home link.

      Home appears in the Parent Entry field.

   6. Click Next.

6. For Define Report Page, accept the default, Do not use tabs, and click Next.

7. For Define Report Page, press the Ctrl key, select the following columns, and click Next:

   • EMPLOYEE_ID

   • FIRST_NAME

   • LAST_NAME

   • HIRE_DATE

   • SALARY

   • COMMISSION_PCT

   The columns you selected appear on the Report page.

8. For Define Report Page, accept the defaults and click Next.

   Note that the default Edit Link image resembles a small piece of paper and pencil.

   Next, define the page and region information for the form.

9. For Define Form Page, edit the following:

   1. Page Name - Enter Create/Edit Employee.

   2. Region Title - Enter Create/Edit Employee.

   3. Entry Name - Enter Create/Edit Employee.

   4. Click Next.

10. In Primary Key, accept the defaults and click Next.

11. In Define the source for the primary key columns, accept the default, Existing trigger, and click Next.

    Your table, OEHR_EMPLOYEES, already has a trigger that populates the primary key.

12. In Select Column(s), select all columns and click Next.

    These columns now appear in the Create/Edit Employee form.

13. In Identify Process Options, accept the defaults and click Next.

    These selections enable users to add, update, and create employee records.

14. For Confirm, verify the information and click Finish.