PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Schedule Search Index - Discrepancy between total documents processed vs total documents indexed

edited Apr 10, 2025 10:00PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

PeopleTools 8.60.13

OpenSearch v 2.3.0

Hello, I built a connected query that returns 393 rows of data in my database when executing the SQL on PL/SQL. When I schedule the search index and run it, the PTSF_GENFEED program is only indexing 392 documents according to the process monitor message log. I thought that I had all of my search attributes mapped correctly, so I wasn't expecting to be one row short when building the search index. The drilling URL I have set up in the query also references the correct number of fields.

Does anyone know an effective way for how I can view a list of all of the documents that were indexed so that I can compare between my query results and the documents that were indexed? Essentially, I'm trying to find the one row of data that is missing so I can determine what I need to do in terms of troubleshooting such as as map another search attribute. I am trying to avoid manually scraping through all of the hits returned for my index pattern in the Discover page on OpenSearch and cross referencing my query results. Any help

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center