ARXCSTXT: Customer Text Data Creation And Indexing Invalid Index DRG-10561 DRG-12602 (Doc ID 359339.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle Trading Community - Version 11.5.8 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

The concurrent process ARXCSTXT module: Customer text data creation and indexing ends with the
following errors.

First attempt:
----
DRG-10561: index HZ_CUST_ACCT_SITES_ALL_T1 is not valid for requested operation
----
Second attempt:
----
DRG-12602: index owner does not have the access to user datastore procedure:
"CTXSYS"."HZ_CTX_CUSTOMER_TEXT"."HZ_SITE_PROC2"

----

These errors prevent the successful creation of indexes so that users can perform TEXT searches
for customers.

The log files show the errors

Error.doc
---
ARXCSTXT module: Customer text data creation and indexing
Current system time is 13-FEB-2006 08:09:46
...
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10561: index HZ_CUST_ACCT_SITES_ALL_T1 is not valid for requested operation



Error_1.doc
---
ARXCSTXT module: Customer text data creation and indexing
Current system time is 13-FEB-2006 10:22:01
...
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12602: index owner does not have the access to user datastore procedure:
"CTXSYS"."HZ_CTX_CUSTOMER_TEXT"."HZ_SITE_PROC2"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms