E1: 41: R41803 Global Item Update Performance Issue (Doc ID 2241824.1)

Last updated on MARCH 08, 2017

Applies to:

JD Edwards EnterpriseOne Inventory Foundation - Version 9.0 to 9.0 [Release 9.0]
Information in this document applies to any platform.

Symptoms

On : 9.0 version, Inventory R41803

ACTUAL BEHAVIOR
---------------
R41803 coding issue

Global Reporting Code Update R41803 is coded such that the code issues identical (duplicate) update statements for as many times as there are item branch records. Meaning that for an item with seven (7) branch records, can
see many tables updated 7 times with the exact same update statement.

As if B4002430 passes in the new LITM and AITM and the existing ITM (key used to find the records in the tables listed in the UDC (UDC 40/IC)), but does NOT pass in a MCU (branch plant).

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