E-ES: Real Time Indexing (RTI) Does Not Work for Indexes That Have the 'Include Attachments' Checkbox Selected and There Are Attachments Added to the Transaction Tables (Doc ID 2927967.1)

Last updated on NOVEMBER 30, 2023

Applies to:

Symptoms

Real Time Indexing (RTI) does not work for indexes that have the 'Include Attachments' checkbox selected in RTI Configuration (PeopleTools > Search Framework > Real Time Indexing > Configure Real Time Indexing), and there are attachments added to the transaction tables.

When the Search Definition is configured for RTI and the 'Include Attachments' is selected, if there are attachments in the corresponding application's attachments table, regardless if the attachments are related or not to the document being indexed, RTI errors out and the results in Global Search are not current (reflecting recent updates).
It does seem that, when processing the attachments, RTI is getting all the attachments in the tables, regardless if they are related to the document being indexed.

The issue is reproduced in the customer environment with the steps below:
[Note: In the example below, the impacted index is EP_AP_VENDOR]
1. Setup RTI for index EP_AP_VENDOR.
2. Add a new vendor or modify an existing one.
3. Go to Homepage and use the Global Search field to perform a search for that vendor.
4. Note that the new vendor does not show up on the search results.


In the log file APPSRV_MMDD.LOG for PSRTISRV (<PS_CFG_HOME>/appserv/prcs/<domain_name>/LOGS/APPSRV_mmdd.log), for one of the documents being indexed, the following error is logged:

Changes

Cause

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