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

Last updated on OCTOBER 04, 2023

Applies to:

Symptoms

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:

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

 Steps
-------
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  

Cause

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