Working with Object Usage Tracking


Options



Before You Begin

Purpose

This Oracle by Example (OBE) shows you how to:

  • Configure Object Usage Tracking

  • Execute EnterpriseOne Objects

  • Review Object Usage Tracking Detail

  • Summarize Object Usage Tracking

  • Review Object Usage Tracking Summary
  • Review Object Usage Tracking Composite Page

  • Run Object Usage Tracking Purge Reports

Time to Complete

20 minutes

Background

JD Edwards EnterpriseOne Object Usage Tracking provides enterprise wide visibility on JD Edwards EnterpriseOne interactive applications, batch applications (UBEs), and business functions executed, customized and patched in your environments. Out of the box UX One analytics help you identify modules in use, usage patterns, as well as peak usage and load across environments to give greater insight for usage, performance, issue analysis, and managing compliance.

What Do You Need?

  • JD Edwards EnterpriseOne Tools Release 9.2.2.0 installed

  • Latest ESU for bug #25306327 containing the Object Usage Tracking User Defined Objects applied.

  • Tools ESU containing bug #25077539 and #26024939 applied

Configuring Object Usage Tracking

You must configure Object Usage Tracking to determine the amount and level of tracking within JD Edwards EnterpriseOne. The Object Usage Tracking Configuration (P980042T) application is used to enable and disable object tracking at various levels, including system, path code, and object type. You can determine which objects are excluded from object tracking with Exclusions Lists.

Enable Object Usage Tracking for a Path Code

You enable Object Usage Tracking at the system and path code levels. You can choose to track object usage in one path code or multiple path codes.

  1. Navigate to: EnterpriseOne Menus/ EnterpriseOne Life Cycle Tools/Application Development (GH902)/Object Usage Tracking.

  2. Click Object Usage Tracking Configuration.

  3. Enable Object Usage Tracking at the system-level by checking the System Level Tracking Enabled checkbox.
  4. Enable Object Usage Tracking at the path code level by clicking the icon in the Tracking column for the DV920 path code. The Tracking icon will be a green circle when the path code is enabled for object tracking. A save is not required as the value change is automatically updated in the database.
  5. Revise Object Usage Tracking Enablement
    Revise Object Usage Tracking Enablement

Activate Object Types

You can enable and disable object tracking by object type (APPL/UBE/BSFN) and you can track one or multiple object types.

  1. In the Object Usage Tracking Configuration application, select the DV920 grid row and click Object Type Tracking from the Row menu.

  2. On the Revise Object Type Enablement form, enable object tracking for all object types listed in the gird by clicking in the Tracking column for each grid row. The Tracking icon will be a green circle when the object type is enabled for object tracking. A save is not required as the value change is automatically updated in the database.

    Revise Object 
                                    Type Enablement
    Revise Object Type Enablement
  3. Close the form.

Create Exclusion Lists

You can reduce the number of JD Edwards EnterpriseOne objects that are being tracked by adding them to an exclusion list. Exclusion lists are maintained by path code. If an application, batch application, or business function is on a path code’s exclusion list, the system will not create an F98911 or F98912 record for that object when it is executed.

  1. In the Object Usage Tracking Configuration application, select the DV920 grid row and click Exclusion List from the Row menu.

  2. On the Object Exclusion List form, add the following objects to the grid and click OK:
        • P98305W (Batch Versions – Web Version)
        • B0701630 (Create Historical Payroll Register Cache)
        • R07345 (Historical Payroll Register)
    Object Exclusion List
    Object Exclusion List
  3. Click the OK button to save the changes.
  4. For this OBE, restart the HTML and Enterprise Servers, so these configuration changes are immediately recognized by the system. Otherwise, the Object Usage Tracking configuration on the servers will be updated every 60 minutes. Once the server restarts are complete, log back into JD Edwards EnterpriseOne.

Execute EnterpriseOne Objects

