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 APRIL 04, 2022

Applies to:

Oracle Agile PLM Framework - Version and later
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.