My Oracle Support Banner

Item Search Errors With JBO-27122 and Catalog Intermedia Index Creation Errors With DRG-13004: language is invalid (Doc ID 1435198.1)

Last updated on FEBRUARY 22, 2021

Applies to:

Oracle iProcurement - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


On 11.5.10.2, when attempting to search for an item in iProcurement on environment with multiple languages installed, an error occurs. 

On attempting to correct the issue by running concurrent requests "Rebuild Catalog Item InterMedia Index" and "Catalog Index Create - Intermedia", other errors are encountered.

Errors

In the application:

JBO-27122: SQL error during statement preparation



"Rebuild Catalog Item InterMedia Index"




Steps To Reproduce
1. Log into iProcurement
2. Search for an item.
3. Get JBO-27122 error.

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
Cause
Solution
References


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