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!