My Oracle Support Banner

E1: 09: Revise Company Currency Conversions (P1114) Does Not Update the Time Updated (UPMT) Field Correctly After Making a Change to the Record Which Results in Stale Audit Information in Field Time Updated (Doc ID 2959281.1)

Last updated on JULY 05, 2023

Applies to:

JD Edwards EnterpriseOne General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When revising/changing a detail record in Revise Company Currency Conversions (P1114), the Time Updated (UPMT) field does not use the actual time the record was updated. The Time Updated currently populates the time when the user was in Work with Company Currency Conversions, which is the prior step.

Steps to duplicate:

  1. Verify the current Time updated on the Company record. Go to Databrowser for F1114 and select the Company record. In my example I am using Computation ID method B. Note the value in the Time Updated field on the far right.
  2. From Work With Company Currency Conversions, select one of the company records. You can isolate this by the Computation ID as noted in step 1.
  3. This will take you to Revise Company Currency Conversions, and stay in this screen for several minutes (10 minute or more) prior to making a change such as changing the Override Rate.  This is to compare the difference in the time updated field.
  4. After waiting 10 or more minutes, select the first record from Revise Company Currency Conversions and update the line to have a different Override Rate.
  5. Accept the change and come out of the transaction completely.
  6. Immediately go to Databrowser and note that the minutes and seconds are not correct. It is retaining the Time updated from when the user was on the prior screen (Work With Company Currency Conversions) rather than when the user actually updates the record in Revise Company Currency Conversions. 

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.