Full Text Search (FTS) Cannot Work As Expected When Using File Document Text | Contains Phrase Search
(Doc ID 2860459.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Agile PLM Framework - Version 9.3.5.0 to 9.3.6.0 [Release 9.3]Information in this document applies to any platform.
Symptoms
Actual Behavior
Full Text Search (FTS) is not working as expected. It is not returning the expected result.
For example, there is a document object with attachment including the multiple words in the text file.
However, searching for document with File Document Text | Contains Phrase | {word} does not return the document object.
Expected Behavior
Full Text Search to return the correct result.
Steps
The issue can be reproduced at will with the following steps:
- Log into Java Client as admin user, and have Full Text Search enabled by going to Admin tab > System Settings > Full Text Search > General Information tab, and make sure below configuration is done:
Indexing: Synchronous
Index File Types: txt is included - Create a text (.txt) file with below contents:
AB1234, CD3456, EF5678 - Log into Web Client, and create a Document object.
- Go to Attachment tab, and add the text file created in step 2.
- Run Advanced Search with below criteria:
Items | Documents | Object Search
File Document Text | Contains Phrase | EF5678 - No result returned.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |