Introduction

This 60-minute Oracle by Example (OBE) describes how to run table operations using the Web Object Management Workbench (web client).

Starting with Tools Release 9.2.26.0, you can run table operations on Web OMW. Table operations enable you to perform actions on physical tables within a database. These operations ensure that the physical attributes of a database table align with the user specifications defined in EnterpriseOne.

You can complete all table operations directly from Web OMW including: Table Generation, Index Generation, Copy Table, and Drop Table.

Additionally, you can perform operations such as:

  • Index Generation: Currently, when using the Generate Index function, EnterpriseOne generates all indexes defined in the user specifications on development client. Web OMW provides you an option to selectively generate specific indexes.
  • Table Generation for Existing Data: When generating a table that already contains data (with added column only in table spec), you can use an ALTER command, to modify physical table and match the specifications without losing existing data.
Note: To perform table operations on your web OMW project, you must set up the appropriate database permissions. Contact your database administrator to set up these permissions.

Objectives

In this OBE, you will learn how to:

  • Prepare PET_STORE using OMW on the Development Client
  • Run the Generate Table operation using Web OMW
  • Run the Generate Index operation using Web OMW
  • Run the Copy Table operation Using Web OMW
  • Run the Drop Table operation using Web OMW
  • Run the ALTER Table operation using Web OMW
  • Verify the Table Operation Logs Using Web OMW

Background

Starting with Release 26 and Tools Release 9.2.26.0, you can run Table Operations on Web OMW.

Before You Begin

Download the par file to be used in this OBE.

Prepare PET_STORE using OMW on Development Client

You must first create an OMW project containing table objects and advance the project to use it. To describe the steps in this topic, a new project called PET_STORE is created.

  1. Sign in to EnterpriseOne (DV920) on the development client.
  2. From the Application Development menu (GH902), expand the Object Management folder, select Object Management Workbench application (P98220), or navigate to OMW from Fast Path.
    Description of img1.png follows
    Navigation to Object Management Workbench (P98220)
  3. Click Add from the menu.
    Description of img2.png follows
    Object Management Workbench
  4. Select OMW Project and click OK.
    Description of img3.png follows
    Object Management Workbench - Add EnterpriseOne Object to the Project
  5. Complete the required fields in the Summary tab and click OK.
    Description of img4.png follows
    Object Management Workbench - Project Revisions
  6. Select the PET_STORE project from the OMW Projects and click Advance Project.
    Description of img5.png follows
    Object Management Workbench - Advance Project
  7. Enter 21 and click OK.
    Description of img6.png follows
    Object Management Workbench - Confirm Project Status Change
  8. Select the PET_STORE project and click Restore.
    Description of img7.png follows
    Object Management Workbench - Restore
  9. Click Yes to confirm.
    Description of img8.png follows
    Overwrite/Delete Specs
  10. Click Yes to use project par file.
    Description of img9.png follows
    Restore Type
  11. Select PRJ_PET_STORE_60_99.par file and click Open to restore.
  12. Select the PET_STORE project and click Checkout.
    Description of img10.png follows
    Object Management Workbench - Checkout
  13. Repeat Steps 8 – 11 to restore the PET_STORE project again.
  14. Click Find to refresh.
  15. Select the PET_STORE project and click Check-in.
    Description of img11.png follows
    Highlight Project - Check-in
  16. Click Find to refresh.
    Description of img12.png follows
    Refresh

Run the Generate Table Operation Using Web OMW

In this section, you will run generate table in the Web Object Management Workbench (Web OMW).

  1. Sign in to EnterpriseOne on the web client.
  2. Navigate to P98220W (Object Management Workbench – Web) from the Fast Path.
  3. In the Object Management Workbench – Web form, enter PET_STORE on Project QBE line and click Find. Select the PET_STORE project.
    Description of img13.png follows
    Object Management Workbench -Web
  4. From the Project Objects tab, select F55TST, then click Table Operations from the More Row Actions drop-down list.
    Description of img14.png follows
    Select Table Operations
  5. Select Generate Table and click OK.
    Description of img15.png follows
    Table Operations Window
  6. Verify the target Data Source and click OK.
    Description of img16.png follows
    Generate Table
  7. Verify the result and click OK to complete.
    Description of img17.png follows
    Table Generation Result

Run the Generate Index Operation Using OMW and Web OMW

In this section, you will prepare index changes using OMW on the development client.

