My Oracle Support Banner

PTSF PCODE Methods Taking Longer in ElasticSearch than in SES (Doc ID 2302577.1)

Last updated on JANUARY 04, 2021

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.


When running a Search in ELM 9.2 using SES and returning 200 rows, the Page Activate is taking about 7 seconds.  Performing the same search with ES and returning 200 rows, the same Page Activate is taking over 14.4 seconds.  It appears that the PTSF_ES functions are taking longer than the SES based PT_SEARCH functions.

Steps to Replicate:

Perform the Class Advanced Search in ELM 9.2 configured for SES and compare the same search when configured for ES.

Using the same PIA instance configured for the 2 different Search Instances. Configure Class Search Results to 200 to return the same amount of data to both searches.

Results for SES are about 7 seconds and for ES are about 14.4 seconds.


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.