Search In iProcurement Errors With ORA-20000 , ORA-29902, DRG-10825 Stored Query Does Not Exist (Doc ID 1263142.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle iProcurement - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Catalog Shopping
When attempting to search for an item in the main store the following error occurs.

ERROR
-----------------------
[89]:EXCEPTION:[icx.por.req.server.RequisitionAMImpl]:The exception is : oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation

ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb481

[89]:EXCEPTION:[icx.por.req.server.RequisitionAMImpl]:Throwable 0 = java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-10825: stored query does not exist: icxzb481

Recent changes:
Moved from Linux VMWare solution to Sun Sparc.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login with a iProcurement Responsiblity:
2. In the Main Shop enter a description for the search
3. Click on the button Go


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