Service: JBO-27122 Error when Accessing Knowledge Base from Service Request

Last updated on SEPTEMBER 01, 2017

Applies to:

Symptoms

Users are getting an error accessing Knowledge Base from Service Request form.

STEPS
-----
(R) Customer Support
(N) Create Service Request
 - Enter require fields
 - Save
 - Navigate to the Workbench tab
 - Click on 'Knowledge Base'
 => Get an JBO-27122 error.

ERROR
-----
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement:
  Select count(*) total
    from cs_kb_sets_vl SetEO
   where contains(SetEO.composite_assoc_index, :1, 10) >= :2
     and rownum <= :3

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement:
  select count(*) total
    from ( Select 1
             from cs_kb_cat_group_denorm   CategoryGroupDenormEO,
                  cs_kb_soln_categories_tl SolnCategoryEO
            where CategoryGroupDenormEO.child_category_id = SolnCategoryEO.category_id
              and CategoryGroupDenormEO.category_group_id = :1 /*cs_kb_security_pvt.Get_Category_Group_Id*/
              and CategoryGroupDenormEO.visibility_position >= :2 /*cs_kb_security_pvt.Get_Soln_Visibility_Position*/
              and rownum <= fnd_profile.value('CS_KB_MAX_SEARCH_RESULTS')
              and contains(SolnCategoryEO.name, :3, 10) >= :4
              and SolnCategoryEO.language = userenv('LANG')
              and (1 = :5
                 or SolnCategoryEO.category_id in (select category_id
                                                     from cs_kb_soln_categories_b
                                                    start with parent_category_id = :6
                                                  connect by parent_category_id = prior category_id ) )
              and rownum<=:7 )

Your search did not return any results.

System is currently under maintenance.
Please contact your system administrator if this problem continues.

Changes

Upgrade of the database to 10g.

Cause