E1: 41: P41500 Response Time Is Greater Than 5 Min And Resulting In Timeout/ Web Exception
(Doc ID 2092967.1)
Last updated on AUGUST 06, 2020
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.
STEPS TO REPRODUCE
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