1. Web Object Management Workbench Guide
  2. Run Generate Table Using Web OMW

Run Generate Table Using Web OMW

This section explains how to perform the Generate Table operation using the Web Object Management Workbench (Web OMW).

  1. Sign in to EnterpriseOne on the web client.
  2. Navigate to P98220W (Object Management Workbench – Web) using Fast Path.
  3. In the Object Management Workbench – Web form, enter the desired criteria in the Query by Example (QBE) columns, and then click Find. Then select the desired project.
  4. Go to the Project Objects tab and select the Table you created or modified using OMW. Click Table Operations from the More Row Actions drop-down.
  5. In the Table Operations window, select Generate Table and click OK.
  6. Select and verify the target Data Source (If the *ALTER operation is applicable, the "Alter Table" option automatically appears in the Form Menu).
    1. Click OK to prompt the popup window, you either run the ALTER Table operation (Click Yes) or proceed with a full table generation (Click No).
    2. Click Alter Table to proceed without being prompted for confirmation.
  7. Click OK.
  8. Verify the result and click OK to complete.
Note: For ALTER Table:
  • You can only add columns.
  • Existing data in the table is preserved.
  • The *ALTER TABLE operation uses table specifications from the deployed/active package in the sign-on environment.
  • Use the Promote action to update table specifications from Central Objects to the active package, if necessary