My Oracle Support Banner

E1: 41: P41500 Response Time Is Greater Than 5 Min And Resulting In Timeout/ Web Exception (Doc ID 2092967.1)

Last updated on JULY 15, 2024

Applies to:

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


 When "Include Reconciled Transaction" is checked P41500 generates SQL statement using columns GPF1 and R3 which are not part of any index and this causes a huge runtime (5 minutes) in case of F0911 with many records (more than 10 million). The select does not consider the G/L Date From and Through filter entered in P41500 screen.

1. Open P41500, choose a GL date and document number. Do not check "Include Reconciled Transaction"
2. Reconcile the selected line. In F0911, GLR3 will have a value for the reconciled line.
3. Find the reconciled record by entering the GL date, document number and selecting "Include Reconciled Transaction"


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.