My Oracle Support Banner

E1: 17: Total Hits (Alias: CNTF) Field in Failure Analysis Pareto Table - F48166 is Incremented Incorrectly After Hitting Save Buttton in Failure Analysis - P17767 Screen (Doc ID 2740360.1)

Last updated on DECEMBER 28, 2020

Applies to:

JD Edwards EnterpriseOne Capital Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Whenever hitting OK button in the P17767 - Failure Analysis Revisions screen on either the Failure, Analysis or Resolution tabs and irrespective of making an actual change or just checking the data without doing any modifications, the field Total Hits (Alias: CNTF) in the Pareto Analysis (P177661) screen is incremented by 1.

The issue can be reproduced at will with the following steps:

  1. P17762 - Inquire on a Failure Tree and take the Row Exit to Tree
  2. P17762 - Drill into the Failure Analysis Tree and find a Failure Code that is associated to a Failure Analysis record (i.e. Failure 2 - Parent Key ID = 120; Unique Key ID = 122; Unique Key ID 01 = 61)
  3. P17762 - Select the Failure Analysis Type "Analysis". Select the tree and find an associated Analysis record (i.e. Analysis 1 - Parent Key ID = 122; Unique Key ID = 122; Unique Key ID 01 = 63)
  4. P17762 - Select Failure Analysis Type "Resolution". Select the tree and find an associated Resolution record (i.e. Resolution 2 - Parent Key ID = 126; Unique Key ID = 126; Unique Key ID 01 = 68)
  5. P48201 / P17714 - Create a maintenance order and use the Visual Assist in the Failure Description field to access the failure record in step 2 (i.e. Failure 2 - Parent Key ID = 120; Unique Key ID = 120; Knowledge Base Code ID = 61; Knowledge Base ID = 79)
  6. P48201/P17714 - Save the Work Order
  7. P48201 - Re-inquire on the maintenance order; navigate to Row Exit > Add/Revise FA (P17767)
  8. P17767 - Click on the Analysis tab and click on the visual assist in the Analysis Description field
  9. P17767 - Select the analysis record from step 3 (i.e. Analysis 1 - Parent Key ID = 122; Unique Key ID = 122; Knowledge Base Code ID = 63; Knowledge Base ID = 81) and press Save
  10. P48201 - Re-inquire on the maintenance order; take Row Exit > Add/Revise FA option
  11. P17767 - in the Analysis tab, click on Modify Analysis Record and notice that Pareto button is displayed
  12. P177661 - Click on the Pareto button; note the number in the Total Hits (alias CNTF in F48166) field in the Pareto Analysis screen (P177661) = 2. Click OK to exit the screen.
  13. P48201 - After saving the record, re-inquire on CAM work order and take Failure Analysis > Add/Revise FA option. Click on the Resolution tab and click on the visual assist in the Resolution Description field.
  14. P17767 - Select the Resolution record from step 4 (i.e. Resolution 2 - Parent Key ID = 126; Unique Key ID = 126; Knowledge Base Code ID = 68; Knowledge Base ID = 85) and press Save
  15. P48201 - Select the CAM work order; take Row exit > Failure Analysis > Add/Revise F/A option
  16. P17767 - in the Resolution tab, click on Modify Resolution Record and notice that Pareto button is displayed
  17. P177661 - Click on the Pareto button; note the number in the Total Hits (alias CNTF in F48166) field in the Pareto Analysis screen (P177661) = 1. Click OK to exit the screen.
  18. P48201 - Select the CAM work order; take Row exit > Failure Analysis > Add/Revise F/A option; Click on the Analysis tab and click on OK button save without doing any changes, without taking any other options; exit the screen.
  19. P48201 - Select the CAM work order; take Row exit > Failure Analysis > Add/Revise F/A option; in the Analysis tab, click on Modify Analysis Record button and Pareto button is now available
  20. P177661 - Click on the Pareto button; note the number in the Total Hits (alias CNTF in F48166) field in the Pareto Analysis screen (P177661) = 6; notice that the Total Hits (F48166.CNTF) has incremented even though there is NO difference in Pareto combination of Failure / Analysis and Resolution types.
  21. Databrowser: F48166 - CNTF is showing the Total Hits for each failure analysis type incremented for each OK button hit.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.