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:
Oracle Teleservice - Version 12.2.4 to 12.2.6 [Release 12.2]Oracle Customer Support - Version 12.2.5 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.
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
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 |