My Oracle Support Banner

E1: 41: As Of Complete Generation (R41542) was Run by Accident Corrupting the As Of (F41112) File (Doc ID 2596789.1)

Last updated on OCTOBER 26, 2020

Applies to:

JD Edwards EnterpriseOne Inventory Foundation - Version 8.12 and later
Information in this document applies to any platform.

Symptoms

On September 6, Item As Of Processing (R41542) was accidentally run in Complete Regeneration Mode. This caused all the As Of (F41112) records previously in the database to be deleted. Then the system attempted to recreate the Item As Of (F41112) records from all the millions of Item Ledger (F4111) records that have accumulated since the system was first installed several years ago. The problem with As Of Data (F41112) was not discovered until the month-end Item Balance / Ledger Integrity Reports (R41544) were run. The client is not sure at this time the extent of the compromised data. They have reviewed Item Balance / Ledger Integrity Reports (R41544) for two branch plants as follows:

At this time it is not clear how many other Branch Plants there are or the state of that data.

Steps to duplicate:

  1. The Item As Of Processing (R41542) job is run nightly on the JDE Scheduler and there is a version a user can run on an ad-hoc basis
  2. On September 4 a user running the ad-hoc version of Item As Of Processing (R41542) changed the Regenerate Processing Option was equal to 1 (Complete Regeneration)
  3. When the job seemed to never stop processing, somebody terminated the job, causing the many As OF (F41112) records to be lost
  4. When the month-end Item Balance / Ledger Integrity Reports (R41544) were run there were many integrity variances because of MISSING/LOST As Of (F41112) records.

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.