My Oracle Support Banner

EAP: Performance Issues Running Voucher Elastic Search Index (Doc ID 2749174.1)

Last updated on FEBRUARY 02, 2021

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Unable to complete the indexing on vouchers into Elastic Search due to complexities of the queries and the amount of data. Until the indexes created, unable to use Kibana analytics on vouchers on PT 8.58.05, ES 7.0

There are approximately 27 million rows of voucher documents. Trying to index the vouchers the Elastic Search times out. Creating the indexes once was successful but it took 3 days. However, have not been able to subsequently recreate the index (limited the search definition to limit the data to the last 10 days but it still has not been able to finish the index).

Tried to index EP_AP_VOUCHER to Only Last 1 day. This took 1.5 hours and only indexed 13 rows. 

STEPS

1. Setup indexing for EP_AP_VOUCHER = Last 1 day
2. Process took 1.5 hours and only indexed 13 rows

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.