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 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:

  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.

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


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