Oracle Text error: DRG-10599: column is not indexed

New install of version 22.2.2.20230304, search in the public application gives an error:

report error:
Oracle Text error:
DRG-10599: column is not indexed

Same error on page 11 of admin app when using report search field.

If the application is upgraded from the previous version, the problem doesn't occur.

Root cause Supporting objects install scripts creates index to wrong column. Upgrade script works correctly.

Workaround Run in application parsing schema:

drop index blog_posts_ctx force;
create index blog_posts_ctx on blog_posts(post_txt_search)
indextype is ctxsys.context parameters(
  'datastore      blog_post_uds_ds
   lexer          blog_post_uds_lx
   section group  ctxsys.auto_section_group
   stoplist       ctxsys.empty_stoplist
   filter         ctxsys.null_filter
   sync           (on commit)'
);

jariolaine / apex-blog

Oracle Text error: DRG-10599: column is not indexed #8