My Oracle Support Banner

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

Last updated on FEBRUARY 07, 2019

Applies to:

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


On : 9.0 version, Inventory R41803

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 each updated table updated multiple times with the exact same update statement. 

B4002430 passes in the new LITM and AITM and the existing ITM is used as the only key when fetching records from tables listed in UDC 40/IC (Inventory/Item Change Files), this can result in an entire table scan. A table scan will cause the process to execute very slowly.  Base Code is designed in such a way that the data is processed dynamically based on LITM only.  Changing this base design needs an enhancement effort.




To view full details, 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 a vibrant support community of peers and Oracle experts.