My Oracle Support Banner

Full Text Search (FTS) Cannot Work As Expected When Using File Document Text | Contains Phrase Search (Doc ID 2860459.1)

Last updated on OCTOBER 23, 2023

Applies to:

Oracle Agile PLM Framework - Version to [Release 9.3]
Information in this document applies to any platform.


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.


The issue can be reproduced at will with the following steps:

  1. 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
  2. Create a text (.txt) file with below contents:
    AB1234, CD3456, EF5678
  3. Log into Web Client, and create a Document object.
  4. Go to Attachment tab, and add the text file created in step 2.
  5. Run Advanced Search with below criteria:
    Items  | Documents | Object Search
    File Document Text | Contains Phrase | EF5678

  6. No result returned.




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

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