Preparing Index Changes on the Development Client

  1. Sign in to EnterpriseOne (DV920) on the development client.
  2. Navigate to OMW (Object Management Workbench) from the Fast Path.
  3. In the Object Management Workbench form, find PET_STORE project.
    Description of img18.png follows
    Object Management Workbench
  4. Under PET_STORE, navigate to Objects, select F55TST, then click Restore.
  5. Click Yes to confirm the action in the Overwrite/Delete Specs window.
    Description of img19.png follows
    Overwrite/Delete Specs
  6. Click Yes to use object par file.
    Description of img20.png follows
    Restore Type
  7. Restore modified TBLE_F55TST_60_99.par file (with Index changes) to test Generate Index.
    8. Note: You can also modify indexes for F55TST by selecting Design, Design Tools and selecting Start Table Design Aid.
    Description of img21.png follows
    Design Tools

Running the Generate Index Operation in Web OMW

In this section, you will run generate index in the Web Object Management Workbench (Web OMW).

  1. Sign in to EnterpriseOne on the web client.
  2. Navigate to P98220W (Object Management Workbench – Web) from the Fast Path.
  3. In the Object Management Workbench – Web form, enter PET_STORE in the Project QBE line and click Find, then select the PET_STORE project.
  4. From the Project Objects tab, select F55TST, then click Table Operations from the More Row Actions drop-down list.
    Description of img22.png follows
    Select Table Operations
  5. Select Generate Index from Table Operation, click OK.
    Description of img23.png follows
    Table Operations window
  6. Verify the target Data Source and Compare Result in the Generate Index window.
    Description of img24.png follows
    Generate Index
  7. The table index details are displayed using the Layout (JDE_Index_Detail).
    Description of 241.png follows
    Work With Table Index
  8. From the Form menu, click Generate All.
    Description of img26.png follows
    Generate All option
  9. Verify the result and click OK.
    Description of img27.png follows
    Index Generation
    Description of img28.png follows
    Generate Index
  10. Click Close to exit.

Run the Copy Table operation Using Web OMW

In this section, you will run copy table in the Web Object Management Workbench (Web OMW).

  1. Sign in to EnterpriseOne on the web client.
  2. Navigate to P98220W (Object Management Workbench – Web) from the Fast Path.
  3. In the Object Management Workbench – Web form, enter PET_STORE on Project QBE line and click Find, then select the PET_STORE project.
    Description of img29.png follows
    Project Objects
  4. From the Project Objects tab, click Add Existing. In the Add EnterpriseOne Object to Project window, select Table in the General Object field, then click OK.
    Description of img30.png follows
    Add EnterpriseOne Object to Project
  5. Search for and select an existing table (for example, F0911 – Account Ledger) and click OK.
    Description of img31.png follows
    Object Librarian Search and Select
  6. From the Project Objects tab, select F0911, then click Table Operations from More Row Actions drop-down list.
    Description of img32.png follows
    Project Objects
  7. In the Table Operation window, select Copy Table and click OK.
    Description of img33.png follows
    Table Operation
  8. Select and verify the Source and Destination Data Source and click OK.
    Description of img34.png follows
    Copy Table
  9. Click OK.
    Description of img35.png follows
    Printer Selection
  10. Verify the result and click OK.
    Description of img36.png follows
    Table Copy
  11. Navigate to View Job Status to verify the results in Report R9866W|XJDE0001.
    Description of img37.png follows
    View Job Status
  12. Click View Output from grid column when the Status changes to ‘D’ (Done).
    Description of img38.png follows
    Report - Copy Table from Web OMW Table Operation - Submitted Job Search
  13. Verify the results.
    Description of img39.png follows
    Copy Table Report
    14. Note: To complete the steps described in this section, R9866W was used to perform the Copy Table operation because of the business function timeout limit in the web runtime.

Run the Drop Table Operation using Web OMW

In this section, you will run the drop table operation in 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 PET_STORE on Project QBE line and click Find, then select the PET_STORE project.
  4. From the Project Objects tab, select  F55TST, then select Table Operations from More Row Actions drop-down list.
    Description of img40.png follows
    Table Operations
  5. In the Table Operations window, select Drop Table from Database and click OK.
    Description of img41.png follows
    Table Operations Window
  6. Change the target Data Source to Business Data - TEST and click OK.
    Description of img42.png follows
    Drop Table
  7. Verify the results and click OK to complete.
    Description of img43.png follows
    Drop Table Result

Run the ALTER Table Operation using Web OMW

Prerequisites for ALTER table:

  • Add Column(s) only.
  • Data in existing table (preserve data)
Note:
  • Alter Table uses table specifications based on the deployed or active package in the signed in environment (for example, JDV920) to run the *ALTER operation.
  • Use Promote action to update the table specifications from Central Object to the active package if needed.

Prepare for ALTER Table on the Development Client

