My Oracle Support Banner

E1: 42: Simultaneous Item As Of Processing (R41542) Jobs Doubled Quantities in Period Buckets (Doc ID 2512508.1)

Last updated on SEPTEMBER 13, 2019

Applies to:

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

Goal

Two As Of Processing (R41542) jobs with identical data selection ran over 3.9 million Item Ledger (F4111) records within 13 minutes of each other. There is evidence that some of the Item As Of (F41112) records in the January 2019 fiscal month and Second Quarter 2019 As Of Period had double the quantities that they should have.

The actual number of Item As Of (F41112) Records that were corrupted is not precisely known. There is an impact on the Inventory Integrity Reports (R41760 and R41544) which shows an imbalance between the Item Ledger (F4111) and Item As Of File (F41112), but this should not affect the ability to perform daily transactions and should have no impact on Quantities On-Hand and Available to fill sales or work orders.

What is the best way to fix the corrupt records in the Item As Of table (F41112) for Q1 2019. 

Solution

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
Goal
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.