R12: OKE: Funding Workbench - Administrator List of Values (LOV) Performance (Doc ID 2305870.1)

Last updated on SEPTEMBER 09, 2017

Applies to:

Oracle Project Contracts - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

After upgrade from 12.1.3. to 12.2.6, the new field Administrator which has
been added, takes a very long time to popup.

It has taken from 1 minute to 10 minutes. The ideal time should be a few
seconds < 5 seconds.

Current Form:
----------------------------------------
Form Application : Project Contracts
Form Name : OKEKFDWB
Form Path :
/tetd/app01/appl/fs1/EBSapps/appl/oke/12.0.0/forms/US/OKEKFDWB.fmx
Form Version : 12.0.13.12020000.42
Form Last Modified : $Date: 2016/04/18 22:51 $

Trace file shows the problem statement:

select full_name, person_id, employee_number
from pa_employees order by full_name


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