My Oracle Support Banner

E1: 13: Update Unit/Serial # From F1201 (R12804) Updates the Audit Fields Without Reason (Doc ID 2777063.1)

Last updated on JULY 01, 2021

Applies to:

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

Symptoms

R12804 updates the records in JDE files, regardless of a change done for the asset or if the R12804 has been run already over it. For example, in F4801, R12804 updates the audit fields for all the assets in the data selection while there are only few assets which are changed.

Due to this issue, the audit fields are updated without any reason. Business expects only those assets records should be updated where there is a change in the asset master ( e.g. serial number/Tag number ). R12804 in production environments are overwriting millions of audit field (Program ID, User ID, Time of day) where as it should be limited to few thousands only.

 

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

  1. Change the unit number in Work with Equipment Master and run R12804. The unit number is updated as expected in the related tables along with audit fields.
  2. Change the serial number in Work with Equipment Master and run R12804. The serial number is updated as expected in the related tables along with audit fields.

  3. Do not change anything and run R12804. The audit fields are updated in the related tables.

     

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.