After Object Usage Tracking is enabled for the system, path code, and object type, object tracking detail records are inserted into the F98911 or F98912. If the executed object is not specified in the path code Exclusion List. Applications and UBEs are written to F98911 when the object is launched. Business function calls are accumulated in memory and the counts are written to the F98912 every 45 minutes. One exception to this is when business functions are executed by an UBE.  In this case, the function accumulated in memory while the UBE is processing, but are written to the F98912 when the UBE completes.

Execute the R07345 Batch Application

  1. Open the Batch Versions application (Fast Path: BV).

  2. Enter R07345 in the Batch Application field and click the Find button.
  3. Select the XJDE0001 version in the grid and click Processing Options from the Row menu.
  4. Set the following processing option values:
        • Payroll Type: <blank>
        • Summary Mode: 0
        • Payroll Tax Year: 05
        • Partial Year Date From: <blank>
        • Partial Year Date Thru: <blank>
  5. Select the XJDE0001 version.
  6. On the Batch Versions – Version Prompting form, check the Data Selection checkbox and click the Submit button.  On the Data Selection form, add a condition where Address Number (F060116.AN8) is equal to 7500.  Click the OK button to save the data selection.
  7. Click the OK button to verify processing option values (if prompted) and click the OK button to submit the UBE to the server for processing.

Execute the Address Book Application

  1. Open the Address Book application (Fast Path: P01012).

  2. In the grid’s Address Number QBE field, enter 7500 and click the Find button.
  3. Select the grid row and click Who’s Who from the Row menu.
  4. On the Who’s Who form, select the grid row with Line Id equal to zero and click Phones from the Row menu.
  5. Exit out of the Address Book application.

Execute the Speed Time Entry Application

  1. Open the Speed Time Entry application (Fast Path: P051121).

  2. On the Work with Time Entry by Individual form, click the Find button.
  3. In the grid menu bar, click the Go to End icon.
  4. Exit out of the Speed Time Entry application.

Review Object Usage Tracking Detail

Review Object Usage Tracking Detail for Applications and Batch Applications

  1. Navigate to: EnterpriseOne Menus/ EnterpriseOne Life Cycle Tools/Application Development (GH902)/Object Usage Tracking.

  2. Click Object Usage Tracking Detail.

  3. Click the Find button. The grid will display all object tracking records for applications and batch applications in the F98911 table with the most recent records first. In the below list, note that the P98305W is not included because it was added to the Exclusion List for the DV920 pathcode.
  4. Work with Object Usage Tracking Detail
    Work with Object Usage Tracking Detail

Review Object Usage Tracking Detail for Business Functions

  1. Open Data Browser: (Fast Path: databrowser).

  2. Open the F98912 table.

  3. Click the Find button.  The grid will display all object tracking detail records for tracked business functions with the most recent records first.  Below is a list of the business functions executed by the R07345 batch application, except for the functions associated with the B0701630 object name, which was added to the Exclusion List for the DV920 path code.  As a result, there are no detail records in the F98912 for InitializeHistoricalPayrollCache, ProcessHistoricalPayrollCache, ClearHistoricalPayrollCaches, and EndHistoricalPayrollCache.

    Data Browser with F98912
    Data Browser-F98912

Summarize Object Usage Tracking

The Object Usage Tracking Summary (R98902) UBE summarizes application, batch application, and business function detail tracking records from the F98911 and F98912 and inserts the summarized records into the F98902 table. The object usage counts are summarized to provide totals by day, month, and year. Totals can be grouped by object name, object name|form|version, or product code.

Important: The R98902 will only summarize detail records up to, but not including, the current date, so any tracking records created today cannot be summarized until the R98902 is run tomorrow.  Therefore, do not proceed with the remaining steps until tomorrow, so the R98902 will process the detail records created today by the steps in the previous section.

  1. Open Batch Versions: (Fast Path:  BV).
  2. Enter R98902 in the Batch Application field and press the Find button.
  3. Select the XJDE0001 version in the grid and click Processing Options from the Row menu.
        • Path Code: DV920
        • Tracking Type: 01
  4. Submit the XJDE0001 for execution.  The XJDE0001 version will summarize Object Tracking Details by object name and generate daily, monthly, and yearly totals.  After the batch application has completed, the report will state that the process completed successfully.

    Object Usage Tracking Summary Report
    Object Usage Tracking Summary Report

