My Oracle Support Banner

E1: 41: Enhancement Request to Improve the Query Performance of Lot Master (P4108) Application (Doc ID 2874775.1)

Last updated on JUNE 03, 2022

Applies to:

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

Symptoms

When the users are using the query functionality in P4108 (Lot Master) application, they are encountering issues regarding long time for processing(e.g. up to 21 minutes for a number of "124853" registers). Due to this issue, the users cannot perform actions on P4108 in a short time frame.

It was observed that the issue is due to a long running query triggered to fetch the item availability details. The data fetched from F4108 (Lot master table) is again used to fetch item availability details in F41021 (Item availability). This causes the query to run longer.

The customer would like to have a lower time of processing when they are using a query in P4108 application.

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