Before You Begin

Purpose

This Oracle By Example (OBE) describes how to extract Event Rules from EnterpriseOne objects in Web OMW.

Time to Complete

15 minutes.

Background

In this OBE, let's consider a scenario in which you are a developer extracting the existing Event Rules (ER) for an object. To complete this task, you use Web OMW (P98220W) to add the object (or related batch version or business function) to a project, run the Extract Event Rules action, and download the generated text file.

What Do You Need?

To perform the steps in this OBE, you will need:

  • Access to a JD Edwards EnterpriseOne environment with Tools Release 9.2.26.2 or later.
  • Appropriate permissions to view EnterpriseOne objects in Web Object Management Workbench (Web OMW on a web client) and to extract Event Rules.
  • An existing project or your default project in Web OMW.

Task 1: Extracting ER Using Web OMW

  1. Sign in to the EnterpriseOne web client.
  2. From the EnterpriseOne Home page, click the Navigator icon, and enter P98220W to access the Object Management Workbench - Web.
    3. Description of img1.png follows
    EnterpriseOne Home Page
  3. On Object Management Workbench - Web, verify that a default project is selected, or if needed, select another project.
  4. On the Project Objects tab, select Add Existing.
    5. Description of img2.png follows
    Object Management Workbench - Web
  5. The Add EnterpriseOne Object to Project form appears. From the General Object drop-down list, select a non-UDO object, such as a Business Function.

    The supported EnterpriseOne object types that contain ER are:

    • Application
    • Batch Application (also called a report or UBE [Universal Batch Engine])
    • Batch Version (also called a UBE version)
    • Table (table triggers are in ER)
    • Business Function (two types: C-based and Named Event Rule (NER); only NER is applicable.)
    • Table Conversion (also called TC; a type of batch application used to make changes to a database table)
  6. Click OK.

    Alternatively, you can select an existing object by searching for the object using the search option.

    1. Enter an object name in the Object Name field (for example, N0100042) and click Find.
    2. Select the object row.
    3. Click OK.
    7. Description of img3.png follows
    Search Option in Object Management Workbench - Web
  7. On the Project Objects tab, click Find if the object is not displayed in the grid.
  8. Select the object row. (Select only one row).
  9. From the More Row Actions drop-down, select Extract Event Rules.
    10. Description of img4.png follows
    Extract Event Rules
  10. On the confirmation dialog box, click OK.
    11. Description of img5.png follows
    Confirmation Dialog Box
  11. On the File Download page, select click here or select the highlighted file name.
    12. Description of img6.png follows
    File Download Page
  12. Open the download folder of your browser (for example: C:\Users\<username>\Downloads).

    The output file name uses the following format:

    <object_name>_<version>_YYYYMMDD_hhmmss.txt

    Where:

    <object_name> is the name of the selected object.

    <version> is the version of the object, if applicable.

    YYYY is the year.

    MM is the month.

    DD is the day of the month.

    hh is the hour.

    mm is the minute.

    ss is the second.

    NOTE: The timestamp is based on the date and time of the server where the background process runs, so it might not match your local time.

Troubleshooting

  1. The Extract Event Rules option is unavailable.
    1. Cause: More than one object is selected.
      Resolution: Select only one object.
    2. Cause: An unsupported object type is selected.
      Resolution: Select one of the following object types: Application, Batch Application, Batch Version, Table, Business Function, Table Conversion.
    3. Cause: You do not have permission to view objects in Web OMW.
      Resolution: Ask your administrator for the correct permissions.

  2. No Event Rules (ER) are written to the output file.
    1. Cause: The selected object does not contain any ER.
      Resolution: Select an object that contains ER.
    2. Cause: The selected object is a C business function.
      Resolution: C business functions do not have ER. Select a Named Event Rule (NER) instead.

Conclusion

In this OBE, you learned how to extract Event Rules (ER) from supported JD Edwards EnterpriseOne object types by using Web OMW (P98220W). You added an object to a project, initiated the Extract Event Rules action, and downloaded the resulting text file using the standard naming convention: <object_name>_<version>_YYYYMMDD_hhmmss.txt