My Oracle Support Banner

E-RTI: Real Time Indexing Not Working for Custom Search Definitions (Doc ID 2976961.1)

Last updated on OCTOBER 04, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.


Real Time Indexing is not working for custom search definitions. After creating a custom search definition and enabling RTI, the data changes are not Indexed to Elasticsearch. However, when the incremental PTSF_GENFEED index built is run, all the changes are moved to Elasticsearch as expected.

Looking at the PS_CFG_HOME/appserv/prcs/<Domain>/LOGS/APPSRV_MMDD.LOG file, it shows different kinds of SQL errors like:

Return: 904 - ORA-00904: "ALIAS"."FIELDNAME": invalid identifier

In order to replicate the issue, follow these steps:

1) Create a custom search definition.
2) Configure and enable RTI for the definition.
3) Make some data changes in the trigger records.
4) Verify the PS_CFG_HOME/appserv/prcs/<Domain>/LOGS/APPSRV_MMDD.LOG file  


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.