Oracle Text Errors: ORA-20000 DRG-10502 DRG-10701 Preference JTF_NOTE_FILTER or Policy JTF_NOTE_POLICY ORA-06512 (Doc ID 2204720.1)

Last updated on DECEMBER 19, 2022

Applies to:

Symptoms

The following may occur when applying a Service patch or working with Service Requests:

1. When attempting to apply the a Cumulative Service Patch (i.e. 24740298:R12.CS.C - Oct 2016, 29160092:R12.CS.C - Jan 2019):

      ERROR at line 1:
       ORA-20000: Oracle Text error:
       DRG-10701: preference APPS.JTF_NOTE_FILTER already exists
       ORA-06512: at "CTXSYS.DRUE", line 160
       ORA-06512: at "CTXSYS.CTX_DDL", line 26
       ORA-06512: at line 2

2. While creating or updating Service Requests with Notes in HTML:

     ## Detail 0 ##
         java.sql.SQLException: ORA-20000: Oracle Text error:
         DRG-10502: index JTF_NOTE_POLICY does not exist
         ORA-06512: at "CTXSYS.DRUE", line 160
         ORA-06512: at "CTXSYS.CTX_DOC", line 1633
         ORA-06512: at "APPS.JTF_NOTES_PUB", line 2983
         ORA-06512: at line 1

3. While creating or updating Service Requests in TeleService:

       APP-JTF-210604: Program error: please inform your system administration or support representative that:
              jtf_grid.populate package reports error:

       An unexpected error occurred in jtf_grid.populate
               grid      : <WKB_GRID_CONTROL.RESOLUTION_HISTORY>
               datasource: <CS_SR_SERVICE_REQUEST_NOTES>

      The following information is available:
            <null>

      The error is most likely in the form or the metadata definition.
      Please check the following alert for the error code.

      Click OK and the following error displays:

            The error stack is (first 1000 bytes):
            ORA-20000: Oracle Text error:
            DRG-10502: index JTF_NOTE_POLICY does not exist
            ORA-06512: at "APPS.JTF_GRIDDB", line 837
            ORA-06512: at "CTXSYS.DRUE", line 171
            ORA-06512: at "CTXSYS.CTX_DOC", line 1693
            ORA-06512: at "APPS.JTF_NOTES_PUB", line 2983
            ORA-06512: at line 1
            ORA-06512: at "SYS.DBMS_SQL", line 1726
            ORA-06512: at "APPS.JTF_GRIDDB", line 768
            ORA-06512: at "APPS.JTF_GRIDDB", line 878

Steps:

Apply a cumulative patch for E-Business Suite - CRM Service Release 12.2.4 or 12.2.5.

   - or -

(R) Customer Support Specialist
(N) Agent Dashboard
 - Create or Update a Service Request

Changes

Cause

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