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

Last updated on JULY 04, 2016

Applies to:

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

Symptoms

 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"

Cause

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 hundreds of Community platforms