Review Object Usage Summary

After the R98902 has summarized the Object Tracking Details records, the summary records can be reviewed using the Object Usage Tracking Summary (P98902) application.

  1. Navigate to: EnterpriseOne Menus/ EnterpriseOne Life Cycle Tools/Application Development (GH902)/Object Usage Tracking.
  2. Click Object Usage Tracking Summary.
  3. Click the Find button to display summary data in the grid.  There will be multiple rows for each object in the grid, in order to display the totals by the different summary units (day, month, year).
  4. Enter “01” in the QBE field for the Tracking Unit grid column and Click the Find button again.  This will display the daily totals for each summarized object.  Take note of the date values listed in the To Date column.  These will be used in the next section for data selection.
    Work with Object Usage Tracking Summary Application
    Work with Object Usage Tracking Summary Application

Review Object Usage Composite Page

The Object Usage Tracking composite page presents four charts to visually display usage counts using detail records from the F98911 or summary records from the F98902. The usage counts can be viewed by object, by product, by path code, or by daily peak usage. Additional filter capabilities are provided to restrict the data displayed in each chart.

  1. Click the Home button in the EnterpriseOne Carousel to go to your homepage and click the Object Usage Tracking page link.  This will display the Object Usage Tracking composite page.
  2. Click the Popup Content icon for the Usage Count by Object Name application located in the upper left quadrant of the composite page to display the chart in a popup and increase its size.
  3. Click in the Path Code field and select DV920 from the drop down list.
  4. Click the Open Menu icon in the upper left hand corner of the page to view additional selection options.
  5. Press the Filter icon to add additional query conditions. 
  6. Add the following filter conditions for the To Date column, using the date values identified in the P98902 form from the prior section.  Click the Apply Filer icon to apply the filter conditions and reload the chart data.

    Query Options
    Query Options
  7. The chart is updated with the usage counts for the EnterpriseOne objects executed in a prior section.  If you hover over an object from the legend on the right, the object description will appear and the associated bar in the chart will be highlighted.  If you hover over a bar in the chart, the object description and usage count will appear.
    Composite Page Graph
    Composite Page Graph

Run the Purge Batch Application

After object tracking data is summarized in the Object Usage Tracking Summary (F98902) table by the R98902, the detail records can be deleted from the F98911 and F98912 using the R98911P and R98912P.

  1. Navigate to: EnterpriseOne Menus/ EnterpriseOne Life Cycle Tools/Application Development (GH902)/Object Usage Tracking.
  2. Click Purge Object Usage Tracking Detail.
  3. Select the XJDE0001 version in the grid and click Processing Options from the Row menu.
  4. Set the following processing option values:
        • Proof or Final Mode: 1
        • Path Code: DV920
        • Object Tracking Purge From Date: <blank>
        • Object Tracking Purge To Date: <Enter Today's Date>
  5. Submit the XJDE0001 for execution.  The R98911P will delete all records up to today’s date from the F98911.  After the UBE has completed, the report will state that the purge was successful.
  6. Navigate to: EnterpriseOne Menus/ EnterpriseOne Life Cycle Tools/Application Development (GH902)/Object Usage Tracking.
  7. Click Purge Business Function Tracking Detail.
  8. Select the XJDE0001 version in the grid and click Processing Options from the Row menu.
  9. Set the following processing option values:
        • Proof or Final Mode: 1
        • Path Code: DV920
        • Object Tracking Purge From Date: <blank>
        • Object Tracking Purge To Date: <Enter Today's Date>
  10. Submit the XJDE0001 for execution.  The R98912P will delete all records up to today’s date from the F98912.  After the batch application has completed, the report will state that the purge was successful.

Want to Learn More?