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