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.


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 :
Form Version :
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


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