In this section, you will prepare *Alter Table using OMW on the development client.

  1. Sign in to EnterpriseOne on the development client.
  2. Navigate to BV (Batch Versions) from the Fast Path.
  3. In the Batch Application field, enter R98403XB (Load XML Data to Table) and click Find.
  4. Click Add to add version F55PET (Copy F55PET XML to Table).
    Description of img44.png follows
    Batch Versions
    Note: Copy F55PET.xml saved in C:\E920 (on the development client).
  5. Set the processing Options.
    Description of img45.png follows
    Processing Options - Environment
    Description of img46.png follows
    Processing Option - Advanced
  6. Set the Data Selection.
    Description of img47.png follows
    Data Selection
  7. Run/submit UBE R98403XB | F55PET, and verify the result.
    Description of img48.png follows
    Report - Data Table
  8. Navigate to OMW (Object Management Workbench) using the Fast Path.
  9. In the Object Management Workbench form, find PET_STORE project.
  10. In the PET_STORE → Objects project, select F55PET and click Checkout.
  11. Click Yes to confirm the action in the Overwrite/Delete Specs window.
    Description of img481.png follows
    Overwrite/Delete Specs window
    Description of img482.png follows
    Project Folder
  12. Select F55PET again and click Restore.
  13. Click Yes to confirm overwrite, and click Yes again to use the object (.par) file.
    Description of img483.png follows
    Overwrite/Delete Specs window
    Description of img484.png follows
    Restore Type
  14. Restore the modified TBLE_F55PET_60_99.par file that includes the newly added column(s) to test the *ALTER TABLE functionality. You may also navigate to Design, Design Tools, and select Start Table Design Aid to manually add new columns to F55PET.
    Description of img50.png follows
    OMW Projects
  15. Select the F55PET and click Check-in to save changes.

Run the ALTER Table Operation Using Web OMW

In this section, you will learn how to run ALTER table operations in the Web OMW.

  1. Sign in to EnterpriseOne on the web client.
  2. Navigate to P98220W (Object Management Workbench – Web) from the Fast Path.
  3. In the OMW – Web form, enter PET_STORE on Project QBE line , click Find, and select the PET_STORE project.
  4. From the Project Objects tab, select F55PET, then click Promote from the More Row Actions drop-down list.
    Description of img51.png follows
    Select Promote
  5. Click OK to confirm the operation in the Confirm Promote of Object dialog box.
    Description of img52.png follows
    Confirm Promote of Objects
  6. From the Project Objects tab, select F55PET again, then select Table Operations from the More Row Actions drop-down list.
    Description of img53.png follows
    Select Table Operations
  7. In the Table Operations window, select Generate Table and click OK.
    Description of img54.png follows
    Table Operations window
  8. Verify the Target Data Source, then click OK.
      Description of img55.png follows
      Generate Table window
    1. If the *ALTER operation is applicable, the Form Menu automatically displays in Alter Table.
    2. Click OK, you are prompted to choose whether to run *ALTER (Yes) or proceed with a full table generation (No).
    3. Select Alter Table to proceed with the non-destructive *ALTER operation.
  9. In the Alter Table is available confirmation dialog box, click OK.
    Description of img56.png follows
    *ALTER Table
  10. Verify the results and click OK.
    Description of img57.png follows
    *ALTER Table Result
  11. Review the *ALTER TABLE log in the PrintQueue folder on the enterprise server to ensure the operation completed successfully.
    Description of img58.png follows
    *ALTER Table Log
    Description of img59.png follows
    View Log

Verify the Table Operation Logs Using Web OMW

In this section, you will learn how to verify the Table Operation OMW logging in the Web OMW.

  1. Sign in to EnterpriseOne on the web client.
  2. Navigate to P98220W (Object Management Workbench – Web) using the Fast Path.
  3. In the Object Management Workbench – Web form, enter PET_STORE on Project QBE line , click Find, and select the the PET_STORE project.
  4. In the Project Objects tab, select F0911, then choose Logging from the More Row Actions drop-down list.
    Description of img60.png follows
    Select Logging Option
  5. On the Work With Object Logs form, click Find to retrieve the log entries.
  6. Locate and select the entry with Action = 44 (Table Operations), then click Select.
    Description of img61.png follows
    Work With Object Logs
  7. Select each line to review the log details and click Select to view more information.
    Description of img62.png follows
    Work With Log Details
    Description of img65.png follows
    View Full Log Text

More Learning Resources

Explore tutorials and labs on docs.oracle.com/learn or access free learning content on the Oracle Learning YouTube channel.

For product documentation, visit Oracle Help Center.