Dirty Read Unable to Retrieve Value From Affected Items.Rev Found Field (Doc ID 2280406.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.5.0 to 9.3.5.0 [Release 9.3]
Information in this document applies to any platform.

Symptoms

Actual Behavior

From an Update Table Pre-Event PX using the dirty read cell.getValue()), a blank is always returned for Rev Found List of Affected Items tab of Product Service Request.

Expected Behavior

From an Update Table Pre-Event PX, to be able to get the updated value for Rev Found List of Affected Items tab of Product Service Request.

Steps to Reproduce

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

  1. Copy jar to %Agile_Home%\integration\sdk\extensions
    Source code of jar file is below:
     
  2. Login to Java Client as admin
  3. Goto Admin tab > Event Management > Events, and create below:
    - Event Type: Update Table
    - Name: MK Lot Validation - Quality Event
    - Object Type: Problem Reports
    - Table Name: Affected Items
  4. Goto Admin tab > Event Management > Event Handlers, and create below:
    - Handler Tpe Java PX
    - Name: WN_DirtyReadTest
    - Role: (All privileges role)
    - Event Action: test.WN_DirtyReadTest
  5. Goto Admin tab > Event Management > Event Subscribers, and create below:
    - Event: MK Lot Validation - Quality Event
    - Event Handler: WN_DirtyReadTest
    - Trigger Type: Pre
    - Execution Mode: Synchronous
    - Error Handling Rule: Continue
  6. Login to Web Client as admin
  7. Open Problem Reports with Affected Items
  8. Goto Affected items tab. Change the value of Rev Found
  9. Check Application Server log. See below log:
    ****** TESTING DIRTY READ *******
    ****** attribute =6787
    ****** Updated Value getValue=



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms