For ANY of your ALM projects where you want "text search", your Oracle DBA will need to add the CTXAPP role to the project's schema-user (Oracle user with same name as database/schema used by ALM for project):
CTXAPP Role :
Enables ALM to use the Oracle text searching feature.
This role exists only if the Oracle text search component was installed and enabled on the database server.
For ALM to setup the NEWly created project schemas properly, add the CTXAPP role CTXAPP Role WITH ADMIN OPTION (1) to the DB Admin user used by ALM.
➤ (1) An ALM Platform database administrative user must have privileges with Admin Option (allows this user to "grant" privilege to newly created project/schema-users).